-
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…
-
List formatted line item Dependent Drop down error
Hi guys i am unable to select properties that define valid combinations. Its greyed out for me. Is there a reason why?. My PC is list formatted to SS_MH04 pink tiara and the current line item i am formatting is called Select PC.
-
12.4.1 Activity: Create Saved View for Non Employee Expenses -
I have trouble doing this activity. i have already applied the filter but still data it is showing is from Jan 2019.
-
Custom Version Implementation
Hello everyone, Working with a client on a model which (due to workspace constraints) is utilizing primarily snapshot versions. After a recent increase in space (pending finalization), we’re looking to incorporate custom versions to all of the modules feeding the P&L for the upcoming budget cycle. Today all inputs, calcs…
-
1.3.4.3 Update SYS07 Location Details Module
I am trying to default option used, but the region code are not reflected please help on this