-
Subset Update on Selective Access Enabled list - Workaround Suggestions?
Hi All, I'm Currently Optimising some of our Cell-Count Intensive Reporting Modules, I've an almost working solution except for this limitation I'm facing. We've around 5-6 Reporting modules in our model which is Dimensioned by Levels of Promo Hierarchy X Users, promo Customer Hierarchy X users. Since the promo customer…
-
Different Aggregations for Different Dimensions
I have a REP01 module with Account 2 (R1, R2, L1, L2, E1, E2) and City(City 1, City 2, …) dimensions and an Amount line item. City rolls up to Region (Region 1, Region 2) Account 2 rolls up to Account 1 (Revenue, Labor, Expense). In REP01 module's Amount line item, I want to sum in City dimension but use a formula of…
-
CUMULATE optimum use
Hi All, I'm trying to replace the use of CUMULATE to produce a running total in a module Dimensioned by 'fake time' - so I can't use PREVIOS, for example. I am trying to establish if this is a worthwhile exercise - the relevant MAPS report shows 00.00% calculation effort against the CUMULATE formula and a relatively low…
-
Import Final Demand Forecast into DATA02 Module - Would like to have your suggestions on this.
Not sure the way i handled this scenario right or wrong, would like to have your thoughts on this .. Since the Supply chain model, dem03 final demand forecast dimensioned by Accounts, Product SKU's. However, my assumption is FP&A, No way related to accounts(we didn't added any lists for account during the FP&A model…
-
Limit the resulting value to a specific File Type
I have data organised by File Type, so has values such as: Month End Flash 1 Flash 2 Flash 3 Flash 4 Flash 5 For Cohort 202602 (Feb 26), the module holds data for Flash 1, Flash 2 and Flash 3. I only want to bring in the data for the latest Flash version - this is shown in the Module in the line item called File Type…
-
Trying to use a formula to choose a value to use in a calc
I am trying to choose between 2 values to use based on a value in another module and lookup to a Cohort from a month value. So, either the Extrapolated Blank Tariff CoS if the Cohort has Flash ticked in Month End Attributes, or Blank Tariff CoS if the Cohort does not have Flash ticked in Month End Attributes. This formula…
-
Formula not resulting in the correct value
I have the following line item and formula, but it appears to not result in the correct value, the correct value according to the formula and the excel version of this is: 302,590 and not 315 as in Anaplan. All of the correct values are pulling through into the calculation so this is probably a syntax error that I cannot…
-
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…