-
2.3.9.2 Update and Run Process 9. Import Data from Hub Item 9.1
I am trying to import into the supply chain module for 9.1 for DATA03 Historic volumes. It seems my mapping is not correct but not sure which step it occured. Any idea on how to fix this ? Attachment has full details.
-
Export data to .csv file from a module with page selector and filter is not working
Hi, Exporting data to CSV file from a module with page selector and filter is exporting incorrect results: Sample Data as per my example below, Anaplan is applying the filter (amount<>0) to the first month March 23 only. Zero's are getting exported for the intersections data available in first month (filter is not applied…
-
Comparing the Total for each element of a list, not the total value of the list
Hello everybody, I've been struggling with a recent dev especially on a specific case, which i hope some you would enlighten me ^^ To Make it short, I have two list : G3 Retail (belong to a hierarchy (G2 & G1) G3 Destination Store (which is a parallel list of the G3 Retail list & is having a top level) Here is a picture…
-
Cell count vs. clarity/auditability
I have a calculation module where I'm debating between having more line items so that a future model builder can more clearly understand the math I'm doing vs. having fewer line items to save on cell count. For example, I have line items, Item 1 and Item 2, that pull a value from a data module. Both Item 1 and Item 2 have…
-
How to use one of the column as a drop down or context selector in DAshboard
-
I wanted to subtract two coloumns between a pivot in order to calculate the variance is it possible
-
unable to click from model search
Not sure if anyone has raised this bug already, but when I do a model search in the new modeling experience (which is now the default setting), I get the results but can not click into any of them. Weirdly I noticed that it doesn't open the list/module/db etc. if you click on the name (text area) but works if you click…
-
how to calculate variance by subtracting actual and forecast budget ?
-
Size.csv missing - unbale to import the data
Hi, I'm not able to import the Size.csv file into workspace due to the fact that I can't find it into the training or into the Anaplan. Error message displayed: he uploaded file is no longer available; please upload the file again. Can you please let me know where I should find the files? Thank you, Ana Maria
-
I/m unable to export the custom view from the new UX
Hello Team, I have 1 custom view Grid in the new UX and i'm trying to export the view but it is throwing me an error saying what would be the reasons for the below error, could you please help Thanks in Advance
-
Variance module using item subsets
Good morning team. I have a labour model that I am looking to add a variance module to and need some assistance understanding my options. As we have a number of different versions, using native versions for the variance is inefficient and will cause the model to grow much larger than required. The planning module currently…
-
Different formats for one line item
Hi all, A user can input data in the following way: Event type Event Date of the event Is there a way to define different formats for the line item "Date of the Event" on the basis of the other line item "Event Type"? As an example, when I input "Event type 1", the "Date of the event" is Time Period Format, (Type 1, Event…
-
Line Item Subset SUM
Hi there! I have growth assumptions on different cost lines in module(A) where am using a Line Item Subset for cost lines and regular line items in different years. In another module(B), I calculated the Net revenues also using Line Item Subsets and the COLLECT() formula. Now I am trying to build a third module(C) where I…
-
How to map two module data together in order to get inference from it in the third module ?
-
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
-
Importing a list from Hub into Spoke Model
Hi Experts, I have an import set for a list from data hub to my spoke model. My concern - the list items in the list on Data hub keeps changing based on the updates made in the upstream system. As an example say in Nov - I had the id ABCD1 as a list member in Data Hub and also in Spoke model when data was pulled. Now in…
-
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 we built the famous word game : Wordle!
You all must be aware of the global phenomenon of “Wordle”. The way this little and simple word game struck the world is amazing! We loved this game so much, we tried to test our beloved software, Anaplan’s, limits yet again and tried to recreate this game on it. This is how we built Wordle on Anaplan inspired from…
-
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