-
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.
-
App Hub
Would someone advise how to find the App hub. I am following the module directions but I do not see it on my end.
-
Data Spreading Across All Items After Model-to-Model Import
I’m facing an issue with a model-to-model import where data is getting populated across many target intersections even though the source does not have values there. Source module setup: Dimensions: List A, List B (numbered lists) Time Versions 2 additional lists In the saved view used for import: Rows: List A, List B, Time…
-
Anaplan level 1 activity 6
I believe i have the correct formulas here for the level 1 activity 6 question, however when i exit blueprint nothing is populated, i originally ran into the issue of having region and role not as lists but the formulas now all work and are able to be applied, scratching my head as to why nothing populates
-
Anaplan Workflows in ADO combo to execute a FOR loop
Haven't used the new workflows yet so don't know it's full capability or limitations but does anyone know if I can use it to execute a FOR loop? E.g. traverse one list item at a time and then execute logic against it? I mean the bulk formula calculations is awesome but there are just some specific scenarios it best runs in…
-
Time hierarchy filter new ux when brought forward option is turned on?
Hello, Does anyone know any workaround or a solution to be able to enable the hierarchy filter in new ux when the brought forward option is selected in backend? I do not see the above hierarchy filter option if I enable the brought forward for a line item-
-
SUM vs LOOKUP performance considerations
Is there any performance cost difference between a) SUM on a list line item in your data module, and b) dimensioning your data module by the list, then LOOKUP on a dimension? I am asking because I have a data module that is dimensioned by several large lists, creating sparsity. I can reduce sparsity by removing some of…
-
Concatenated List for to store Archiving data
Hi Anaplanners, I’m working with a calculation module (Module A) that is dimensioned by a concatenated list, Time, and Native Versions. In this module, I am performing a subtraction using values from another module (Module B), which is dimensioned by Native Versions and a different concatenated list. The two concatenated…
-
1.4.3.2 Import Data & Add Formula
Unable to see the Product details in SYS12 SKU Details. Someone help me on this? would be much appericate
-
Moving Sum for Formula driven number format line items
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
-
Import error due to incorrect time mapping
I have this template to import back to my module By right it should match the module because the time format is the same as the module the only difference is that in the excel file there is a seperator. M-Y. Thus logically to me it should be But when i run the action using M-Y and match names both result in an import error…