Hi All, IN Excel you can double click on any value in a pivot table and it will show you the underlying records that correspond to the output you clocked on. I have a Module dimensioned by a numbered …
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 t…
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 S…
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 i…
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…
"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 t…
"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 i…
"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 sligh…
"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 ACTU…
"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…
"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…
"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…
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 …
Hi Pls can you help : ----------------------------------------------------------------------------------------------------------------------------------------------------- The formula for 'EMP02 Emplo…
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.…
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 it…
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 sele…
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 …
"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 model…
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 reco…
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 Met…
Ability to see how much space is required when adding new members in a list. For example, adding a new cost center would increase the entire model size by 10M cells. This would allow model builders to…
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…
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 …
Hi All, I needed a logic to pick the values as below: If my current month selected is Jan, Feb or March FY20 then populate the value from Oct , Nov and Dec FY19 respectively. Thanks & Regards Madhu
HI, I have one Account flat list which has code for every accounts. there is one more flat list account items which is related to items within the accounts. So one account can be related to many accou…
Hi, I am trying to split multiple SUM&LOOKUP's used in a lineitem in a module in order to optimize the model performance. But while splitting the SUM & LOOKUP into different line items in separate mod…
Hi, I am trying to format a view for a dashboard based on the business requirements and to make it more presentable in Anaplan. Following are my doubts, * How can we change the row height in Anaplan? …
I am creating a page in the new UX to give users the ability to add new Strategic Suppliers to a Strategic Supplier List. I used the Form Editor to create a form, but I am getting an error message tha…
