-
Disadvantages of Numbered list
Can someone elaborate the Disadvantages of Numbered list
-
can we have a multi select filter as a page selector in Anaplan?
similar to what we have in excel filtering…can we use page selectors to select multiple boolean formatted line items. Snapshot attached
-
Add a list item from a module
Hi all, I am struggling a bit to find a way to add a new list item from a module. So, I have this module in which I let the user insert the product, the product code and finally the customer group; the final result are three new list items I need to add to the relative list, that is ps01 product (which is a numbered list…
-
Percentage of Parent and Parents Parent
Hi all, I am trying to find a way to calculate the Sales % of a items parent, and also of the Parent of the items parent. Below is an example of what I am trying to achieve,
-
Seeking Advice: Establishing a unified organizational structure & managing restatements
Hello, I work at a company's headquarters, where we use Anaplan for reporting purposes. Some of these Anaplan models have been developed in-house, while others have been created by external consultants. This has resulted in a situation where we have multiple lists containing more or less identical organizational…
-
can build a action that updates current month in time dimension of both hub and spoke?
Hello everyone, Can we create a action that updates current month in time dimension of both hub and spoke. Thanks, Maithri.
-
Changing formula scope does not re-apply to line items?
I have a formula which was written with the formula scope set to 'All Versions', then realised that I only need it to apply to 'Current Version', so I changed the scope but the data is still showing in the actuals and the forecast (all versions). If i add a new line item and set the scope first, and then use the exact same…
-
Cumulate a moving target
Hey Anaplanners! Hopefully a fun one and not just my own short-circuiting. I'm working through a capacity allocation rankcumulate, where my list items(SKUs) have a target for a month, and multiple sites that can produce units towards that target. My issue is that the cumulation is correctly grouping by SKU group (family)…
-
Button on Dashboard not working
The picture above highlights the problem, every time i use the button Add Sub-GL/Vendor Item, the chart to the right should update with the name, GL account, for each department. I tried to add a new vendor expense under admin finance and legal called "anaplan", the gl account i choose was called software/subscriptions.…
-
Add a button to a dashboard
I have dashboards built out for budget owners in the model layer not app layer of anaplan. I would like to add a button that essentially gives the budget owner the option to add an additional FTE to their headcount and plug in the respective salary of the new hire and see the financial effect of adding one additional…
-
Importing module
Hey community, hope you can help me with these one. In my Data Hub model I have a module to fed the others which includes different columns such as CCs, Accounts, Entities, etc. For the CCs specifically I create a mapping module which map some CCs to their parent level (these to avoid creating too many cost centers on the…
-
what is the difference of SUM ,LookUP, Select
-
What is Data Integration , any example scenario?
-
What are the best Practices for model building , how can i list out. I am in training level.
-
Best Practice: PARENT() vs. LOOKUP ?
I am looking for assistance to understand best practice/performance implications between 2 different approaches of getting a list item parent in a formula. Imagine I have 3 modules: X, Z, and System Module. The System Module contains Parent line item with formula PARENT(PARENT(ITEM('List Items'))). I want to return this…
-
Summing only some lines in a list
Hi everyone, It's similar to SUMIFS with 1 criteria as a line item and another criteria as a line in a big list. I've tried SUM, LOOKUP but none seems to work. the error is: This … is not a line item could you please see if you can help? Many thanks, Jesse
-
I am trying to create a module where I will have a list that rolls up to two different parents.
I am getting an error "an invalid Applies To for Test because Domestic and International have a common ancestor." I am trying to create a module with few list member that rolls up to two different parents. For example- Product A Product B is a part of Domestic Sales destination and Product C and Product D is a part of…
-
DCA without user list but with roles-list mapped to users instead
Hi Anaplan Community, I have a module "Module 1" which currently has one dimension: the product list. The module is used to apply an approval flow for cost updates to the product. Depending on if the user has been setup as requester or approver in another module (user list with boolean line items), the DCA on the line…
-
Switching from Model Calendar to Time Ranges
Hi Community Members, My model currently has 6 future years in it, with Calendar Type as Months/Quarters/Years and no time ranges. I dont need month level data outside of next year so instead of months for years say FY25 and so on.. I only want them on the consolidated FY level so I can reduce my model size. I would also…
-
I want to understand the use of this feature?
I am trying to import data from Data Hub to spoke model. The requirement is to clear the target before loading the new data. Can I use this option at 'All Items' as an alternative to creating clear module data actions using 'No data' formatted clear line items in the target? Is that more efficient? Does it work the same…