-
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.
-
New solution architect Exam
I have completed my L1 and L2 certifcation exams and would like to know what are the next steps for getting certified as a solution architect. Thanks in Advance
-
Level 2 Sprint 3 Stock Exception REview Dashboard
hi when I click to select FY21 the table data still included months in FY20 see attached
-
Series of Action (Process)
Hi Friends, I want to know, I have 6 Modules. Mod1 data flows to Mod2----> Finally Mod6. Now can I create any Action to automate the full process?
-
Filter formular Monthvalue
hi, how do I construct a formula using monthvalue to be used as a filter ? thanks Donna
-
Cannot enter decimals starting with a dot via new UX forms
It seems that we cannot enter decimals without leading zeros (i.e .068) via forms. The field on the form is from a module with the same list and has the number format. When I open the module, I can enter the number as .068 in to the cell but cannot do it via the form because it is giving me an error saying "Not a valid…
-
Very urgent ---- Formula assistance needed
Module 1: I have a Transaction List and the Employees responsible for the Sales. Module 2: These are 3 types of Cars of different cities Commission percentage. Module 3: Now the challenge is I have to make a new module with Employee and Commission. But the data should be flowing from Module 1 by ‘Connect to Anaplan Model’.…
-
mapping of property
Hi, I have created a list with members : A,B,C. This has a property with values 1,2,3 respectively which is also a list. Now in my list with 1,2,3 members, I need to map the values A,B,C (list) so that 1=A, 2=B, 3=C as shown in screenshot below : Is there a formula to automatically link the Property in List 123, to List…
-
The ability to see entire Note, Applies to, Referenced By fields inside blueprint view
It would be great ot see the entire Note section in the blueprint view without having to copy and paste it into another tool, double click into the note section, etc. Double clicking into the note section isn't ideal in Standard (Non-Deployed) models, as it can lead to the accidental editing/deletion of the note field. One…
-
Filtering Import
This is my Original Module. Now I want to create a New Module which will have only Orange Data. But I can't use Lookup, as I have restrictions of Formula Linking. Only thing I can do is Import. Is there any way to do it? Need your support.
-
MBL2: Conclusion INV05 Shipping Export
Hello! I would appreciate some help with the 'calculate shipping costs by location' formula in the INV05 Shipping Export -module. It seems like basic LOOKUP-function, but I can't get it right. The problem seems to be here the different time scales when I use values of DAT02 Shipping Metrics -module (month vs year) and time…
-
Data Pulling into Target Module
Hi Friends, I can't populate directly from list but need to populate the values from Module 1. I was trying with LookUp but it throwing error mentioning 'List does not have a built-in top level'. Please help. I am learning on my own and none to ask assistance.
-
Dashboard for beginners
Hi Friends, I want to learn how to create a filter list item in a Dashboard. Such that if that list item is selected, automatically the associated modules displays only that values. Any link will be helpful.