-
RE: Model consolidation
Hi Fredric Make sure you have built your lists in relations: SKU List parent list is Products (Assuming SKU is your lowest level) Product Parent list is Region (Organisation) so on, If you have not created these relations the other way would be let SKU have a property called Products and Region and then get the respective…
-
User-based security access at the node level
I have the below requirement on user-based security access at the node level. I have 3 nodes (L1, L2, and L3) For example If L1= Americas L2 = Canada and US_Disti L1 and L2 will be my composite lists and we will have various attributes (KPIs) attached to them like Bookings or Sale proceeds etc. Now, If I am looking for…
-
Select and Lookup by Display name
Is there a way to use lookup by display name? I have a numbered list List B which has parent hierarchy is set to List A I have set the display name instead of the code. Module 1 : Pivot has: Pages : Line Items Columns: Country list, Sales list Rows: Storename List LineItem: Salesinfo Country Total Sales- toys Total sales-…
-
Change user details
I need to change a user's information in the platform. How can I do that?
-
Anaplan's equivalent of a COUNTIF function
Anaplan's equivalent of a COUNTIF function While Anaplan doesn't have an official COUNTIF function like Excel, you can combine an "IF THEN" statement with a "SUM" function to accomplish the same goals. Using the "IF THEN ELSE to create a count saying "IF True Then 1 Else 0" You can then use a SUM Function to get the value…
-
Dashboard - Export to PDF while using the "Wrap Text in Headers" feature
I'm trying to build a dashboard which replicates an exisiting report used by our company. It has a very specific layout which consists of a dashboard element which fits perfectly to A4 Landscape. (There are also two small dashboard elements below it) The users will need to pint these reports regularly. To make the…
-
How can I apply breakback on a calculated line item?
A partner asked us about some modelling techniques for top down budgeting. They would like to create a model where there would be a growth percentage applied to the whole P&L as the first step. Then in a second step they would like to be able to fine tune the results by using the breakback feature. As a calculated line…
-
Creating a fitered page selector
Say you want to use a page selector for your time dimension but you would like to filter the list? (almost a time subset). You can't do this directly as a page selector, but you can use a filtered list as a selector for a module view in a dashboard. Example:
-
Use variance line items to show multiple time periods in a waterfall chart
A useful trick for showing line item data across more than 1 time period. As you can see from the module grid view, the first line item pulls in 2013 Sales, then the next 2 use the lag formula function to show variance between the 2013 and 2014 data for those line items. The Sales 2014 line needs to be a summary item i.e.…
-
Dynamic month selection
Dynamic month selection
-
Dynamic month selection
Dynamic month selection
-
Multi select in module (Auto refresh module on dashboard)
Main Idea is to have employee multi choose in module on dashboard by checkboxes. Is there in anaplan possibility to implement this? I created a workaround, (see file as example), but i have to manual refresh dashboard or module each time selection changes. Can I get auto refresh for Employee KPI module based on chooses in…
-
How can I create a set of end-user instructions on a Dashboard?
Setup a module with line items 1 through x and no other dimension. Type in the instructions for each line item and publish each line item to a dashboard. Conditional formatting can also be added to enhance the text display. See attached example.
-
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…
-
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…
-
Always Show "Current Version" When Opening a Module
In order to get your model to always open on the version you have marked as the Current Version, when you save the module view as the default view, you need to uncheck the box "Always open on current page" and the current version will always be the default.
-
Show current value for 'Day' timescale
A model I developed had KPI daily values loading from an external data source The challenge I had when working with the day timescale was the size of the time dimension (being days) and finding the 'current' day (most recent load) To resolve here is what to do:[list=1] * Create a list that is the 'load date', update this…