-
Delete orphan records from a Properties module
Hello all, I want to change the rollups of Cost Center into its parent Division in hierarchy (i.e. Cost Center 100 belongs to Div 1 today. I want to change to Div 2). I can make teh change and write the data correctly. But I can't think of an automated way to delete 2 levels of hierarchy under the existing cost center.…
-
Bring a value based on summary method
Hello, I am trying to create a line item where I specify which product was sold the most by each of my sales reps. Rep and Product are lists on my model. I have a module called "Sales history" where I have the sales of each rep for each product. I want to have a module where I can select a rep and the line item (let's call…
-
Issue with changing Numbered List in Production to composite hierarchy
Hi everyone, I have a composite list which is set as production List in production model. It has 5 levels of hierarchy the 3 lower levels are numbered list. Due to customer request, changes need to be made to make the list a non-numbered list. I have amended it in the DEV as non numbered list but when synced to PROD it is…
-
Revenue from companies within the same consolidation group are not eliminated properly.
I have an issue with my Anaplan model. Revenue from companies within the same consolidation group are not eliminated properly. Can you help me troubleshoot this issue?
-
How to create Module for List
I want to migrate DBs to UX pages and in DBs there are Hierarchical DBs so to create UX pages for that Heirarchical list i have to create modules. so my question is when i am going to create module so in list there is one parent item and another one is child Item, i created one module but when i saw there is no info for…
-
Why for same list format line item available options are different in dashboard and NUX ?
I have a list type line item and its filter are Selective Access and Dependent. It is deployed on both tradition dashboard and NUX in same saved view. There are 3 available options(item) can be selected under this line item, and in traditional dashboard all 3 options can be "read" but only one can be selected. In NUX, all…
-
Previous/Lag Function Not Working
Hi, I have 2 line item and on the other line item I used a Previous() function to try and get the last actuals value to spread it in forecast but it seems to not work, I also tried LAG() and same issue. What could possibly be the issue or is there a workaround on this please? Below is the module, it is dimensioned by 2…
-
Need past /previous active value
Hi, I need help here to get the associate last active plan as complan in one of the modules'. If I use current date in lookup its taking the compl plan as blank Thanks & Regards, Swapna
-
Need to lookup multiple items from another module
I have a module with PO numbers 1 line per PO, with space for 4 product codes The source list is from a simple PO list, with no details, i can then get the details of shipping etc using a lookup Inbound Stock Transactions.P_Forwarder[LOOKUP: PO] etc But the source data has mutiple lines, one for each product, which i also…
-
In anaplan model testing , Is it possible to do automated testing?
What are the tools we may use to test anaplan ?
-
how can to get more command on writing formulas in line items
It will be helpful if you have provided some suggestions or resources to gain more knowledge
-
How do I have a different summary method for a single line item?
I have three line items: budget, reforecast, and variance. My dimensions are three different lists - type, subtype & quarters. Some of the subtypes for budget and variance need to be sums and others are closing balance. What would be the most efficient way to do this?
-
How to Read back from a consolidated module
Hi Experts! I have a module A using below dimensions - Sales Territory Quota Mapping list is a list with sequence numbers from P1 to P6000. there are properties like Employee (using list of EmployeeAssignment) and Employee ID in this module. And a module B like below, where I consolidated/summed the numbers by…
-
Sort on the Users list
Hello all, Hopefully this is a quick solution. I'm looking for a way to sort the Users list based ontheir Read/Write properties. Example: I have 25 users that have Write access to different cost centers. They should be ordered based on Center alphabetically. Is this possible?
-
How can I restrict users selection of months
How can I restrict month selection drom a dropdown? For example I would like to set a dashboard where end users can only select pre-defined months i.e. Jan 23 to Mar 23. Is there a way I can easily change this by adding (locking/unlocking option) additional months if needed. Thanks!
-
How does using DCA impact model performance?
I am working on a solution where usage of DCA might come in handy for a clean end user experience. For eg: In an input grid, there are two mandatory fields that needs to be populated before the end user can tick a boolean and run an action. OPTION 1: Using a DCA to enable or disable the boolean based on whether the input…
-
Can any tell me what is the correct answer to below formulas
-
Why am i getting this when trying to import to a ticked production data (numbered) list?
"Deployed Mode is enabled for this model. You do not have permission to change structural data." it is ticked production data and i am just importing data to it, only 2 fields. I am the builder and have FULL access to everything I am not changing structure i am importing data
-
Not Understanding Results of SELECT formula. Line Item for All List Items Set to TRUE.
Hi everyone, thanks in advance for any help! I have attached a image showing a replica of the list/module that I am working with that shows fake data. I came across an existing module in our build, I am having trouble understanding what is actually happening when one of the booleans under the "Include" line item is…
-
Filter transactional data based on user selective access?
Hi I have a module with a sales order list with multiple properties (business unit, item, cost, quantity, …). This list spans multiple countries. I'm looking for a solution to limit what account managers see based on the selective access they have been given. I have enabled this in the 'business unit' list which is one of…