-
Count within many to many relationship
Hi I am trying to solve below problem and was seeking help for an optimal way. I have a module which has a many to many relationship between Employees and Offices. I want a count of all unique employees within 1 office. For example in the below scenario, I have 3 offices with employees working from that office (1 employee…
-
Unable to see Docusign in usa1 Anaplan instance.
I'm using the same email address to login to both au1 and us1 Anaplan instances but I only see DocuSign in the dropdown option for au1 (refer to screenshots below). I have access to only one tenant in the au1 instances but have several tenants on the us1 instance. Is there a reason why? I also happen to be a tenant admin…
-
Is there any other method of enabling summarize function in anaplan?
Trying to figure out how to enable the summarize function. As the module does not have a time dimension changing it on blueprint view is not possible. I'm trying not to use the sum formula either. Can someone help me out and suggest any other way?
-
why are the values not rolling up to parent by default in attached photo
-
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