-
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…
-
UX Pages - Guidance on Cataloging
Hi, I'm working across 5 models with the follwing profile of UX pages - model A. 69, model B. 132, M C. 31, M D. 49, and M E. 33. Total of 314 New UX Pages. This strikes me as quite a number of pages to keep track of, and I think building a 'catalogue' with some relevant data would improve the User Experience, and the…
-
User Selective Access
I have a selective access cost center list in a flat format that contains multiple hierarchy levels. I need to assign more than one cost center parent to a single user. While this can be done manually, I would like to know if there is a way to import this through a CSV file instead. Could you please confirm if this is…
-
RetrieveTIMESUM using ANY
Hi everyone, I was trying to Retrieve a Line Item (Boolean) using TIMESUM as formula to another module by using ANY. This Boolean LI has A,B,C as dimensions. My target module has only A as dimension. In order to use a reference module for mapping, does this reference module had to have A,B and C as dimension or just A…
-
Field Selection (Not give the option to select Top level)
I have a list call lease ID that has a top level called All Lease ID. I do not want the top level to be seen in my selection. What can i do ?
-
I want to apply conditional formatting to summary
If all periods exceed 100% i want it to flag red like below. How do i apply the condition at summary level?