-
Formula error - dimension issue
Hi, Can someone assist with a formula error I'm receiving? I currently have 3 modules (see attached), and in the third module, I'm trying to calculate the number of meetings by entity and product. The error message I receive is: Dimension of mapping used for aggregation doesn't match any dimension of the source. My formula…
-
what is Hyper Model?
I read this news. https://community.anaplan.com/t5/Releases/Anaplan-HyperModel-Model-complex-problems-at-scale-and-adapt-to/ba-p/77929 In this article, many people comment that we can get more workspace 130GB to 700GB in Hyper Model. I don't understand what is Hyper Model. If we want to use Hyper Model, we have to pay…
-
Ratio formatting
Hi, Question please. I am trying to format the percentage change (in red box) with suffix of "pts" but when I click the percentage the suffix is disabled. I tried also using the Ratio in the Summary Method but still the same. How can I fix it? Thank you.
-
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,…
-
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…
-
DELETE DRAW PAYMENTS FOR AT JULY AND AUGUST
Hi. Dear Anaplan community. I am new here. I got something to solve and would like to ask for help. In ANAPLAN, there are set up automatic draw payments for Austria AT. This logic, was called off by the end of Q1. In the sales statement report, filtering the Austria AT, my colleague still see Draws for July and August. Who…
-
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…
-
User Access Issue - Cannot insert without a parent
Hi, There are two lists: A (parent) and B (child). List A has selective access turned on. Now, one of the users is not able to load items into the list B without a parent even with the proper access to the parent list. They are able to load only with Workspace Admin access. Attached is the error that the user received.…
-
How can I map these two dimension ?
I am writing formula for growth percentage where time dimension in weeks, and having product family as a list i.e. Product SKU's. In source module I have product family AS a dimension, where product SKU is third level of product family hierarchy. How can I map these two dimension ?
-
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…
-
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
-
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…
-
Planual Explained - Day 31
"Rule 1.01-04": Article 1, Chapter 1, and Rule 4” Consider All Periods. Consider the use of All Periods.This is effectively the Top Level for time and whilst increasing the model cell count very slightly it does allow for flexibility in modelling.It goes against PERFORMANCE elements of PLANS if you wish to go against this…
-
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…
-
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 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.…
-
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…
-
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…
-
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…
-
Deletion of Saved View for a module
Hi Experts, I'd like to ask, is there a way to delete a saved view? In my model there seems to exsit similar saved views, which confuses our develepment team members. So I want to delete some of them. Thanks in advance! Best Regards, Inoue
-
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…
-
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…
-
Descending number sequence with Dates (Months) as the heading
Assuming my heading is the time: Jan 19, Feb 19 to Dec. 20. This is due to a parameter set. and the range changes based on the parameter to be set. My line item will be Date in number. this will make Jan 20 - Dec 20 to 1, 2, 3 and so on. I have successfully sequenced Jan 20 - Dec 20. However Jan 19 to Dec 19 will have to…
-
Planual Explained - Day 32
"Rule 1.02-02": Article 1, Chapter 2, and Rule 2” Do not use formulas in the version settings. Whilst this is a simple construct and it might be OK for simple models; it effectively adds size to models every time versions are used in a module even if you don't want the variance. Also, in modules with 3 or more dimensions…
-
Subgroup within Parent structure
Hi Please refer the screenshot, we would like to further subgroup the records under each parent based on the job name. ex. for example, for the parent 'C-4K/768/960, there are 6 records, with two records for a job name. We would like to further subgroup the 6 records within a parent, based on Job name. Please see the…
-
INV01 Module - Some observations in Override Switches
Hi Anaplan team In both 'Óverride Suggested Order Amount' and 'Override Shipping Method' toggle switch scenarios, when ''checked'' the user entered values at lineitems Override Amount and Override Method correspondingly reflect in Final Shipment Amount and Final Shipping Method as per formula.Here are the steps : Initial…
-
ARIMA forecasting method
Hii all, Does anaplan has ARIMA method of forecasting inbuilt in any app?
-
Locked Saved Module View
Hi all, I am working on L2 Sprint 3 training and I ran into a saved view issue. Currently, there's a lock on the Default view and I'm not able to view my SYS00 Planning Period Filter for UX. Any ideas about what I may have done to lock this option and how to resolve the issue? Thanks!
-
sequential numbering in line item
Hi, I would like to know how can we create a sequential numbering in a line item. I saw some post where they use RANK but it does not fit the requirement needed. In the module attached, I have a line item Transaction number where I want to show automatic numbering (1 - 100 for example) of the number of transactions. This…
