-
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…
-
I am facing issue in receiving data from Informatica cloud
Hi , I am receiving the below error .please let me know the reason. I am not getting data into target module.I am not understanding what is the issue
-
Designed behaviour of updates in "Start Date and Time(UTC)" of a process.
What is the designed behaviour of updates in "Start Date and Time(UTC)" of a process i.e. whether it is updated at the beginning of the first action of the process or at the end of the last action of the process?
-
Waterfall charts with multiple totals
Hi, I am wanting to create a waterfall chart with multiple line items across financial years. This is also dimensioned by forecast version, where the closing balance of a given year depends on the version, as well as the forecast range. I have created a dynamic hierarchical list as per the below screenshot to get around…
-
L2 - Spring 2 - 2.3.8.4 Create DEM02 Volume Growth Rates by Week module
Add a formula to the Growth % line item to convert the DEM01 Volume Growth Rates.Growth % (monthly) value to weeks For this task, I have applied the formula WEEKVALUE('DEM01 Volume Growth Rates'.Growth %) but this formula seems to be incorrect. The values in the weekly columns are 0 instead of monthly value/no of weeks in…
-
How can I Reference a Line Item from a module with time dimension in a module without time dimension
Mod 1 - System Module Line item (Subsidary view) applies to Time(Year) Mod 2 - Reporting Module (Timeless) How to refer Mod 1 line item in Mod 2?