Modeling

How to avoid references to specific years in a formula
I've just been asked about a problem with rolling forward a model from 2011 to 2012. The model had references to full year values, which had been made using a formula like this: Full Year Value = Source[SELECT: Time.FY11] While this works, it requires the formula to be updated every year when the timescale for the model is…
Paste to a line item with a numbered list as the format
I have a line item with a numbered list as the format. I receive an error (Unknown List Member member) when I paste in a Value I know is in the list. This also happens when trying to import even though the member is in the list and was just exported. How can a numbered list be set up so Values can be Pasted or Imported to…
Reorder timescale
Hi all, is there any way to reorder timescale? End user wants to see quarters at the end. Thanks in advance.
Publishing to dashboard Import Action
Hi All, when I try to publish an import action an undefined button appears in the dashboard. Thanks in advance.
simple create action
Is there an examle of how to use the simple create action?
Filter not picking up subtotals from lists
I have created a filter in a module that limtis my view to only items that have a boolean line item checked. My problem is that any rollups/subtotals in my other lists are not checked so I don't see them in my filtered view.
Quarter to Date Ability
Anaplan has a great Year to Date summary in the Time settings, is there an easy way to show quarter to date (QTD)?
Interest Payment and Principle Payment Functions
Is there any easy way to replicate the IPMT() for Interest Payments and PPMT() for Principle Payment functions in M. Excel within Anaplan? I can only find a PMT() function in Anaplan.
Using Versions and Periods for dynamic comparison
Hello, My Client asked about report where they compare PL lines: Version 1 vs Version 2 for selected Quater or Year, Quater to Quater, Year to Year and they want to select 2 Versions and 2 Periods. Conditional formulas can help, but I think, they may be to heavy. I tried to create Module for Selection of Version1, Version2…
Input Process Function
ALL: I have an idea for managing data input based on a matrix of 4 dimension intersections in a module, based on a trigger boolean stored in a like module. My question is simple; Is it possible using any function (known or unknown) to use a formula in the module, to check the boolean intersection of a second module to…
How to move from a Model with Timescale to a model without time scale?
Need help in aggregating the values which are available in a model with timescale (and other dimensions) into another module which has all the other dimensions except the timescale dimension. This is required to show the summation or the closing value of the timescale module value at an aggregate level into the new module.…
Best Practise for Loading Actual Data
Would anyone have a process defined for "How" to load Actual data into a model. I get that I need an Actual data file with tuple detail. And then I load the data into a Module, likely that has base members to load values. BUT my issue is then, how do I get that data into other Modules, when I cannot run a test against the…
Best practice of Built-in vs. user-defined time and version dimensions
I understand that the “built-in” time and version dimensions are “optional," and a model builder can build user-defined time and version dimensions in Analplan. Best Practice Question: Are most Anaplan customers using built-in time and version dimensions or do they build their own (user-defined) time and version dimensions…
Comment Box
When I print out a dashboard that includes a text field......all the text is Right justified/aligned. Why is that?
Move a start_date and a end_date from a flat module to a module with Timesc
Step 1 - A flat module allows to enter data of recruitment of permanent or temporary staffs. Step 2 - I wish to charge months from the start_date until the end_date of exit, when it exists, or the end of timescale if end_date doesn't exist. If I succeed in putting my indicators correctly, I don't manage to recover dates.…
Saving changes to selections on a Dashboard
On a dashboard, you may want to hide or show additional rows or columns. If you make any changes to your selections, and close the dashboard, your changes will be lost. In order to save changes to selections, you can go into Page Selector Options, uncheck the 'Show module name' button and click 'OK'. Then go back in to…
Change Dimensions in an Existing Module
I have created a module and now realize that I need an additional dimension in this module. Is there some way to change the dimensions without having to delete and re-create the module?
Is there a Quarter to Date summation function for a weekly timescale?
Please help me finding a way to sum up the weekly numbers to the Quarter to date values. That is , the value should reset to zero at bigginning of every quarter and sum the cumulative value week on week of the quarter. Any help here would be greatly appreciated. Thanks Saurabh
Line Items Not in the Hierarchy of the Line Item Subset
I have inserted line items into a module where I have a line item subset set up. In the module where I am using the line item subset, the inserted line items do not fall in the hierarchy in the subset.
How can I return the current date in a line item?
How can I return the current date in a line item i.e. automatically get Anaplan to show the current date in date format so that it updates each day. Many thanks, John.
Using Filters in Anaplan
Hello everyone! We have certain problems in setting filters in Anaplan to get what we want to see. There is a discrepancy between how the filters are shown and described in Help and looks in live system. The position of the filter value box in live system does not match any of the criteria on the filter tab. If, say, we…
How do I have a forumla calculate data to a specific dimension member?
How can I have a formula calculate data for a specific member of a dimension and place a 0 for the others?
Using boolean line items to filter views
Line items are sometimes used for the sole purpose of creating filtered views. For example, I may have a list hierarchy that contains two level: Employees rolling up into Region. And for one particular view, I only want to show a flat list of Employees, regardless of the Regions they roll up to. To do this, I could add a…
Upload Flat File to Populate a Restricted View of a Template?
We have built a template that restricts the view of each of our distributors to a single column, with a number of prompts to be populated with numbers. Is it possible (if rows align perfectly with the template layout) for a user to upload their numbers to Anaplan from a flat file, or must each number be input manually?
Zero Out a Module
How do I zero out a module?
See where a list is referenced
How can I see where a particular list is being referenced in Anaplan?
Matching dimensions items between modules
I have Module A that uses an employee dimension where 1 of the employees is named Bob. In Module B I use a different employee dimension where that same person is named Robert. When I write a formula to pull data from Module A to Module B the employees are not matched and the data pull is incorrect. How do I get the 2 items…
Collecting the value of a parent list in calculations
Hi, I want to collect the value on the parent membrer for the employees list of my source line item to calculate my target one I did an example like this one target_lineitem=source_lineitem[SELECT: Employees.PARENT(ITEM(Employees))] but it doesn't work can someone help me.
Delete Bottom Level of a Composite Hierarchy
I have 3 lists and 2 of them have parent hierarchies. The first list and the top level is organization. The second list is cost centers, which has organization as its parent hierarchy. The third list is employees, which has cost centers as its parent hierarchy. If I want to refresh my employee list, deleting all existing…
"Select All" for Boolean
If I have a Property on a list or a line item that is Boolean formatted, is there a way to "select all" of the items?

Modeling

Discussion List