Modeling

transform data's timescale
if Module A is in weekly time scale, Module B is in yearly time scale. What formula should I use to pull a line item from Module B to module A? Thank you.
MBL2 Conclusion INV05 Formulae
Hi, I have spent a long time trying to figure out the formulas for the line items in the INV05 Shipping Export Module. For Shipping Costs - 'INV01 Inventory Ordering'.Final Shipping Costs and I know we need to also bring in the SKUs from one of SYS modules. However, I am unable to bring in the SKUs. Any help would be…
If I don't mark a list as Production List, what will happen? Since I don't modify my list often.
As I read, if I mark a list as Production List. I can make changes to it, even in Deployed mode. What type of changes? Properties, Subsets, Code?
Computation with Price Escalation
Hi Guys, I would like to ask something regarding a formula I have been working on. See the table below. Price Escalation formula = Input Avg Selling Price = The Jan 13 value is constant referenced to 2.3 which is in another module. While the succeeding months starting Feb 13 to Mar 14 the formula is Avg Selling…
issue in anaplan level 2 training content. Help!
Guys I think there is a serious issue in the formula suggested for building "INV01 Inventory Ordering" module in this course. The requirement is to write a formula that would result in "Final Shipment Amount" to get reflected in the corresponding week as "delivered value" based on the "shipping time" of the "selected mode…
Ability to move to different Workspace from the model itself
Current State Scenario: If you are working on a model and you wish to move to another model in different workspace you have to go back to Home screen then go to Manage Models-> Select Workspace ->Select Model Idea: From the current model we hit Manage Models->Select Workspace-> Select Model. This eliminates the need to go…
Improve a Numbered List
Improve a Numbered List
How to create an action to assign parent to item in system module
i have a flat list and want to create a system module having the flat item list and now i want to assign parent for that list item in the system module. How to create the action to assign parent.
Multi Scenario building
Hi.... I hope someone out there can provide some insight... I need to built something there I can recorded different scenario!! I already have a Scenario Version in my "Versions" however but I can only take one set of scenario "setting", I cant built anymore versions as every time I add a version it increase the size of…
Many to Many Dependent Dropdown
Hi, I have two lists, L3 - Plan and say Product Code. Now the Product Code dropdown line item in a module needs to be dependent on the plan line item. For this, I created a L3 - Plan formatted property in Product Code list to be used to drive the dependent dropdown. However, since it is a many to many mapping, a Product…
User Roles
Hello, I wish to create a dashboard where I could show the user - the roles of all the users and if they wish to change the user role they can update it from the dashboard, how can we do that? (I need an understanding how to display the user role of users on the dashboard) As deleting a user from a dashboard is not…
Formulas Text
I want to write Sweet for all taste. Please tell me, how can I do it?
Excel pivot in Anaplan
Hi Anaplanners, i have a situation wherein i need to build a sub-report using a excel raw data file provided.The sub-report is just an excel pivot that needs to be replicated in Anaplan with the same functionality that excel has ,eg,Multiple select filters,multiple tabular view based on selection,sum values etc Can someone…
Help Post ---- Import Parent Level data
Dear Friends, I am in urgent need, to find the Parent level total in a different module. But I am unable to do so. SUM, LOOKUP didn't work mentioning issues. Kindly help me, I am in really dire need.
Hierachy Import
I have lists with 6 levels of hierarchy. I want to pull data for level 3 from the highlighted module. Is it possible not by using parent function but by simple import to pull the data. What I was thinking, I pull the data for L1 and then use parent and item function. In that case, friends suggest me, what will be the…
Sum by Parent
Module Structure
Hi - I have a hierarchy with two levels, say. Level 1(Parent) is Material Group and Level 2 is Material. In the material list, I have the code and the description(name). I need a dump from anaplan in excel or CSV in the format of "Material Code | Material Description(Name) | Material Group | <<Time Periods>> - each in a…
How to enable a boolean formatted line item when two submit button is true
how to enable a boolean formatted line item when two other boolean formatted line are true. also how to to freeze the two boolean formatted line itme once the enabled boolean line item is true.
Ability to customize Dimensions for line item summaries
I would like the ability to customize the dimensions across which the automatic line item summary will apply. Currently, we can only specify Summary (for all selected dimensions) and Time Summary. This means that for multi-dimensional line items, if I need a summary over one dimension I am forced to summarize over all…
ALM synchronization
Does ALM synchronize Dev Data with Production Data and vice-versa? Even though they are in different environment? Please respond friends, as I am new to this.
Create non-numbered composite hierarchy with List Import where parents and children have same names
Hi Anaplanners, I am struggling with creating a non-numbered list composite hierarchy through List Import. As described in the attached file, a list I am trying to create include a child whose parent has the same name. I could create such a list manually but it failed when I try to create this list via List import from the…
Custom Disaggregation
Hi - I have a hierarchy with two levels - L1 and L2 (L1 is the parent of L2). The sales data is at L2 level. The forecasting is carried out at L1 level. The disaggregation logic for the forecasting line item from L2 to L1 should be based on the average proportions of L2 to L1 for the last three month sales. For example, we…
Production List
Please tell me friends, if I mark a list as a Production List, then will it be visible to end-user? And how can the end-user update that list? By clicking insert as we do from development? Or we have to create action button for this?
Anaplan—Spring Cleaning!
It is not uncommon for the way in which your organization uses Anaplan to grow and change. Sometimes, your business processes change. Sometimes, individuals enter and exit your organization. And sometimes, you simply think of better ways of doing things. The good news is that Anaplan is designed to help you respond to all…
Tree View not available due to large lists
Tree View have to be available even if the list is large. Anaplan could show it on different pages, but it's a big limitation to the client if they can't see the tree view list.
Adjust Size of List Items in Columns
We have an option of adjusting our Row Size, this is useful when we don't want to show the dimension of the module. There are cases when we don't want to show Rows as well as Columns of the module like the typical 2-D/excel way of displaying things. Hence Proposing an idea of Having an ability to adjust the Size of the…
Unknown Error
What is this error? This error occured when I added "[SUM:XXXX][LOOKUP:YYYY]"
Selective Import
In Anaplan we have. Now we want to maintain monthly data appending. This works fine. Next I find the old actual data for some records was incorrectly entered. I update it in the Hub but it doesn't get reflected in automatic process, as it takes the old values. I don't want to select the other option as my old data might…
Retrieve information from subsidiary view to use in a Boolean
Hi, I need to retrieve information from a subsidiary view and use in logic in another Boolean formatted line item. I want to see which account is unassigned during a given point in time. I already had a subsidiary this by month. I needed to see it with a yearly time scale as well so I created the view below with time scale…
Click through Formula
Formulas should be clickable. Ex: If formula for one line item is as follows: Sales.Actuals When we hover over Sales or Actuals then it should become underlined and clicking on Sales should automatically open Sales module.

Modeling

Discussion List