Modeling

Dynamic Display based on Time Period Type
Purpose: Retain views with multiple types of time scales/periods in the same view during YoY rollover, for multiple line items or list items, in a single view. Example: Dimensionality: Vertical/Columns- Time/ Line Item Horizontal/Rows- List Members Display: Line item 1 - Year only Line item 2 - Non-applicable (Display Full…
Disable endusers to change name of list items
Hello everyone, With several models up and running, we have encounterd the problem that some overenthusiastic collegues double or trippleclick the name of listitems that are presented on dashboards. This will allow them to change te name of the selected listitem. Is there any option to disable this function? The model…
Using Lists in IF formula
I'm trying to create a formula to say IF 'countries-filter'.'1' LOOKUP[Countries.'UK & ROI' ] THEN 'Actual (Current View)' - 'Forecast (Current View)' ELSE 'Actual (Current View)' - 'Forecast (Previous View)'. My countries are a list, so i created a Boolean module. 1 - UK 2 - IT 3 -DE I don't think i've set this…
Delta Load
Scenario: I changed the parent of a child then how to do incremental load when there is a change in parent child hierarchy?
Edit Dashboard
Dear Members, I am getting a Slider which I want to remove. Desired Format has no Slider. Please help me to remove the slider from Dashboard. Thanks.
Fp&A case study access (299)
Fp&A case study access 299Could you enable my access to FP&A Case Study please. I have completed courses 100, 101, and completed certification for 102, 201 Saurabh Sharma saurabhsharma08@hotmail.com saurabh.sharma@acgindia.co.in
Delta Load
How to do incremental load when there is change in any one of the list properties?
How do I get the data from a line item of a list in a module into another module?
I have two module. One call assumption, another. call Implied new room. I want to get the data from the line item call mix which is base on my subscription list from the assumption module . In my Implied new room module, I have 3 line item with the same name as my subscription list. I don't want to use a list because I…
Dashboard Header Module
Dear Members, Require your help in removing the Module Name from Dashboard. I have shared the Desired Format (How I want) and My Format (How I have). Please feel free to ask in any difficulty of understanding.
Create Child in Numbered List
I had the original Model, and I was trying to replicate it. The pic 01 and 02 are the Original ones. The pic 03, 04, 05, 06 are my Model. It is restricting me to enter the values:- Soft Drinks, Tea.... I even tried creating .txt file and import it but it failed too. I need your kind help for this. Please feel free to ask…
Text function; Automatical conversion to scientific notation
Hy everyone! I'm encountering a problem with converting my values to text with the TEXT() function. My problem: When the value is 10,000,000 and I use the text() function, there is no problem. The text line item will show "10.000.000". When the value is 10,000,000.15 (with 2 decimals <> 0), The text line item wil show…
Ability to sort the order of views on a module using Ascending or descending options
Currently when you click Manage Views on a Module you can move a view up or down to change its order. It would be easier if we could have the option to sort in the same way for other objects with an ascending and descending order option or a top or bottom option. In addition you can only move a view once in either an up or…
Import period format to Time Periods or Date formatted line items
As we drive to remove Text from our models, dealing with Dates is troublesome. When mapping files to Time Periods in modules, we can choose periods and define the format. For example, in my file I have YYYYMM. However, when I am trying to bring this data into a formatted list I do not have this choice. Even when formatting…
Cut line item list formant
Hi! I've got line item formatted as a list. This list has got a different level of summaries. Is there a way to cut somehow this dropdown list so the summaries wouldn't be included, ie there would be only items at the lowest level of the list? Thank you.
Summing Module Results at Different Levels in Hierarchy? Even when I exclude the parent.
This is in regards to the SUM on the bottom right corner when you highlight the total number. It varies from different Hierarchy level of my chart of account. I have a parent and child chart of account with a top level. Ex. COA. COA L1 Top level is Total GL When I click total GL only and not select the rest, it shows me…
Why won't my vendor roll up to my Total department. It seems to be only this vendor.
I created a a vendor call MISC. Its to group all the vendor under a certain amount to MISC rather than showing a bunch of vendor. When I select Total Department, MISC won't show up. But if I go to the specific department call N/A or No Department, which is the roll up level. It will show up. I tried moving N/A around to…
Sorting of list when used as line item
Hi, I need to change how list hierarchies are sorted when used as format for a line item. See image below; In this case, I have 2 lists, where the ones named "Parent" are L1-level and "Child" L2-level. As shown in the images, the child are above the parent. I want it to be the other way around. Does anyone know how to do…
Line Items Not at 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 . thanks iosman
employee cost center change
Hi, I have set up employee list where in cost center is the parent. But how will the change of cost center be handled in Anaplan? If I just change the parent of the employee then the change is retroactive which should not be. Any suggestions? Thanks, Ana
COUNTA formula in Anaplan
Hi, I was wondering if there is in Anaplan the equivalent of the "COUNTIF" Excel formula: basically counting the cells in that range that match a specific condition. I was thinking of using it for calculating the % of Cost Centres that have input data so far against the one that have no values. Many thanks in advance! ****
System Default date
We are building dashboard with workflow, where user approve/reject demand plan, would like to keep system date so that we will know when user made changes. It would be great system default date and time can appear there. Thanks,
Simple yearly average
Hi All having completed the 102 course I am in the process of building my first model, so please be gentle if I have asked a ridiculious question but I really cant figure this out. I have a line item showing balances across time periods and I would like a second line that shows the average for the financial year for the…
Distinguish between List Item or Line Item
Dear Members, I am new to Anaplan, so I would request your generous help. Order Number or Transaction Number is a Line Item or List Item? And if the answer is List. Then let me know, if millions of transactions happen daily in any Retail chain or Bank. And if we create Numbered List for the Transaction, after 1 Billion…
Sum one Line Item based on the value of another Line Item
Hi, I'm wondering is someone could help us with the following: We have a transaction module called "Data Store" which is made up of line items (columns) and a Transaction Unique Key (List - Rows) Refer "Image 1" for the Pivot View... Refer "Image 2" for the Model view. (This is a subset of the data contained in the module,…
XYZ Axis Charts - Bubble Charts - Radar Charts
Hi, It would be great to see a wider range of charting options such as XYZ Axis, bubble and radar charts. Thanks, Usman
How to get the average of the last 3 month from the same line item for Forecast version?
Hi, I am doing an OpEx forecast. How do I write a forumula to get the average of the past 3 month from the same line item for the Forecast Version only? I also want to be able to override the amount manually or by upload if needed. Is this possible or do I have to create another module to link it?
Saved view changes to sync with dashboards that have saved views published.
Hi Anaplan, It would be really useful to have any changes made to saved views to sync with the dashboards that contain these saved views instead of having to republish these changes. Thanks, Usman
master data list synchronization between models
Master data lists needs often be synchronized between the Data Hub and spoke models. At the moment we do this as follows (for incremental loads): In the spoke model: 1. Set the property 'in use' of all list items on FALSE 2. Load in the data from Data Hub to your spoke model (incl. the TRUE flag for 'in use' property). 3.…
"Show history" for list items
Currently one is able to export history in two ways: * As an admin: via setting "History" tab * Via a module. Selecting a cell or a range, one can get history for only the selected data. I propose two other ways of interracting the history logs: * Via General Lists tab: For example selecting a List and pressing "Show…
Opportunity to edit cells, that have less dimensions than the module itself
Currently such cells are displayed and calculated correctly, but cannot be edited without opening the subsidiary view. Anaplan is all about dimension, and that's the main advantage against Excel which needs either to put data on different sheets, or to implement complex VBA programming to provide several dimensions. But…

Modeling

Discussion List