-
L1 Model Building - Lesson 7 Data Mapping issue.
Hi Everyone, I am stuck at 7.2.3 Activity: Import Data into Employee Details Module. The instructions are not clear how to map E2 Employee# list ,which is a numbered list, to the .CSV file. There is Hint in the lesson which clearly says this: * HINT: The E2 Employees# list is a numbered list and each record is assigned a…
-
How to exclude a year while calculating the projection
I have a requirement where in i have to exclude the year 2020 while calculating the cy projection sales for 2024. Hence when i calculate, i choose a last 5 year period (2019-2023). However in this last 5 year period 2020 gets included. I need to calculate for all years excluding 2020. How do i do this? also for the last 5…
-
Sales rep monthly Commission not matching with Anaplan 'Check Your Build' numbers?
Hi All Community Members, Despite putting a lot of thought and efforts, I am not able to figure out where am I going wrong. I have set all the Modules and formulae in place but still the numbers for the sales rep monthly commission is not matching with the Check Your Build numbers. Please find below details of my modules I…
-
"Level Mismatch on Common Dimension" Error when Changing Parent of List
Originally we had A1 Expense Group, A2 Expense Category, and A3 Expense Account. We added A3 Subcategory and changed the naming of A3 Expense Account to A4 Expense Account. We have been unable to change the Parent of A4 Expense Account to be A3 Expense Subcategory. Attempting to change this gives the error "Level Mismatch…
-
changing dimension of a module once its created
I'm trying to add a column to an existing module in Anaplan, but I can't seem to find the option to do so. The only modifications I can make are to the lists, time scale, and version of the module. How can I add a new column to a module once it's already created? Any guidance would be appreciated!
-
Filter for selected native versions in saved view
Hi I would like to have a filter for native versions (i.e Current Forecast and Budget versions only) for an import view. I have set up a version system module where I can tick the boolean against the current forecast and budget version and use this filter but whenever I bulk copy current forecast to another version, the…
-
First Occurrence on module with multiple lists in "applies to"
Hello, Does anyone know if it's possible to do a firstoccurrence formula on a module with 2 lists in the 'applies to'? Thanks! Josh Brass
-
[Select: Time. All Periods] works for Model calendar and Time ranges
Hi All, [Select: Time. All Periods] works for Model calendar and Time ranges? Somehow, its working for Model Calendar but not for Time Ranges. Do we have any similar function for Time Ranges? Thanks AB
-
[Guide] Multi Level filter selection on composite hierarchy
If you are using a multi level composite hierarchy as your main reporting list (as you should vs ragged), you have encountered the need to filter it and display many levels of it in many different dashboards. Recently re-discovered a solution that I find quite handy and decided to share it here. Here's the result. As you…
-
Import is zeroing out a field that it shouldn't be
Hi team, Got one that for the life of me I cannot solve. I import the below file and the numbers load as intended. You can see the imported numbers below and the mapping from the import The trouble I run into is when I run a second import. looking at the data im importing, there is no line going to CC 3602 and GL 65566,…
-
SYS07 Distribution Center Details | Default Shipping empty
Hello everyone, I’m stuck because the column 'Default Shipping' in the Supply Chain Model is not populated after I run the import from SYS07 Location Details —> Import Distribution Center Details saved view (Data Hub Model). Can anyone help me please? Thank you
-
Datatype mapping used for aggregation doesn't match any dimension of the source?
I am trying to pulling billings from a calc modules, the source and target modules are both dimensioned by country but I keep getting this error. Note: I am trying to pull in billings from CALC02 which is sourced from CALC01. CALC01 is pulling from a flat data module. Please advise…
-
Ranking of Formula Performance
Is there any 1 place that does all the rankings of formulas in terms of performance? The formulas I am trying to rank are…. Moving sum, YTD sum, cummulate, and timesum. In ranking fastest to slowest, I would guess…. YTD Sum, Moving Sum, timesum, cummulate.
-
1.6.3.1 Create DAT04 Distribution Center Parameters Module
I don't find SKU flat list. What did I missed please
-
Creating General list from A module's line item
I have a module called Project. It has line item called "Project name". Project name line item contains only those projects which are approved (used formula to get these) My question is can we create an general list from the Project name line item, as i have to use this list as format to one of my screen. One possible…
-
Switch from Context Selector to Boolean - Scope of view
I'm trying to optimize a module for space. At current the module alone occupies 33 GB of space. The module is a cross dimension of 4 lists as seen in the picture above. with time month granularity. The idea is to reduce the dimension count to 3 by removing one list. The 9LE List shown in the applies to above. It has two…
-
L2 Conclusion | Create Shipping Export Module and Create a Saved View
Hello everyone, I'm stuck at this point. I entered all the formulas for the line items in the module but as you can see the shipping costs line item is zero value. Also in INV01 Module the shipping costs are zero and I can't understand why. Anyone who can help? Thank you very much.
-
End User unable to run action to update a subset
Hi All Have a super-user who is Full Access as model role but not a Workspace Admin and so therefore should be able to run updates to list subsets. Is there something in the depths of Anapedia that says that this isn't possible? I'm almost sure that we're doing this elsewhere in other models. Thanks Andrew
-
Sum based on Boolean
Hello, Hopefully a simple one. Our P&L has 50 cost centres, each of which have staff costs assigned. In a separate module I want to bring in the staff costs from 15 of these - is there a simple way to do this, for instance by having a separate module with the cost centres included and a boolean line item to determine which…
-
Use of PREVIOUS function
I'm sure I've used the "PREVIOUS" function before without any problems but on trying to use recently it doesn't now seem to be returning the values I would expect As you can see the formula Previous(Volume) is specified, which I would have expected it to return the FY23 volume value of 218,116; however, this doesn't seem…
-
Set up custom time scale
Hi My current model is using a fiscal calendar e.g. FY23: 1 Jul 2022 – 30 Jun 2023. However, I have a specific use case, where I need to build a module that uses a calendar year e.g. FY23: 1 Jan 2022 – 31 Dec 2022. Is there a way to resolve this use case? Based on current research, I would need to create a fake time…
-
export Anaplan data decimals precision to PowerBI
Hi Anaplan Community, I am trying to export data from Anaplan into Power BI using the Anaplan Connector. I manage to get my values into PBI, however, I miss the decimals precision which I see in Anaplan. Example: in Anaplan my number format is set to show 3 decimal places, so 594.450 (US notation), five hundred ninety four…
-
Replace a nested If that has many if's
So i have a nested if statement that checks the status of a shipment. "cancelled" or "storage" first using boolean, the progresses through a series of dates to see which have been added, finally defaulting to "At Origin" if it has not left yet. Multiple IF's are not ideal, but I can't see how I get round this one. Even if…
-
Is there a way where I can update a line item if the value is blank else do nothing ?
-
Dynamic List
I have two list: Target Center and Table Type: When a user selects target center I would like only the centers that are in the table type that is selected. For example if table type "FTE" is selected then Target Center list should be only "Board of Directors, Office of the President, and Legal" and if table type "SqFt" is…
-
From Native Versions to Fake Version List?
Hi All, As it is not possible to SUM down native versions is there a simple mechanism to take data out of versions and restate it within a fake version list? I know this is achievable via a series of nested IF THEN ELSE queries but this approach is not sustainable as it needs to be updated every time a new native version…
-
Consolidating recursive modules
Hi I have 2 Lists and 3 modules as shown below. I want to build module 4 (details below) in the most efficient manner. Seeking ideas. Thanks in advance List: Employee ssL0Employee ssL1Employee ssL2Employee ssL3Employee Employee 1 Y Employee 2 Y Employee 3 Y Employee 4 Y Employee 5 Y Employee 6 Y Employee 7 Y Employee 8 Y…
-
Line Priority Allocation
Hi, I am having issues using the optimizer for production allocation. The model is for capacity planning. Problem statement Need to allocate the SKU demand to compatible factory lines based on the following logic. Each SKU has a production priority and a factory line priority. If the production priority for a SKU is 1…
-
How to convert text name in upper case to lower case
I have a list with employee names all in upper case. E.g. DANIEL SMITH How can I convert these names in Anaplan to Daniel Smith (upper case on the first letter then lower case for the remaining)
-
How to solve this error "Name cannot be mapped for a numbered list"
I am trying to load a csv file containing above properties in to a numbered list. and it throws me an error saying name cannot be named, but in the above case i didnt map the Name, I just mapped the properties. Can anyone please help me where am I going wrong?