-
Referring Property values of one List from another List
Hi Team, I am trying to pull the values to my numbered list property from another flat list property. Here L1 and L2 are my lists and A, B, C are my properties as below. I need to pull data to property B (text or list formatted) from property C. L1 (numbered list)A (list formatted to L2)B L2 (flat list)C (list formatted )…
-
Remapping Line Items between Modules
Is there a best practice way to remap line items between modules? What I mean by this is taking a set of line items from a module and remapping them to another set of line items in a module, as per the screenshot below? My use case for this would be to summarise P&L lines or to reclassify line P&L lines into a different…
-
Line Item Date Format
Hi, I am developing a model in India and the client is from US. I created a line item 'Creation date and gave formate date where they can select particular date from the drop down. The format of the date is DD/MM/YYYY. But client wants it in MM/DD/YYYY. Can we do it directly? I know a work around of making it text and just…
-
review query 299
Hi, Can people in one region can book a slot for other region for 299 model review? for examaple, india consultants can they book review in emea or americas?
-
Linking a set date to a specific time range
I spend the last 2 days trying to dynamically linked a specific date (specified by a user) I created a module to have visible the versions, country and initiatives (as my lists) and of course the line cost items and calculate the monthly charge per cost line item per costing type based on the elapse time between start and…
-
API Usage Limits
Does anyone know what the Usage Limits are for the Anaplan APIs? Also, is there any max of concurrent calls for the available APIs?
-
Dependent Dropdowns - Many to Many
Is there a way to enable a many-to-many relationship on dependent dropdowns? If so, how do you do this? To provide some context, I have two lists: * Departments * Employees Employees can belong to many departments. (Currently have a module which assigns employees to departments using two dimensions, employees and…
-
Delete multiple items/rows from list.(more than 5000)
Hello Members, I wanted to delete more than 5000 rows(nearly all) from an independent numbered list but at the same time wants to save the list and its properties. If we delete any items/row from the list containing more than 5000 rows, it says to select and delete and by this only one is getting selected and not more than…
-
displaying numbers instead of names
I don't no why it has been changed suddenly , i didn't make any changes. Can you say me what is the problem? @DavidSmith
-
Converting data between line items with different lists
An important factor of Anaplan is transforming data between dimensions of modules and line items. For example, if I wanted to convert my sales amounts, which are currently stored by employee and product, to a summarized level of sales region and product, I’d need to do a conversion to summarize the data assuming sales…
-
Lookup on Parent Elements
Got the idea I'm trying from here: https://community.anaplan.com/t5/Anaplan-Discussions/Lookup-on-Parent-elements/m-p/1478#M2397. But, we needed to change it up a bit as I need it to be user specific but it's not working. I created a very simplified version of what we are trying to do on a larger scale. I started with a…
-
Filter on the basis of selective access
Hi Team, In a module there is a list formatted line item(List is having selective access). Suppose the list has the members L1,L2,L3,L4,L5.... And in the module at list formatted line item records having above list members. I want to filter the data on the basis of selective access. A user having access on L1, L2,L3 can…
-
Sumif quantity between two dates without time dimension
Here is my problem, I have two different modules without timescale or dimension. One module has quantity and dates. Second module has start date and end date and I would like to sumif within the range of the start and end dates. Please guide me if there is a way to solve this.
-
Bespoke 4-4-5 / 4-5-4 Calendar
Hi, My client want to recreate their bespoke calendar in Anaplan. It is two quarters of 5-4-4, followed by one quarter of 4-5-4 and another quarter of 5-4-4. See below: Does anyone know if this is possible or is dummy time the best option here? Many thanks, Matt
-
Input at multiple levels and view the Roll-up
Hey Experts! Well, this is something really 'Out of the Box' ask from one of our requirements. And upon first look, I really think that It's kinda out of scope of anaplan. Here's the ask: So if you have a look at the below snap, we tried to replicate a part of our existing Sales hierarchy : Let's say that in one of our…
-
SELECT Function
Hi, Please see details in the attachment. Regards,
-
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…
-
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…
-
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.
-
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…
-
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…
-
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