Modeling

Last Non Zero
Had a Partner ask if there is anything that does a "last non zero value" like our first non zero. Discussed ranking, but apparently that wouldn't work.
Convert multi-dimensional form to RDB form
Hi, Anaplan friend I understand Anaplan is capable of converting RDB format to multi-dimensional format, but how about opposite ? Would you take a look at the attached file ? Now I have a module on the left hand side, and this has to be what is shown on the right in order for another system to import. I appreciate if you…
Ability to use Roles as a dimension
Enhancement Request: Ability to use User Roles as a dimension To provide more clarification, could you please explain how you hope the enhancement would assist in your business process(es)? It would be quite efficient for the customer in terms of usage the dynamic cell access functionality. That gives our finance users…
Search model and Display results across Actions, Modules, Dashboards, Lists in one screen
It is common to use the exact wording between actions, modules, dashboards etc., however in order to see the results of items from these different groupings, currently I have leave a view (say the module view) to go to another view (actions) and search the results again (which also resets my search from the last view).…
Specific Count function ?
I am currently looking to build a line item in a pre-existing module that shows a count of open shift request sent to only one employee. I have the "amount of shifts sent to" data as well as list of employees. Wondering if there were suggestions on how to make this work. Maybe a Count if blah = true then 1 else 0 then…
Calculating date 90 days past identified date
Hello - I am looking to calculate the date 90 days past an identifided date. I know there is an ADDMONTH and ADDYEARS calculation, but not an ADDDAYS, which would have been helpful. Is there another approach to do this? Example: What is the date 90 days from 11/15/18. Thanks K.
When a Boolean is selected the model refreshes automatically to update any dashboards modules
Hi When a boolean is selected in a dashboard to apply a filter based on this you have refresh the dashboard or create an action button that re opens the dashboard. It would be if when a Boolean was selected that the model would automatically refreshed dashboard and modules real time to reflect changes. Saves having to…
Create a saved view on a dashboard and push it to the source module
Hi, It would be an amazing feature to create a view on a dashboard and then push it back to the source module. Clients have asked for this. Thanks, Usman
Create formatting on a dashboard and push back to source module
Hi It would be amazing if it was possible to format on a dashboard and then push the formatting back to the source module or saved view. Thanks, Usman
Modules and Dashboards Display Who Is Currently Viewing and Last Viewer
Hi All, Modules and Dashboards actively show who is viewing the module and dashboard currenty and who the last viewer was. This will help to show who has seen updates or currenlty active or might be changing something in a module or dashboard. Thanks, Usman
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…

Modeling

Discussion List