-
Is it best practice to split budgeting, forecasting, and reporting into 3 separate models?
I am working on a project where budgeting, forecasting and reporting all happen in 3 separate models (and 3 separate apps) within a workspace. Is this best practice? each model is rather large 50-100 modules, so from a visibility standpoint this makes sense. However, it causes a significant amount of re-work and imports to…
-
"Which target items to clear prior to import?" doesn't work as i expect
Hi Guys! I would like to clear all data from my module before a new data import is done. This is important for my process as there is not always data for all combinations. But I'm not having any success with it. I created a module to exemplify my error: "TEST01 Clear Data" has data for all combinations (1 a 10) My import…
-
How can I build this filter without using 4 billion cells!
My end users want to see transaction level data being pulled into our model with the ability to filter by account code and time. The filter is currently set up as displayed in the attachment, but takes up way too much space in the model. Any ideas on how I can build a smaller filter for this to continue working? Thanks…
-
Data Hub Imports without manual uploads, how?
In the Data Hub training it says 'DO NOT' use manual uploads to the data hub. Use ETL Tools. We receive data in flat files (csv) for many of our data sources, and have no 'link' to their systems. So how do I utilise my data hub it if am not supposed to manually upload these files?
-
Level 2(Conclusion) Currency Conversion
Hi all… I've been trying to import to Country Currency list but getting errors. Please find my mapping screenshot… I've used Name or Code when mapping because each currency has both country name and code. Thanks in advance!!
-
Distributing values based on Mapping.
Hi All, I have a module MOD1 which is dimensioned by Product Group, Customer and Time and has line item Cost. I have another module MOD2 which is dimensioned by Product, Customer and Time and has line item Sales. I have a mapping between Product Group and Product Lists. Every Product Group has multiple products. I want to…
-
How to retrieve Current user
Hi everyone. i read some of the post here regarding retrieving current user but unfortunately cant find the answer. Since retrieving current user without user list dimension is not allowed, how can i transfer the current user from module with user list dimension to a module without user list dimension. thank you.
-
Configure Edit restrictions for a UX page
Hi All, I have a UX page where users manually enter data into all fields. I have a requirement to configure this page in such a way that users can edit it only during the first 10 days and the last 5 days of each month. How can I implement this lock in Anaplan? Please advice! Thank you in advance.
-
Level 2 Sprint 3 3.3.5.2A Beginning Inventory, Forecast Demand, and Suggested Order Line Items
Hi, I am getting the wrong values for "Beginning Inventory" and "Forecast Demand" in INV01. I have used the following formulas.. Beginning Inventory: IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory Forecast Demand: 'DEM03…
-
API or Integration to fetch module's history
Hello, Is there a way to fetch module's Change data capture or History through an API?
-
Level 2 Sprint 3 3.5.5 Activity: Create Distribution Center Summary UX Page
Hi…I've been trying to create the "Product SKU by Distribution Center" grid in 3.5.5 activityI(L2 Sprint 3). I don't understand why it's showing all the values unlike the expected results. I have applied show/hide for the levels required. Please help. Thanks in advance!! Expected o/p
-
File format vs Anaplan
Hi, I want to ask for help with why while importing, it keeps on reading my code like this xxxxx+12? Attached photos for reference: File: (.csv format) Anaplan: Thanks,
-
Is there a way to create a module using the calendar year?
My fiscal year starts from September 25 for example, if I need a module to reflect the calendar year as a time scale instead of fiscal, how can I do it?
-
Capture Current Date Time Stamp in a cell
Hello, I want to capture Current Date Time Stamp in a cell when there is a change in line item? Is it possible with out implementing something too fancy?
-
Lesson 7 ADO
I am currently experiencing difficulties with the ADO activity. Despite following all the steps, the Boolean formula intended to populate the "Active?" field for employees is not functioning as expected. I have already attempted changing the summary to a formula, but it still does not work. Do you have any suggestions on…
-
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…