Modeling

MAKELINK -Should be easy...
All right, I did the very easy Makelink modules and added it to a dashboard. What my "click here" button should do is direct users to a Sharepoint on our network where we made/created documentation related to our dashboards. If I make the URL www.google.com it works. If I put our HTTP://Company Sharepoint URL (example:…
Allow users to add multiple numbers into a cell
Adaptive Insights has this feature where an end user can "split" the value of a an input cell into several values to have that amount roll up and be displayed as a line item. Customers of Adaptive really like this feature and in competes with Adaptive, we get asked for a similar function.
Anaplan Connect
Hello Experts I am new to Anaplan . Want to know the sequence of releases for Anaplan. Also let me know any reference document with this details Regards Sam
Returning one line items value using other line items
Hi all, I'm trying to find a way to return the value of one line item in a list, using two other line items. Background: I have one large module built off sequence numbers as the rows, and line items as the columns (no page dimensions). Each row is a seperate transaction (either a product being added or a product being…
Copying data from one list member to another
Hi I need to copy data for a particular line item (number format) which is a user input from one list member to another. Use case: We have set up a target setting model wherein User will input targets for their Financial Metrics at various stages throughout the year. The stages are performed one after another in a periodic…
Allow scaling in Module formats for line items
Allow scaling in Module formats for line items. For example to allow dollars to be expressed as "Millions of dollars" or "Thousands of dollars". How would it help your business process: One example- We use Anaplan for budgeting and drop Anaplan data into reports for senior leadership. No executive wants to see the budget…
Importing Line Items with 4 or more dimensions to a Numbered List
In my model I have a number of modules that are dimensioned by 4 Lists, typically Time, Region, Resource and Product (e.g. hours worked by Resource A on Product B in Region C in Week D. I want to save changes to line items in these modules to a Numbered List with Time, Region, Resource and Product as Properties along with…
Copying a model
Hi We are trying to find out if we can create a process to copy a model into a new model. Anybody having any idea about this? Basically, we want to autoamte the model copy activity. Thanks Regards Prabakaran
Anaplan issuing new certificate on Dec 8, 2018
Update (May 31, 2019) Please see the Anaplan-Generated Certificates to Expire at the End of 2019 blog for more information. Original message: Based on customer feedback and to allow admins additional time to transition to new integration clients, Anaplan will be issuing a new Anaplan certificate on December 8, 2018. The…
turn off subsidiary view in module after "version" is added
Hi All, I was wondering if anyone might have experience in this issue I am having. I built out a few modules and am now realizing that I need to add the versions dimension to a few. However, when I apply the versions the module changes to a subsidiary view and therefore eliminated the ability for data to be manually…
Define Conditional Formatting for a Line Item in the Blueprint
Currently Conditional formatting has to be defined for a view and then published or republished to a dashboard if changes are made. I would like to see the ability to define a conditional format against a line item in the Blueprint instead. In addition the ability to choose whether to show conditional formats or not when…
Time Summary: MoM, QoQ, and YoY on the same line item
Hi all, I am trying to create a "% growth" line item, where this line should be able to represent MoM, QoQ, and YoY on the same line (with or without the use of working line items) As time summary does not allow us to use OFFSET or PREVIOUS, what should be the best workaround for this? (Note: with the creation of new…
formula format
Colour code the formula or function part of each component, so that we can see where the components are. All formulas and functions are blue and rest of text black.
Months Spread
Hi, I am trying to figure out why my mothly cost will not populate based on the formula I provided. The goal is to show the monthly cost for only a certain time range and for the cost to not populate in the months it doesn't apply to. My issue is the cost will not populate at all. Attached are screenshots of my formula and…
Regression Test automated
Dear all, One of my customers is thinking about how to organise regression test. Goal is to run automatically a script for 2 models (on older version and the current version with new changes) and to see if the calculated results are the same. This is to prevent having full integrated each time when changes have applied.…
Numbered Lists to Assign Employees to Projects
Hi Everyone, I am working on an internal model where the goal is for employees to input their monthly hourly estimates based on projects they are assigned to. I want employee to be able to go in and input weekly time assumptions based on project. I have created the following lists: Total Company L1, Clients L2, #Projects…
Quick reference guide for Data Hub Setup
Quick reference guide on check points to be considered before going ahead with Data Hub Setup * Commit* Any data that goes in and out of Anaplan should use Data Hub - Get an alignment with business users, model builders & IT team that any data that goes IN and OUT of Anaplan will go through Data Hub. * Answer* What Data?…
Export only current page selection
Description: As a model builder, I want to give users the ability to efficiently export their dashboard grids. Currently, when you save an export definition on the "Current Page", this current page does not change when the export action is published to a dashboard based on that dashboard's page selectors. Example of the…
Create a number of items in numbered list
Where we use the create action to add an individual item, could we have a break where it asks for how many items to add, much like when doing it in the list itself. This will help to reduce the number of blocking actions as a user hits the button once instead of 10 times and may help in not having to pre populate with…
Formula/process to override user select boolean?
Is it possible to have a boolean which is user selectable but that can be also overridden by either a formula or process? For context, in a dashboard I have a module which is read only unless the user selects a boolean to make it writable; the boolean doesn't control the write access directly but rather feeds into a…
Very first column width
Hey, I have got some troubles with widening first column containing line items, so they are partialy displayed due to narrow size of that column
Count Qty based on the unique identifier
Hi , please go through the attached SS. I am looking for that solution.I have a data module which have a numbered list ref and properties as shown in SS . I am looking for the number of total email sent by the each unique sender based on the sent status in a new module. Please help me out with this asap. Thanks.
Ability to require user to confirm and/or enter specific text before action / process will run
I would like a way to help prevent accidental clicking of buttons that run important / irreversible actions (like a large deletion for instance). Here are some ideas on how I think one might go about tackling this, when the user clicks a button with this prevention measure enabled: * Show the user a warning message, where…
subsidiary views are blank
I am trying to create a module which is a summary by a single dimension Source: Time, Cost Centre, Account Destination Cost Centre for my destination line item I have Year in the time scale, which creates a subsidiary view. If I click into this I can see the numbers I expect, but the main module has blank rows for each…
List Modeling
I have the following lists in a Hierarchy Office L1 Clients L2 Funds L3 I also have 2 seperate lists Entity Location In a module I am trying to show which entity and location that the Fund L3 rolls up into with boolean boxes but my problem is that a single funds can roll up into many Entity's and many locations For exampl…
Nested Dimensions
If we could have 4 nested dimensions, this would enable additional functionality, like JE creation, advanced filtering, etc.
TEXT(ROUND())
Have the TEXT function convert the results of the ROUND function identically.
After logging-in user continues to linked-to model
Annoyance: URL link provided for specific model > user clicks it > user not signed in to Anaplan so taken to log-in screen > after logging-in, user is taken to models dashboard, *does not* continue on to model at original link. All other tools used by me at Anaplan (with the frustrating exception of SFDC) would drop you…
Copy Branch for Selected Line Items
Hi, I have a module with a numbered list. Among the module line items are Submit and Approve boolean, which I use for some kind of worlflow. When I use Copy Branch action to copy a particular numbered list, both booleans are also copied. On the other hand, I just want to copy other line items but the Submit and Approve…
Set up filter to select levels of hierarchy to show
I have three lists all in one hierarchy (L1, L2, and L3). How can I set up a filter using booleans to allow users to select which level of the list they want to see? L1 is parent of L2, and L2 is parent of L3. I'm trying to replicate the functionality of "Select Levels to Show" so that I can set the filter on multiple…

Modeling

Discussion List