-
CODE, PARENT AND 'GRANDPARENT' FUNCTION
Hi CODE(ITEM('G3 Location')) and PARENT(ITEM('G3 Location')) were defined for the following Code and Country results. Is there a 'grandparent' function that can be used to display Region?
-
How to have current month or current date when i open a module?
My current month in the setting is Dec19. When I open one module it is showing Jan 20; another module is showing Mar 20. So what is the reason why modules are showing different months? Similarly once I open any module if it is having a date as a dimension, can I able to see today's date automatically?
-
Keyboard shortcuts
HI, I am using keyboard shortcuts all the time on Anaplan. CTRL C / CTRL V are obvious for anyone, and very efficient in Blueprint for properties copy and paste. I find two other shortcuts very usefull and efficient, they make me save a lot of time, Function key 'F2' : it works the sae way as for Excel, I use this to edit…
-
Null value vs. True zero
Hi, I am trying to differentiate between a 'null' value versus an actual true zero (- vs 0) on a dashboard. Has anyone had any experience with this? I am looking at formula options to resolve this issue. Any help is appreciated! Thanks, Kaley
-
Data Quality/Integrity Checks within Connected Planning Environment
Hi All, In thinking and implemented a Connected Planning environment, where we have specific models for specific areas our finance team that are brought together. We currently have a number shared hierarchies (across cost/profit centre, GL), shared data (TB, Subledger etc) and currently handled via the data hub as the…
-
Run multiple actions from selection in Actions panel
Would be great if you could run multiple actions from the actions panel based on your selection. For example, if you selected two import actions and hit Run, Anaplan would run those two actions as though they were in a process. This would greatly help model builders test actions where creating a process is not needed. The…
-
Optimizer with multiple decision variables
Hi, We are trying to create optimizer where we have the multiple decision variables like deciding on the number of line runs, forecast number to be allocated on a line and inventory norms to be met for a particular product . for instance my objective equation is as below: ax+by+cz there are multiple objectives which has to…
-
Previous year unitary calculations and summing
Hello everybody! I've come across a problem with making accurate calculations for a line item in currency/unit for previous year. My model has system version called "current" which has 5 years (2019-2023). Time options: months, quarter, ytd, FY. I'm making a module that is based on line item subset (included are: Volume in…
-
Error in List
This is the original list. This is my new List.
-
NEW UX
How to publish Subsidiary Views in NUX?
-
Level 1 Model Building - Part 13 Dashboard - Chart
The course instruction says to show Margin line item, filter Forecast Months, save as Chart DB, publish Line Chart to Margin Calculation Dashboard. Add Margin Summary heading to the chart. (style heading 3) . However, the sample Model that we were told to download shows the following Line Chart by Volume instead. Which…
-
Level 1 Model Building Course Instructions
Hi, In completing the Level 1 Model Building certification I noticed, what appear to be inconsistencies or errors in the instructions and I would like to highlight these all here as they caused me issues when sitting the certification test. Hope they are valid issues and a reply to this topic helps students navigate around…
-
Dashboard
Hi How do we get a split view as below?
-
Plannable List combinations
Hi Team – I want to understand how we can create a combination of lists and restrict the planning across only those combinations. Please go through below as an example case: Let’s presume we have two lists: Product and Location. * The product has 4 list items P1 to P4. * The location has 2 list items L1 and L2. * P1 and P2…
-
Creating Formulae that are specific to a version
Hi Apologies if this question is over simple, but I'm fairly new to Anaplan, although I've done the certification. I'm trying to create a cell that calculates differently based on wheteher it is the actual or forecast version. I thought I had found the solution with the following article on "add version formula"…
-
How to Group Weekly revenue into a customized Month (List)?
Hi Anaplanners, For my organization, we have revenues recorded by broadcast period and we have to report it by Gregorian month. Since the default Anaplan 445 timeline is not the same as broadcast period. I have to create a module that allows me to create custom grouping of the Anaplan week into my custom month. Then, I've…
-
Filter a module over a dimension subset
Currently if a module has complete list as a dimension, and a line item has it's subset as a dimension, the filter won’t work for that line item. For example you can have a module for forecasting clients sales. The clients dimension is obviously needed both for Actual sales and Forecast line items. But you wouldn't need a…
-
Memorialize Actual Data in Historical Planned Versions
Hello, I am currently running into an issue with one of my models where historical plans are changing due to actual restatements. I have a model with 4 versions. Actual, Budget, Working, and Current Forecast. Working is where all of the planning is done, and then that version is copied from working to current…
-
Timeline chart Min days Fix
Hi all, We've been working with some timeline charts on a SCM project, which is great to represent "Projects"/"Activities" over a timeline. As many of you know the way it works is you choose a source start date and source end date and thats the data that shows up within that range. However, it is determined that any…
-
Level 1 - Model Building - Module Report - Different Results
Hi In the Module - REP01 Country Margin Report below, G3 Location and P2 Products were selected in Pages and the results are as per below screenshot. However, in the Module - REP01 Country Margin Report - Copy below, G2 Country and P1 Product Family were selected in Pages and the results shown is '0' as per below…
-
Property Based Flag for List Item Match
Hi! I am working on a solution and I feel I am spiraling down the wrong lane for no reason. I have a text formatted line item that has the same values as of the name of the list dimensioning the module. I want to flag items in the list which are present in this line item, no matter against which list item. Here is a…
-
Level 1 Model Building - DATA01 P&L Actuals and Budget
Hi I loaded the 'P&L+Actuals+&+Budget.csv' file and found out that Forecast is calculated (in black). I cleared data again and Actual, Budget and Forecast was 0. Is it because there is a formula defined for 'Forecast'? If so, how can this be trouble-shooted? Thanks.
-
Level 1 Model Building - Module
Hi, the screenshot below refers. 1) How do you delete either of the modules in the orange box? 2) Why 'EMP02 Employee Expenses - Result' is not appearing in modules tab (pink box)? Thanks
-
Hierarchy Level to show on a module
Customer would like the option to select hierarchy level to show on a module published to a dashboard based on page selector selection. (Selected summary level or leaf item). Currently users have the ability to to publish the module with the desired summary level shown, but you would have to do this for each summary level…
-
Formula to display values from the page selector in a column
Hi, I need to be able to display the page selector value in a column. The purpose of the module is to assign multiple positions to an order. If it had been the other way around (assign an order to position) I could have used an "assign" action, but, now he task is to do it this way. I need the order column to display the…
-
Issue with Percentage Number Formatting
Hi All, I noticed recently that the drill down ability on percentage formatted line items has been limited to the amount of decimal places / minimum significant digits selected for the format. Furthermore, if you drill into a cell that Anaplan is storing more precise decimals for, and then enter out of the cell, the stored…
-
Pivot - Lists and Roll-ups
Hi When a module is created, the 'Lists and Roll-ups' appear on the left for selection. In the pivot screen, how can the 'Lists and Roll-up' be called-up for selection? Refer to screenshot below -> 'Lists and Roll-ups' not available. Thanks.
-
Publishing a list property as page selector in the dashboard
Hi Anaplan, Is it possible to use a property of a numbered list as page selector in Anaplan? I need to filter my module based on a list property to select which lines I need to delete through a boolean line item. To give an example: List Property (Details) Dashboard: 1 Criteria 1 Details Page Selector: Criteria 1 2…
-
How to Set search conditions for each user
Hi everyone. I would like to set search conditions for each user and I want to filter and display data. There are 110,000 items of data I want to display, and I want to specify search conditions for each user and filter and display them. Please tell me a good solution. Best regards. Taku
-
Modify the Page, Column and Row dimensions
Hi For a module created, how does one modify the Page, Column and Row dimensions? E.g. Region and Products were selected as Columns and would now like to move them to Page and have Time as Columns instead. Understand that Pivot function provides a temporary view only and cannot be saved for future usage. Is it true? Thanks