-
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?
-
Link 2 data sets
Hi We have a module with multiple relationships, like manager to employee relationship and employee to office relationship. The end goal is to have 1 line item with all 3 (manager, employee and office) in 1 line item. We created 2 modules from the parent module as below Module Mgr-Emp Rel List "Rel" Rel 1 Mgr1 Emp1 Rel 2…
-
Can someone help explain what is the difference between a fake version list and native lists?
-
Chart labels for multiple line item/version combination
I want to set up a line chart that shows 2 line items and 2 versions (4 total lines): The chart works fine but the labels at the bottom only show the line items, not the versions: Is there a way to show both the line items and the versions in the table?
-
Restrict access to edit existing line items but allow to write new entries (DCA?)
Hello! My company tracks hundreds of different rates. Our procurement team uses an Anaplan upload to import these rates into the system. An example of what they upload could be something along the lines of Vendor Name, City, Rate. The procurement team then has a UX page where they can update the rate if it changes for any…