-
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?
-
Ask each time import version
i have three version YEP 1, YEP 2 and Budget. Only YEP 1 and YEP 2 have the option to select mapping. Budget is fixed mapping. How do i restrict the selection to only show YEP 1 and YEP 2
-
How do we convert these column time into time dimension in anaplan
basically this is a transactional list wherein attributes are from A to E column. Need to create a hierarchy from A to E then convert these column to time .
-
Model Building Activity 5
Good day If anyone could assist it would be great - I've been stuck on Q5 of the L1 Exam for hours and failed one attempt already as a result of being logged out. I tried to look on the community and seems like many have had the same issue but answers seem deleted of unclear. The above seems relatively straightforward. The…
-
Field selector should also select parent
I have a list Parent = Fruit Child = Mango, orange and apple. When i set up my field selection i can only select at child level. How can i select for parent level as well. I want my field to be dynamic. Means it can select at both child and parent level.
-
I am trying to create a dependant filter for a line item formatted by Lease Type
Create a Relationship between Lease In/Out and Lease Type Create a Dependency link. If Lease In No option to select. Selection will be blank If Lease out have option to select Operating Finance Any idea how i can create this?
-
Limit Time selection
I have a switchover module which is dimensioned by custom version and Line item custom switchover. Called SYS105. I have a Switchover selector module called FUX104. I want the selection to be limited by SYS105. Currently it shows all months. The end output is i just want to see May 25 and Sep 25 as the selection instead of…
-
Error on Copying Model
Hello Community, I had to create a PROD model from existing Dev and UAT models. I created a model using a Revision Tag, and everything worked just fine. However, if I tried copying the model directly, I got an error that I did not understand. It creates a copy, but the copy does not open. Could you help me understand why…