-
Filter based on User dimension
Hi I am having 2 dropdown selections "Start Date & End Date" which is with respect to default users dimension. There is a date formatted line item (Load Date) in target module which is dimensioned by a list "A" and not having users list as dimension. Now, the target module needs to be filtered out based on the logic (Load…
-
How can I change the name of the list as a text?
I have a list name 'Group' and it has "city", "state", and "country" as value. Then, I have other lists named 'City', 'State', and 'Country' and those list contains its own items. City = New York, LA, Chicago, Dallas...... State = NY, CA, IL, TX....... Country = US, CA, ...... In a module, I have three line items named…
-
LIS INDENTION
Hi Team, Is there a way to fix the LIS Indention of those identified as Parents, other than unticking the parent button in the source module, please? Please see screenshot for the sample indention being mentioned. Appreciate your assistance. Thank you, Elaine
-
Data Discrepancy between Data Hub & Spoke Model
Hi Guys, For an import from Data Hub to my spoke model for a module - I am seeing additional entries in my spoke model for a certain month that do not exist in the data hub. I looked at the history to see if someone manually added the entries in the spoke model but that doesnt seem to be the case. Neither of the models or…
-
Build Dynamic YTD/YTG with Non-Native Time
Hey Builders, I'm working on a project which requests a report that requires non-native time due to needing YTD/YTG at the end of each year to track variance on last year's YTD vs current year's YTD. The period to reference in the YTD is to dynamically change as the Current Period is updated within every year, regardless…
-
Level 1 Model Building Exam - Model Building Activity 5
I got myself in a little bit of a pickle when I created the in SYS08 Employee Details. I created the Role item as a text format. Now realizing it needs to be a list item format. It will not let me change or delete the item. I am stuck in a pickle. Help! Any guidance you an provide is much appreciated. Thanks! Mike
-
Copy data from one month of Current Year to all the months of Future Year
Hi , i would like to copy the data from sept 2020 to jan2021 -dec,2021 for Budget version and take May,2021 data and copy to Jun,2021 -Dec, 2021 for forecast version. Any suggestions to achieve this.Sept 2020 Jan 2021.....March 2021....Dec 2021 20 -- 20 20 20 Thanks Sri Nitya
-
Import script as stopped working, but the manual import runs succesfully
I am importing data from Snowflake and successfully saving the csv file, this has worked for about 2 years They changed their column headers, I then downloaded the new format csv, and created a new import using this file, which works 100% However, when i add the new import to the script it crashes at the import stage…
-
How can I get PY Sales Revenue from Sales Revenue in a module without a time dimension?
I have a module without time dimension but there is a column with the sales revenue date. My formula for PY_ar date is just the ar_date minus 365. Can I leverage these two to get PY Sales revenue for a particular territory? I tried the following and got errors: Sales_Revenue[lookup: territory_id, lookup: PY ar_date] Sales…
-
Having a editable and non-editable grid
We have this list which has a Questions as a property This is the module where changes have to be made using DCA. First line item (Questions to ask) should pull the questions from the list DCA has been applied according to which first five cells have the read access and the next four have write access I want to have the…
-
Difference from hours
Hi All, How do i find from the start time and end time the difference and further convert to mins? Example : my start time is : 18.40 and end time is : 17.05 Another Ex : Start Time is :12.00 and end time is : 02.00 Thanks
-
Clubbing multiple excel exports
Hello All, We have a requirement from user where they want to club multiple excel exports from Anaplan as a single file (meaning each sheet in excel having the respective export from Anaplan). Is this possible? IF yes, can you suggest how to proceed. Report 1 -> Sheet1 of excel Report 2 -> Sheet2 of (of same excel)..and so…
-
5 Years Planning
Hi there, I am trying to build this kind of P&L view : where 2023 FY figures come from another module where the line items are planned on a monthly basis. The idea is to forecast every year after 2023 based on Y-1. Meaning that the revenues of FY 2024 will be = Revenue FY 2023 * x%, Revenues of 2025 = Revenue FY 2024 * x%…
-
What is the difference between Time sum and Moving SUm
Hi I want to know what is the difference between Time sum and moving sum. Scenarios that we use them individually
-
How will sync option work in dashboards
I would like to understand how will the sync option help to activate all the Grids with one selector
-
Level 2 Model Building: Conclusion DATA02 SKU Volumes
Hey folks, I'm on Level 2 Model Building: Conclusion, and it says: "Import Final Demand Forecast into DAT02 Module In the Financial Planning & Analysis model: Import the Demand data into the DATA02 SKU Volumes module. * The results should have none ignored and 0 errors. Update Actions and Processes: * Rename the import:…
-
Error Message: Mapping have a common LIST format
Hi all, I am trying to assign the territory to the accounts that matches the attributes. However, because I am using the same list for my Product L2 and Product L3, I am getting the error below. I understand that this is due to my line item format be: build a product list hierarchy is not an option because I want the…
-
Export ignoring show/hide
Hi guys, I have created a saved view in one of my modules. my module has 4 dimensions + line items. Time, Cost center, GL account and version. My saved view has selected a few versions, cost centers and GL accounts. I use tabular single column for my export as I want all dimensions to be columns and only a single line item…
-
how to check of the month of a month formatted line item
Hi I have a month formatted line item in one module, how can I get a boolean line item to check off in that month in another module? In my SYS65, I have a month formatted line item "MOB to time" For example the value is Mar 24. How can I get Mar 24 to checkoff in my C86 module? (both are dimensioned by credit and turn)…
-
Bulk Copy Action
I am aware that I can add Bulk Copy as an action via Action in Model Settings Bar however to set this up I have to select the target and source version/list member. Is there any way to set this up so that I can select the target and/or source when the action is being run?
-
Selective Access and picklists
Hi, I have set up selective access on a list and limited the user to one list item. This works as from the context selector at the top of the page, they can only see the one list item I gave them write access to. But when they access a user based picklist for that list item, they can see all the list items. They are able…
-
Production capacity calculation
Hi, Good Day All. Does anyone know how to build the calculation modules that calculate a Factory’s production capacity. This is the formula I am using: Production capacity = number of machines*number of working hours*number of working days*number of shifts*line efficiency. Usually, they work five days a week (From Monday…
-
Is a live model to model connection still happening?
A few years ago, there was a "live" model to model connection on the Anaplan roadmap. Has there been any update on whether models would speak to each other continuously versus through an import?
-
How to sync manual data to from one module to another
Hello All, I am trying to bring the data from an existing module A to another module B ( have created the same column in the module B with correct dimension), but I am seeing no data in that module Going forward i want this column to be up to date with the live data in Module A Is creating an action my only way? Approach…
-
Need to set a particular list item as default in Dashboard, other than ALL
Hello Everyone, I have Flat List by name: ABC, This list i have selected in a Module:1. This Module1 i have published on classic DB. The list contains list items 1,2,3 and ALL. Requirement: I want to set 1 as default list item on DB, whenever any user opens this DB they should see the default as 1 as the list item. But in…
-
UX User-Filter & Context Selector Issue
Hi, I have a user filter that was working correctly before (and still working in some old UX pages) but it seems that after the last Anaplan update a bug had happened and I am not able to apply the filter anymore. In my UX page shown below, the user-dimensioned selector (Blue box) filters the context on the page (green…
-
Summing values for a year
Hi, I have a line item which is equal to (Monthly income)/(yearly income). How can I reference the yearly income (or calculate it), I have the monthly income as input. Thanks
-
How to vary the calculation used for each version for a single line item?
I have a large model that is used to generate a business forecast. Each time we need to generate a new forecast or scenario, a new version is added so that the inputs can be changed and the outputs then compared to previous versions. However, sometimes the calculations themselves need to change to reflect our evolving…
-
Production Data - Top level Can be Changed?
I have a scenario as follows: I have a List named "Product L1" which has been marked as production data. While I understand that structural changes can still be made to a list that has been marked as production data, I have noticed that the top level, which cannot be changed if the list has been marked as production data,…
-
Formula to calculate based certain items in a dimension
I am having trouble to create a formula to calculate something on selective items in a dimension. Simplified example is as follow. 1. Products A, B, C and D defined in a list 2. Clients 1, 2, 3 and 4 in another list 3. Production costs calculated at the client level based on the products (any and all) they have Now I need…