-
Optimiser Time out error
Hi, I am running an optimizer with Time out limit of 20000 seconds.However post 60 mins it throws the following error: "The solver was cancelled due to timeout, please increase the solver timeout value to solve the problem" Does Anaplan has the limitation of only 60 minutes? Not sure what is the issue. Can anyone please…
-
To build formula which is like PREVIOUS() but references a list item instead of time
Hi All, found out a work around for this, until Anaplan creates an in built function to fetch previous or next values in a list, without referring to Time dimension. Hope this helps Link to Anaplan Idea Exchange: https://community.anaplan.com/t5/Idea-Exchange/PREVIOUSITEM-formula-which-is-like-PREVIOUS-but-refer... Other…
-
Planual Explained - Day 38
"Rule 1.06-03": Article 1, Chapter 6, and Rule 3” Avoid single item subsets If possible, try and avoid single item subsets, if there is a top level in the list, a single item subset will always have two members Here is how it was done in Pre Planual Era. We used to create a subset which includes/houses just a single list…
-
Planual Explained - Day 37
"Rule 1.05-11": Article 1, Chapter 5, and Rule 11” Do not embed Numeric values or Dates within the Code of a list Dates and values are "data" and should not be part of a code Here is how it was done in Pre Planual Era. What is wrong with this method? Dates and Values are data points and should never go to the list as part…
-
Get Total Value on another Line Item
Hi, Please help how can I get the total value of another line item to the other. Pls see attached screenshot where I tried to use lookup of the parent hierarchy to get the total value but it is not picking the correct value. Thanks in advance, Tom
-
INVO1 SHIPPING TIME(WEEKS)
Hi, I am getting an error putting this formula to the shipping time(weeks). 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product,LOOKUP:'SYS07 Distribution Center Details'.Default Shipping] error:Dimension of mapping used for lookup doesn't match any dimension of the result can…
-
Alternate Hierarchies - Use Cases
Hi All The topic of Alternate Hierarchies is very interesting for me, as we are exploring this topic as a future development for the product We are looking to build functionality that will allow multiple parents off a single child member and specify which hierarchies should be used in which part of the model This will…
-
How to build Parent/Child hierarchy for different sets of children
Hi Need your help in developing a solution for this requirement. Please see the attached data sheet.We execute Jobs to make Assembly Items by consuming Comp Item numbers (Typically we consume 2 types of Comp item numbers to make one Assembly item). One Assembly item can be made in more than one way.(i.e. We can create two…
-
Best way to handle validity of products prices
Hello Anaplan community, I'd like to create a model that stores prices for my items, and the evolution of these prices. A few constraints though: * Prices can evolve with time, and the applicable price at one date can be different from the applicable price at another date. * Products don't change prices at the same time,…
-
Planual Explained - Day 36
"Rule 1.05-07": Article 1, Chapter 5, and Rule 7” Avoid Top Level for large flat lists If you need the totals, look to add dummy parents to make the calculations more efficient Here is how it was done in Pre Planual Era. Lists that need to be aggregated we used to have a top level for all these lists irrespective of the…
-
Planual Explained - Day 35
"Rule 1.05-06": Article 1, Chapter 5, and Rule 6” Only use Top Level for ultimate parent Only use Top level for lists that will need sums so not Currency codes, or True/False (Indicators), or children in composite lists Here is how it was done in Pre Planual Era. What is wrong with this method? It is not required at all.…
-
Formula Error
Hi Pls can you help : ----------------------------------------------------------------------------------------------------------------------------------------------------- The formula for 'EMP02 Employee Expenses By Dept & Role'.Bonus is invalid: Bonus = IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus…
-
Planual Explained - Day 34
"Rule 1.05-05": Article 1, Chapter 5, and Rule 5” Format the Display Name property as a list, if possible. Format the Display Name property for Numbered lists as List Formatted, not text. This is more efficient, saves a line item, minimizes text fields and simplifies mappings Here is how it was done in Pre Planual Era.…
-
Planual Explained - Day 33
"Rule 1.02-01": Article 1, Chapter 2, and Rule 1” Use Current Version setting Utilizing the Current Version (and Actual Version) within the Version Settings allows the use of CURRENTVERSION() and ACTUALVERSION() for use in calculations and SELECT statements and ISCURRENTVERSION and ISACTUALVERSION() for Boolean checks Use…
-
DCA
Hi All, I wanted to understand that on applying DCA on a line item as I am making only certain values to the end users readable. So as my that line item with DCA is getting referred in another line item for the calculation purpose. So will DCA read access in anyway hamper the calculations or will the calculations will not…
-
Clear Module Data
Hi I need to clear data for all 5 level(5 Numbered lists) using single import.Individually i have created clear actions at each level and it is working but I needed it to be done at top level i.e if i clear at top level all the data at child level should also be cleared.Any suggestions to clear at Top Level. Thanks SriNitya
-
which user submitted changes
Hi, I am having user access management dashboard where I have one line item 'submitted by' which states who ever user is making changes its email id will appear. Currently it is a manual dropdown selection. If I want it to automate based on user then what should i do. Eg. suppose I am making changes for particular user so…
-
REP04 Employee Expense Summary Formulas
I am trying to develop calculation formulas for the REP04 Employee Expense Summary, but keep receiving errors and incorrect numbers. I posted each of my attempts with screenshots of formulas and results below and would like guidance in developing the appropriate calculation formula. First Attempt (1A): Created a basic…
-
Formula Error
Hi, I have a list of 'Brands' which is a production list. I know that 'select' function does not work with prod list members however, it should work with the list top member/ highest level . But when I am using it with the highest level i.e. 'All Categories' I am getting an error that the list member or version is not…
-
Numbered List update
Hi, I have a numbered list A with list items. These list items are getting imported through action from some other list B. I need to rename the list items of B and want the same renamed items to get imported to list A. When I rename the list B items and run the Import action, new list items A are getting created with new…