-
Users - built in top level not required
For a line item i need to apply ratio in summary and then in applies to select a general list. but it allows me to either do the ratio calculation or the applies to, when trying to apply both the things i get the below error "Count over Users hierarchy is not possible as Users does not have a built-in top level" I do not…
-
Month Number respective month.
I want a line item where I can select the month by drop-down. For this respective month I need the number value of the month. How can I achieve this.? Like October is 10. I am thinking to create a month flat list and use it, but how can I get the number? And i would very appreciate you if you share screenshot.
-
Re-order a general list alphabetically
Hi, I'm trying to re-order a general list into alphabetical order. Its a hierarchal list and I'm not sure what steps to take. The list is a dimension for many modules and performs as a drop down menu for UX pages. Any guidance on this would be appreciated! Thank you Joe
-
How to calculate Percent of Total in hierarchy and Put on a chart
I'd like to do two things here and would appreciate your help. I think I could do it with 15 steps but there has to be a better way. I've got a hierarchy called Workstreams with Products, Projects, and Unallocated that accumulates employees hours worked by month. In this module, W2 Workstream detail is the rows and then…
-
Add multiple list items to a List with subsets
Hello, Is there any possibility to add more list items to a Subset List and also be able to select the parent where the list item should be added? Currently I am using the Old UX and I use the "Create" Action where I can select the parent where I want to add the new item but the inconvenience here is that I cannot add more…
-
Browse new file when running import action.
Hi everyone. i created an import from CSV. now i want to publish this using page. my only concern is everytime i click the action/import. it wont let me browse to a new file. it only import to the old csv the i used to import when i created the action.
-
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 ?