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 take…
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 h…
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 c…
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…
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 …
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 …
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 o…
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 appl…
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,
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?
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?
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 expect…
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/un…
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…
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, …
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 o…
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/chil…
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 l…
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 f…