-
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…
-
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?
-
REP03 Profit & Loss Report module
While mapping the budgeted/Forecast details from the sheet, the mapping page does not show the Forecast details at the bottom.. It only shows the Actual details....Pls suggest
-
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…
-
Time based IRR Calculation
Hi All, I've list of transactions and data is day wise. I need to calculate IRR on time basis . I want calculate IRR on day basis and at the end the summarized level IRR i.e Quarterly, Yearly. Also I want to calculate Asset wise and fund wise IRR. Can anyone have idea about how to do it? For your reference please find the…
-
Undefined_onFileChange Error
I am getting an undefined_onFileChange error while importing data from .csv file to flat file.
-
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…
-
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.
-
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?
-
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
-
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.
-
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…
-
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…
-
Variance report with absolute and percentages in a single grid
Hi all, I'm trying to create a basic variance report with LIS as a dimension of parameters and the line items to find the variance. But, the challenge here is that the LIS consists of both absolute numbers and percentages, and the client wants to see the variance in both absolute numbers and percentages respectively. Is…
-
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?
-
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?
-
what would be the formula for referring Previous year value in current year ?
For example, I want to refer the value of last year july 2022 in current month July 23. the line item is Past year revenue where I just want to show same month revenue from previous year, how could I achieve that?
-
Build a model in Anaplan with a specific hierarchy
Hi,I am currently working on building a model in Anaplan with a specific hierarchy. The hierarchy includes the following levels: Department (Level 1): Departments A, B, ..., F. Production Line (Level 2): Production lines 1, 2, ..., 8. Type of Line (Level 3): Types "S" and "W". Product (Level 4): Products list . The desired…
-
3.2.11.3 Create Saved View for Combination Chart
Can someone help me debug this, I've checked my SYS01 - Planning Period Filter Weeks. I am sure I am supposed to see the rest of my weeks and not be limited to week 8.
-
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…
-
How to Hide "Source module" in Dashboards
Hi experts, Does someone provide me with how to hide or inactivate "open source module" in dashboards? The client users are not allowed to go into source module from dashboards. In this case, I also want to conceal module name in dashboards. Regards, inoue
-
Personalized calendar : the hijri calendar
Hello, I have a question and I would greatly appreciate your assistance. I am interested in creating a Hijri calendar using Anaplan. The reason for this is that my product follows a seasonality pattern that is usually influenced by the events of the Hijri calendar, which is also known as the lunar calendar. I would like to…
-
Show Parent when no child + selection
Good morning, My lists are as follow. Parent: Mission --> Programm --> Activity --> Expense (lowest level) My objective is to put in place a filter that allows me to see the Activity items even though I have no existing Depense under the acitvity, combined with a filter where the user can select to narrow the view on one…
-
Workflow Process Approval
Hi! I just wanted to ask for assistance because my driver module wasn't able to lock the input cells on my Input module. On my input module, dimension is the child while on the driver module, dimension includes the parent and version. Thanks.
-
Versions in the new UX
So I'm creating a page in the new UX, essentially trying to display Actual and Budgeted amounts for a period. I'm intending to have the Actuals and Budgeted amounts shown as columns and the different categories as rows. I also want to show the variance between these two versions on the same column axis as the versions…
-
Unit Testing is for finding bugs, not show correctness
Architect, Builders; Having worked projects with hundreds of bugs, the natural question is how did this happen? The solution passes User Acceptance Testing means that it was adequately tested. This could be a paradigm shift for some in thinking about unit testing. Doing a quality job of it adds time to get a solution to…
-
Processing when I wrote the formula incorrectly
Hello, I would like to clarify the information because I did not find it. I understand correctly that the number of actual working imports from one model to another affects the total processing time as a result of the formula writing curve. Example: In the working model, in case of an error, processing can take 9-15…