-
Is there an easy way to clear prior inputs with a roll forward?
When we roll forward our FP&A model to a new year at the start of our budget cycle all the prior year inputs are kept. We have to manually go into each section of the model and clear all the inputs/uncheck booleans etc. This is very time consuming. Does anyone else have the same issue and is there an easy way for us to…
-
Which of these two options has the best performance?
Hi Guys! I have a module that consolidates values in a list called Supplier L5 (this list has 5 levels), let's call it CONSOL01. The modules that feed CONSOL01 are not dimensioned by Supplier L5, so when consolidating I need to assign a dimension. I'm currently doing it this way: Value[SUM: SYS01 - LookUp Module.Supplier…
-
Error Pulling Specific Product Data Across Modules
Please advice on this! I have Module 1 with the dimensions: Product_XYZ (Numbered list), Location The line item in this module is 'Order Quantity' and the Product_XYZ subset list contains Products A, B, and C. I also have Module 2 with these dimensions: Product_LMN (Numbered list), Location The line item in this module is…
-
Using Polaris in Reporting models
Hi, We've been advised to use Polaris for one of our reporting models (90% sparcity). The model is mainly used to aggregate data across 4 dimensions and time, using SUM as the summary method. One of our dimensions is a 12-levels hierarchy, and I just saw in anaplan learning that Polaris might not be effective in reducing…
-
Editable Line Item at Top Level of Hierarchy
Hi, I have an example module dimensioned by: Columns = time/months, Rows = line items, Pages = Products. This products list isn't built as a hierarchy but has multiple different levels of parents/child. I have it set so that the module pulls in sales on the lowest child level and have the line items summing to roll up to…
-
Get the Duplicate records based on different combination checks in a module
I have a scenario where I need to highlight the duplicate records based on different line items combination check. Below is the use case. I have a module with District and Territory combination code list. Then I have line items to populate Territory, District, Country and Category names. I want now to create a Check…
-
Could we add model size change to comparison report?
The obvious current solution is to make note of the model size before and after syncing changes, but adding change to model size in the comparison report would just be a great QoL change, especially for model performance reporting purposes.
-
Level 2 Sprint 3 3.3.5.2A Beginning Inventory, Forecast Demand, and Suggested Order Line Items
Hi.. for some reason I don't think Beginning Inventory is pullin the correct data from DAT01.Beginning Inventory. Same case for Forecast Demand line item. I used the formula "IF NOT Override? THEN Initial Demand Forecast ELSE Override Forecast" for Final Forecast line item in DEM03 Demand Forecast( and "DEM03 Demand…
-
Level 2 Sprint 3 3.3.5.2A Beginning Inventory, Forecast Demand, and Suggested Order Line Items
Hi….I don't see any values in the Forecast Demand. I am struck. Help!! Thanks.
-
How to Add Child members(More than one member in one go) based on User input
I am working on a use case where basis on input from user, child list will have required number of list items. For E.g.- User Input =3, 3 entries are created under L2. I am able to add multiple rows in one go using below logic. But stuck in a scenario, where we have existing list member already added & want to add more…
-
How can I allow users to override a filter and display selected accounts in an input module?
I have a module where users need to input data for accounts. Currently, I hide accounts without any values using a filter. However, I want to allow users to select specific accounts in a side module, and this selection should override the filter for those accounts, making them appear in the input module for data entry.…
-
How to calculate project end month & project start month based on data.
Hi, I am trying to calculate last month & start month basis on DAT01 TestData. For E.g.: For list Item A: Start Month should be Nov 24 & end month as last data value. Source Module:DAT01 TestData Target Module: CAL01 Start & End Month
-
I need to change Model Calendar Time settings 4 4 5 Structure.
Currently the system is allowing me to use Last Sunday near to the end of month. Ideally my requirement is I need third Sunday / Second Last Sunday near to the end of the month. For Ex: 28th Oct 2024 to 26th Oct 2025, is Current fiscal year which came because of the the end of fiscal year selection - Last Sunday near to…
-
What is the typical Workspace size for a medium size Anaplan project not complex and not simple?
-
Issue on getting the values from the source module : Month (TIME) to Quarter (LIST) Concern
Hi, I am facing an issue in relation to getting the sales per quarter.Target Module : Account (List), Product (List), Quarter (List), Year (List) Source Module : Account (List), Product (List), Month (Time) I keep on getting zero value whenever I tried to lookup the sales from the source Module. I have already mapped the…
-
NEED HELP ON LOOKUP
Hello, Good Day! Need some professional help on how I can replicate the weeknum function from Excel to Anaplan. I am relatively new to this platform. I have a module where I should be able to get the Peak Week from a date value (Peak Date). » So it's like the Weeknum function using the 'Peak Date Mid" value. I have another…
-
Pivot
Hello team, I have uploaded 2 SS, in first as you can see in pivot that there is no line item in pivot table but it is containing data and in second screenshot in blueprint view you can clearly see line item is present. Suggest me how can see line item in pivot table
-
Pivot Table
-
Custom Calendars
Is there a way to create custom calendars in Anaplan? Our customers work out of different calendars and we would like to be able to enter and report data according to each specific customer's calendar, while at the same time being able to enter and report data according to our corporate calendar. Any advice or links to…
-
Using Anaplan to filter on Anaplan
I'm really new to Anaplan so apologies if this is a simple one. My hierarchy is set up as follows Department Hiring Role Hiring Role_Site Forecasting Task I want to be able to filter on site & department separately. However, I can't add site into the hierarchy as the same site can exist for multiple departments. I've added…