Using Polaris in Reporting models

stheapaut · 2025-01-10T10:47:25+00:00

There was an error rendering this rich post.

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 volumetry when using such lists.

Do you have any advice/feedback ?

Thank you !

Accepted answers

All comments

rob_marshall

@stq

It totally depends…Without knowing more about the 12 level hierarchy, it is difficult to tell. With that said, one of the reasons you have that 12 level hierarchy is to reduce the overall sparsity. In Polaris, you may not need to have so many levels as you would be modeling more "naturally". Also, with OnDemand Calc (ODC) in Polaris, that could definitely help "end of chain" calculations (meaning calcs for dashboards/reporting).

TristanS

@stheapaut with 90% sparsity with 4 dimensions I would highly recommend Polaris based on experience. Just curious how you managed to measure 90% sparsity though. In my case, I actually use Polaris to measure the level of sparsity lol. I'm assuming that the 4 dimensions do not have composite lists, e.g. List A is a combination of product and customer which is what you usually end up doing to manage minimise workspace consumption in Classic.

stheapaut

@TristanS @rob_marshall Thank you for your answers !

The main list is a 12 levels composit list, with no possibility to reduce it. We add items every month (1 to 10 items) that's why I'm quite unsure about using Polaris in our case.

For estimated sparsity it was measured by Anaplan directly

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…