Modeling

SELECT Function
Hi, Please see details in the attachment. Regards,
Parent Child Mapping Error
Hi, I'm trying to load master data in the system but in the files which I trying to load have erroneous records like one child has multiple parents. So is there any work around in which I can identify those combinations in a staging module for error check in anaplan.
Option to insert action before or after
Currently when I create an actions from within the Actions tab I only have the option to add this at the Start or End of the list of actions. It would be very useful to be able to select an existing action and use the 'Before' or 'After' functionality that exists when creating module or lists. This would save a lot of time…
When to use Line item VS List ?
Hi Guys Is there an approach you guys use when deciding on line item vs list ? for eg. I am loading three different kinds of volume data Volume type 1 Volume type 2 Volume type 3 Data is loaded by month Option 1 Create a module with 3 line item and time dimension Time Line item Volume type 1 Line item Volume type 2 Line…
Importing a spreadsheet into a blueprint view: ability to map to column headers
An awesome function that's so close to being functional is importing a spreadsheet or another module/view into a blueprint view. Right now, unless I'm doing something wrong, I can only map things to Line Item, Code, and Parent. It would be awesome to be able to map everything that's in the Blueprint view column headers and…
Apply module defaults for timescales
I would like the option to use the "-" setting for time settings in the module blueprint, as per the Applies to Since I rarely use subsidiary views, if I need to change the time from, say week to month, I then have to apply this change to all line items, whereas using a default would save time
Day level calendar setting
Is it possible to have a 'day' level setting in the calendar type. We need to plan at a greater level of time sensitivity than is currently available. At present, we use Anaplan for weekly and monthly - it would be great if we could do the same for daily too.
Section 6: Region Goal Set- Projected Goal
This seems to be a reoccurring topic. I also am only returning an answer of 0. My equation is Region Percent * Geo Goal Set.Projected Goal[LOOKUP: Parent]. I have also ensured my Forecast version is current as well.
Creating views/"child-modules" with a calculation layer?
I have a master warehouse budget model which has several modules but let's consider the following modules for example: Shipments, Freight Charges, Headcount, Inventory etc. All are inter-linked by formulas and the setup is complete. I now wish to create child warehouse budgets with the entire set of modules as the master…
The Truth about Sparsity
In case you missed these from the home page: https://community.anaplan.com/t5/Blog/The-Truth-About-Sparsity-Part-1/ba-p/44493 https://community.anaplan.com/t5/Blog/The-Truth-About-Sparsity-Part-2/ba-p/44736 David
Formula
Hi Experts, I have a requirement and i am confusing how to resolve this. First Module Row Axis:Product Column Axis:Line Items Second Module Row Axis:Flat Product Column Axis:Line Items Both Product and Flat Product have same members. I am trying to multiply First Module line item * Second Module line item. How to write…
Fully connected planning for contact centres
Contact centres regularly use expensive workforce management solutions that are inflexible and difficult to work with. These solutions focus on managing call handler schedules (ie what they're doing at each point in the day) against customer fulfilment (how quickly they're getting to support that customer). These solutions…
data import query
Hi @DavidSmith , I had one more query . For instance, A module consists of 6 line items, Is it possible to importing the data into module for each line item separately( as of new set of data into each line item), If possible then importing of data is of same way of uploading.
Read access and write access driver query.
Hi, I used read access driver and write access for a line item to get the dynamic cell access. (calculation formula is used to get the data for this line item) . 1)It is not working though I used DAC concept 2)Quaterly data is also not displaying for that line item though I changed summary items to ALL or ANY from None.
Selecting Time averages
Hi, How to select the yearly average value of a line item from a module that is dimensioned by time (monthly), for the current year, in another module that is not dimensioned by time? Please note, I wish to make the formula dynamic and not use static values like TIME.FY19 I have a "Shipments" module that is having monthly…
selecting TIME period
Hi, How to select the yearly average value of a line item from a module that is dimensioned by time (monthly), for the current year, in another module that is not dimensioned by time? Please note, I wish to make the formula dynamic and not use static values like TIME.FY19 I have a "Shipments" module that is having monthly…
dynamic cell access query
If I am using dynamic cell access to some line items by using write access drivers and read access drivers then quaterly data not displaying, If I am removing it , then it is like usually displaying normally quaterly data. Can anyone explain what is the reason behind it.
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…
How to select one line in a grid and refresh another grid
Hi, we have a dashboard which contains 2 grids. The first grid is applied to a list. The second grid is showing items based on the selection of the first grid and applied to another list. We need to select one line in the first grid, and let the dashboard auto-refresh the second grid based on what selection the user makes.…
Issue With Percentage Data
Hello, Specifically I am unable to enter values (format is Number with Percentage) 3, 6, 9 for a line item. Except the above 3 numbers I am able to enter other numbers. While entering 3, 6, & 9 in the cell, it is getting automatically replaced with 2, 5, & 8 respectively. And this issue I am facing with Microsoft Edge with…
Show first 100 rows in Drill Down
The message received when trying to drill down onto a cell which references a large list is as below. Instead, can there be a enhancement to add the grid filtered down to the first 100 rows so that users can continue troubleshooting in the Drill Down window? Thanks! Cannot display grid for line item <sample line item> too…
How to create multiple list items from a module
Hi there, Just wanted to know is there any way that I can create multiple entries by using a module? ( by using list we can create multiple list items by using + sign) Requirement is, when we select a particular D6 department by using a page selector of Departments(they should be created under a selected D6(We have D1 to…
Make Existing List a Parent of another Existing List
I have two lists that already exist. The first list has items that are a concatenation of employee, role, and project. The second list is just the projects. There is a module that has the following items (in addition to others): * Text format: concatenation of employee, role, and project * List format: concatenation of…
Allow order of CUMULATE function to be defined by the user
The CUMULATE function when used against a list, currently accumulates in the original list order even when the list has been reordered. Anapedia states this is how the function is meant to work, but I would like it to take into account if the list has been reordered, and cumulate in the new order. Description of the…
102 certification Missing model
Hi, I may have accidentally deleted the 102 certification model and now i don't know how to retrieve it? Is there a way to put it back as active model in my account? Thanks
Unable to create button to add new entries into line item by using action
Hi, I want to create a button in dashboard for adding new entries to line items. see here, here i want to add new entries such as i want to add '9' next to '8' as ways for i want to delete '7'. For this i want button to this action dashboard. So while creating action. I am unable to find this(Capex Inputs) in action…
Line items with list dimension - Importing data and design of model
Hi, I am modeling our warehouse operations and it has a bunch of line items and "categories" as follows: Jan-19Jan-19Jan-19Feb-19Feb-19Feb-19Mar-19Mar-19Mar-19 I/O…
Anaplan connect with batch file model building import question
When importing data from anaplan connect with a batch file what is the best practice to automate the data through a batch file. Is the best model building practice to create a list for the data to flow through the list. Is it possible to have the data go directly through a module? Are there row limits when having the data…
finditem in list with parent as a lineitem in module
Hi, I have this module of list Quota Types and I want to find the items Quota Types list and display them in Secondary of Secondary Quota Name line item below, who has a parent of Secondary Quota Name I'd love some help please! Thanks 🙂 Amanda
Numbered Lists renumbering
Hello, Is there a way to reset the number generated in a numbered list? Also, is there a way that we can sort a list in alphabetical order after import? Thank you!

Modeling

Discussion List