-
Why isn't Anaplan populating the data?
I am importing a file but Anaplan isnt populating the "Time Stamp" line item. Anaplan is mapping correctly and the import has no errors. What am I missing?
-
How can I go from 2 dimensions to 3 with a many to many relation?
I have a model for a company that sells books, with the following relationships: [Store - School] - many to many The books from one school can be sold ate many stores, and each store sells books from many schools (used a boolean model with dimensions store and school) [School - Subject- SKU] - many to one For each subject…
-
Snapshots
What are some reasons that a snapshot would not work completely for some schedules but it does for others?
-
Time mapping for daily data imports
I am importing data into Anaplan from a csv file. I am used to seeing the following screen for time mapping: However, this particular upload is daily data and I am seeing the following: Am I doing something wrong with the module setup or is this how imports usually look for daily data? Any advice on best practice for daily…
-
Boolean dependent selection with DCA
I am trying to find a solution to my module : I have 3 booleans Boolean A Boolean B Boolean C The Booleans B and C can be selected only if Boolean A is selected. I have used the DCA for this. The DCA is a simple one : A. The DCA is applied to B and C. My question is : when I deselect the Boolean A, the Boolean B or C that…
-
UX Filter Issue
Hi all, I'm having a hard time trying to build a UX filter. I have two lists: SS No ITC Customer SS No Product | Customer No Trading partner In particular, the SS No Product | Customer No Trading partner list is a concatenation of product and customer (yes, the same customer of SS No ITC Customer). What I want to do is to…
-
Undefined_onFileChange Error
I am getting an undefined_onFileChange error while importing data from .csv file to flat file.
-
Financial Year + Calendar Year Reporting
Hi - looking for some thoughts on how best to support financial reporting in Anaplan where there's a requirement to faciliate financial year reporting (Jul - > Jun) and calendar year reporting. By default, we use a financial year (Jul - > Jun) timescale and as far as I'm aware, there's no feature to apply a different basis…
-
Alternate Hierarchy
Apologies, fairly new to Anaplan and looking to create an alternate hierarchy to that which we currently have built When I say alternate hierarchy, I'm assuming that is what is required as we essentially want to retain the below (D1a SBU Summary) but then also have a hierarchy where would we have a couple of subtotal in…
-
Import Character Error
Hi All, I have an input module with some line items formatted as a drop down lists. My drop down list looks like this for each column When I export this as a csv file, it comes out with a "Â" character beside the "£ numbers" this way below. When I run an import using this same file to re-import to the input module. It…
-
Converting numbers to text without losing decimals
Hi! I am trying to create a reporting module with mixed line items (numbers and percentages) so I am converting the numbers to text for display purposes only. We need 1 decimal and have very small numbers eg. 0.0001 which should then be displayed as 0.0 however during the process the decimal is lost. Same issue with…
-
display name not referencing module line item
Hi Anaplan community, I've been trying to give a name to the numbered list with a formula but is not working. Can you please assist? The source module only applies to this list.
-
Scenario Planning.
Hi, I need some help in building a scenario model. For example, In the P&L report, there are 2 scenarios the user can switch. In what-if scenario 1 user can update the Unit price/Unit cost and the changes will reflect in Revenue and COGS. And in what if Scenario 2 User gets to change the volume and changes reflects in Rev…
-
Can Anaplan read data past model calendar?
I used the PERIOD function to fill in the dates for a filter I am using in Month LU line item. But Anaplan isn't reading any dates past 2025. Model calendar ends 2024, is that why?
-
How to look up prior year values
I want to lookup for previous year March values. For example if my current month is june FY24, then i want to lookup for March FY23 Values.. how can i make this lookup.
-
Converting Data within module
Hi I have data in below format. I am expecting to create a new module with below dimension and structure. Could you please suggest an efficient way for the same? Thank you
-
Copy a value (year dimension) to a Monthly dimension module and Version dimensions
Hi, We are struggling to find a way to get our "Bill Of Materials" in Anaplan. I would like to enter values for a Bill Of Material for our products with a year dimension. The consumption of the raw materials is valid for the whole year. Furthermore the Bill of Material is valid for all Custom Versions: Below is the idea…
-
How to access the latest value for an item in an archival list?
Hi All, I have an archival list where after each month's data upload into anaplan the old months entries gets dumped into. And now for 1 requirement I have to pull one of the item from the list having last months value. i.e. the value just before the monthly upload. The Item that I am trying to pull has text format. Also…
-
Scenario Planning.
I'm looking for scenario planning model building. Can anyone point me to a learning tutorial?
-
Zero in number formatted line item in beginning
How to have a number formatted line item starting with zeros? Eg. it should have a value like 0124 or 0001324?