-
Daily Date Format
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
-
Module Building 6.8.1
I can't seem to get my module to match what the learning center is showing. Any idea what I could be missing in dimensionality etc.? I've looked back through the previous lesson and can't find any clues. Learning center shows: And mine looks like this: What am I missing in the setup below? I made several back-to-back and…
-
Model Building 7.2.3 Mapping Issue
Hi All, I have poked around through the forum looking for an answer on this issue, and most of the threads end with no solution. I have had no problems mapping the other stuff so far, no idea what is going on here. Yes I am mapping by code, instead of Employee name. Yes I have edited the start and end date, tried yyyymmdd…
-
Dynamic Export Reporting
Hi All, I want to address an query related to exports, In Output model, which is read access for all users & roles.user want to have dynamic export depending on user selection of multiple regions. So for selected regions , they will be able to see the data only for selected regions. Thanks,
-
1.5.2 activity: import data into beginning inventory
Kindly assist me to load data into the model.
-
Which is better for Polaris' performance? SUM or LOOKUP
Hi folks, I was testing which function performs better in Polaris to pull data using a 1:1 mapping. Let me first give you the context: I have a DAT module where many KPI metrics are structured as a Flat List with only one line item (Amount) to store data. Then, I have a CALC module whose line items are also KPI metrics.…
-
Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
-
Workarounds for coercing timescales in Polaris?
Hi, all. Polaris formulas don't coerce timescales like classic does and I'm looking for a workaround. I want to build a UX time selector like I have in my classic models: The way it works in classic is like this: The "Filter" line item looks at the month formatted, quarter formatted, and year formatted boolean line items…
-
Function Movingsum
I try a movingsum function but i get always the next message This is the function that i try And the location that i try to aggregate Why do i get this message the module has a day scale?
-
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…
-
Working with Opening / Closing Balances and 'fake time'
We have an Anaplan model that uses "Fake Time" - that is a time dimension specifically constructed for the application and not one found native to Anaplan. For this reason the Opening / Closing Balance summaries don't work. We would like to be able to show the opening and closing balance at the beginning end of each weekly…
-
L3 Sprint 1 : Sales Planning
Hello everyone, I created a new model to display the Sales Planning using the PY Revenue from DAT02 Revenue and the PY Actual Revenue from TAR02 Account Review, applying the appropriate LOOKUPs and using SYS99 to retrieve the % of Account Sales Target. However, when I compare the results of my build with the results shown…
-
Quarter to Monthly
I have 3 modules. First module has list with yearly values. second module has line items that convert the yearly data to quarterly. I want to convert quarterly data monthly in third module. The quarterly module has override capabilities so if user select set annual to 0, then the total for that year will be 0. If user…
-
YTG, YTD Summary in Polaris
Hi All, Wanted to quickly check if the YTG, YTD summaries are not enabled for Polaris model yet unlike the Classic model. Thank you, Harshitha
-
Cell count is too large error
Not seeing existing posts about this error. How to resolve this?
-
Why the return value is False?
Hi experts: I put all the values into the formula, I think it should return TRUE, not FALSE, but why it return me FALSE? Maybe I missed something here ? Thank you for the help!
-
All of my DATA01 is cleared after 2019, is there any way I can fix this?
All of my DATA01 is cleared after 2019, is there any way I can fix this?
-
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
-
Sorting in Combined Grids
Hi Team, I have been trying to apply a sort based on a column in one of the combined grids and seems like the option is disabled. Does anyone has any idea on this? Regards, Aakash Sachdeva
-
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…