-
Mapping Cohorts in the format YYYYMM to Time value Month
I have a module that has 4 line items, 2 of which work on Month which results in the correct values, however 2 work on something called Cohort - so for example 202204 is Apr 22. See module below, the top 2 result in blanks/zeros and the bottom 2 result in correct values. So I want somehow to map the Cohorts to the time…
-
Collect then Cumulate or Cumulate then Collect?
We are thinking of an addition to a key model in the business process. Unfortunately, we do not have access to BPI numbers for either of these Cases. Am I correct in thinking Cse B, below, is the better option. If not why not? Both cases A and B are described below. All Line Items (‘Refs) are constant across both Cases…
-
How to calculate the weight?...
Hi all I have a list of networks organized hierarchically on a list of entities, which is itself organized hierarchically on a list of divisions (organization). An entity can have several networks. I also have a list of product models, which is itself ranked with three higher levels: this “Models” L4 list is ranked at a…
-
I'm trying to bring a value in from another module but it results in a blank
Referencing in the Blank Tariff module below the Total Handset Revenue from the P&L module, however the value is not shown, instead I see a blank. Any ideas?
-
I'm trying to calculate a % value based on the CoS of tariffs
The calculation needs to work on the CoS values in the below, so trying to compute the Blank Tariff CoS value as a % of the Relevant Tariff CoS, so for example - 244,024/14,878,715 = 1.64%
-
When will this "Coming Soon!" functionality be coming?
Greetings, Product Management People! This support article from nearly a year ago alluded to Dynamic Bulk Copy coming soon! https://product.anaplan.com/supercharge-your-model-building-efficiency-with-anaplans-upcoming-modeling-features-53955fd1-9330-4aaa-b145-484ad733afc3 The screenshot shows the option to select the…
-
Unable to open two models that totals 110Gb in a 130Gb workspace at same time
Has anyone experienced this? I have two models of similar size. Both models sum up to 110Gb (57Gb and 53Gb respectively). Models are responsive if you only have one of them open. But the moment you attempt to have them open at the same time all models in the workspace become non responsive. Eventually you get the timeout…
-
Corrupted Import Action
Hi, I'd like to know if my issue already occurred to anyone here. I created a saved view out of a module using different hierarchical lists. In the saved view, I pivoted the dimensions and restricted the view only on a specific line item. Then, I used that saved view to import data into another module however the data…
-
Finding the lowest element
Hi, I have the following problem to solve and I’m not sure whether it’s even possible in Anaplan. I have List A with a certain number X of elements. For selected elements from List A, based on which I create a subset, I determine the components that make up each element. There can be a maximum of 6 components. Each line…
-
In the L2 we were discussing about intermediary module to connect the Source and Target
How to connect the growth % which has the Product family as dimension with the P3 SKU using intermediary module..I'm stuck Can someone help?
-
DCA is active for an ID, but data is invisible
For a line item, where DCA read and write both accesses have been provided to an ID, but that person can't see any value. The ID has full access to the model, only difference is, the ID is not WSA. Can this make any difference? To clarify more, that particular line item has four dimensions, i.e., Users, List1, SS:List2,…
-
How to identify if I have access to Polaris WS ?
How to identify if I have access to Polaris WS ?
-
FCR: How to Delete Custom Dimensions from Default Consolidation Model
Currently in FCR, I am attempting to delete a custom dimension that was added to a default consolidation model. I have the appropriate permissions enabled and am able to delete dimensions from other consolidation models that I have created. However, for the default consolidation model, the trash icon is disabled (grayed…
-
Formula Calculatin Time
I have a MAPS formula calculation time of 8,929,021ms - which I think is around 149minutes ( dived by 1000 to give seconds, divided agian by 60 to give minutes. Is this correct? If it is correct - how does Anaplan deal with such a long calculation time? Thanks in advance for your help.
-
ISFIRSTOCCURRENCE returns duplicates due to extra dimension
Hi ALL, As shown in the screenshot: Columns are Locations and D2 Roles. Each Location is mapped to a Final Region Set (e.g., Toronto).The module is dimensioned by Locations and D2 Roles. I want to export this mapping to another model, but in the target module, I don’t need the D2 Roles dimension. When I try to use…
-
why is the basic lookup not working?
Module 1 : UID * FCST - source Module 2: FCST - Mapping Module 3: UID * Time Range- Target formula used in module 3 module1.line item[lookup: module2.timeperiod]
-
3.3.5.2 Inventory Ordering Module Formulas
Hi, I belive My Formula is correct for Beginning Inventory line item of 'INV01 Inventory Ordering' Module and I made some mistake in SYS01 Time settings by week Module with the Line item 'Not 1st week of Timescale?'. Do i need to change anything in SYS01 Module. In the INV01 Module the value is increasing instead of…
-
Importing Data Module 8 Error message
Would someone kindly assist with helping me identify the errors with the following perimeters I have set?
-
How to get most recent actual year value into a non-time (staging) module and use it for forecast ca
Title: How to get most recent actual year value into a non-time (staging) module and use it for forecast calculations? Question Body: Hello Anaplan Community, I am working on a financial model (Higher-Ed long-range planning) and need guidance on a best-practice pattern to retrieve the most recent actual year value and use…
-
3.3.5.2 Inventory Ordering Module Formulas
I was trying this forumla for Beginning inventory Line item, it says below error. My DAT01 Beginning inventory also good for my concern. Is there anything missing from my side.