-
Single Thread and Cumulate
Hi, I'm reviewing a model MAPS report. the model includes 5 instances of 'Single Thread' cases all involving the Cumulate function. I can't figure how to resolve these. Does anyone have any pointers or ideas?
-
Quick sum bar not supported in Saved View
I wanted to check if others are facing this specification difference between Grid Card in Additional Insight. When created using a Saved View, the Quick Sum bar feature does not work, but when created using the module directly, the Quick Sum bar works.
-
How to use a different 'Current period' for different versions
I'm working on a model with three versions: Actual (Actual version), Scenario: Prognose lopend jaar (current version), and Scenario: Budget volgend jaar. For one of the calculations, the Scenario: Prognose lopend jaar version needs to use a different current period than the Scenario: Budget volgend jaar. For this, I…
-
How to Implement Selective Access with Flat Lists
Hi Anaplanners I need assistance on achieving this. I have: Flat Region list (e.g., Region A, Region B…) Flat Retailer list (e.g., Retailer 1, Retailer 2…) In the spoke model, these become a composite hierarchy (Region → Retailer), which makes selective access easy. But in the Data Hub, the lists are flat, and I want users…
-
Level 1 model building - Numbered emp
Required import My import Can someone help with this? How to get the name of the employees in above e.g. instead of #1039 get Shala Engle.. Thank you,
-
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…