-
Modules with Different UID Dimensions
Hi ALL, I have three input modules, each with different UID dimensions: Module A → Dimension: X_UID Module B → Dimension: Y_UID Module C → Dimension: Z_UID (also includes a dropdown line item with two options: Product X and Product Y) Requirement: If a user selects Product X in Module C, the record should be stored in both…
-
Cannot refer to a line item in a different model
Hello everyone, Might be a very silly question. I am trying to refer to a line item in a different model but Anaplan is not doing it. Normally when I am in the editor or formula bar, I can go to different model and refer to a line item there. But between these particular models, I cannot do it. Its driving me crazy :-)…
-
Export module data specific to a page selected using an action
Hi Team, I want to create an action event through which I want to export specific page data to a CSV file. I have a page selector which has 3 pages. (version 1, version 2, and version 3) I want to export specific version data by passing the version number as input. Refer to the attached screens. How can I achieve it Any…
-
Selecting a month boolean line item then only month data should be displayed in other module
in Module i need to give 3 boolean line items named year ,month, quarter. in other module i need to have a line item named order amount . so the thing is if i select a year boolean line item in the first module then only year data should be displayed in other module where i have a order amount line item same for month and…
-
Workflow : Skip on Blank Assignees
Half a question and half a thought on the below toggle that I noticed has appeared recently Does this mean that you could setup a flow which was Task A - Task B - Task C where you could go directly into Task B if you weren't part of Task A? Or does Task A still need to be fully completed before going to Task B? And…
-
Filter list formatted line items based on list property
Hello All, I have a challenge where I need your expertise to achieve it. I have a system module for Resources where I have attribute called Employee Type (Permanent, Temporary). I have reporting module applied with Territory and BU. In this I have line items with Resource list formatted. I need to create a filter line item…
-
Data Import from Model A to Model B
Anaplanners, Had a query, i have data in Model A, in Revenue Module which is dimensioned by Country List, Time & KPIs as line item. I need to import this data into Model B, in same Revenue Planning Module, which is again dimensioned by Country, List, Time & KPIs as line item. However here we have an additional plan type…
-
Adjusting Statistical Forecasts: Utilizing different Methods for varying time horizons
Hello Anaplan Community, currently we have a very simple statistical forecast tool in Anaplan. We can select between 15 forecast methods for a forecast category. We generate the statistical forecast using a single method for the next 5 years. We aim to introduce a logic that enables selecting two distinct forecasting…
-
Sequential code creation with department(code+1 ?)
I have a requirement where I need to create sequential codes with department (based on user selection) in a list .The user will click "Add item" from the dashboard and codes will be created and added in the list in a sequential manner . Example : 1st time : New code : 6759_00000 2nd time : 6759_00001 Similarly starts from…
-
Number Scale formatting not working properly
Curious if anyone else have experienced this issue.. Front-end I have a lot of grids in various dashboards, for a lot of these grids, there are 50-100 line items, with large values in. I want to show these in thousands, using the Card Configuration → Format → Number Scale, and set to thousands. For about the first 45 rows…
-
Apply Dynamic Cell Access based on two modules
Hi, I need to add DCA to enable this functionality- I have a module (MODULE A) where budget is input by markets in a budget input line item. I have another module (MODULE B) where once the market has input the budget, they can check the boolean "Submit to HQ". Once the "Submit to HQ" boolean has been checked, the budget…
-
Optimizer OR
Dear Community, is there a possibilitly to use the logical OR in a constraint for the optimizer? I am trying to compare a variable to a constant. The constraint should default to TRUE if the varible equals zero or is the variable equals the constant. I came up with a non-linar equation (x * (x-y) = 0), but I do not know…
-
Multiple Selection like Excel Pivot
I want publish this below list on ux pages and give end user option to select multiple item from list like we have option in Excel Pivot table. Is this function available in Anaplan or can anyone suggest me alternative function can be used. There are multiple line item in the list. The final goal is to sum the number from…
-
Best Practise of creating List
Which is the best practice for creating List in a Spoke model from Data Hub model ? Is it a List to List import OR Saved View to List import ?
-
Filtered Picklist / Dependent Dropdown using values
Hi all Is it possible to set up a dependent dropdown based on a value? The scenario is that we have a list of orders with an order quantity, with a line item for the user to select the destination. However, we have a capacity constraint in the destinations, so we want the line item to only display the destinations with the…
-
Change in model size on importing
I have a prod model which is of almost 120 GB size. For some test purpose i simply imported the model to another workspace but now when i check the size of the model it is 75GB. When i checked at module level yes the cell count differs for some but not sure why the change in size. Kindly suggest.
-
SUM data in time dimensioned module based on Boolean
Hello Everyone, I have the following scenario, could someone please help me to solve this. I have a module dimensioned by Native time and I have 3 line items one is Boolean, Value and Target. Now I have to look at the Boolean line item if it is true then copy the current period value from value to target if its not true…
-
A case where general lists unique key were mapped to name or code now wants to map for code
A case where general lists unique key was mapped to name or code now company wants to map for code. There are 300 dimensions need to have this change. How the Downstream impacts for this change ? What are the cautious things need to keep in mind before making this change ? Please suggest .
-
Power BI connection to Anaplan -- multiple times credentials asked
In my project we have power BI linked with the Anaplan. Working in Power BI everytime there is some issue with the connection with the anaplan and it keeps asking for credentials. And also for password reset which is very frustrating. What can be done to have a secure connection?
-
Passing parameters to system modules
I have more than five modules where "reporting date" is a line item and I import values for them. In each of those modules I have another line item to calculate the reporting period based on the reporting dates. Here is the formula for that. IF DAY(reporting date) <= 15 THEN PERIOD(reporting date) ELSE PERIOD(reporting…