Need ideas: Waste of Space to Accommodate Simple Report - Dynamic totaling, User Dim
Seeking some brainstorming ideas!
The situation: We have a full final P&L module where one single line item is 17 gigabytes (and has to be, don't bother questioning this please - it is due to us doing ultra granular reporting, in Polaris, no combo-list is not on the table).
We need to create a second line that is IDENTICAL except that simply 2 P&L GL Accounts in the Account list get zeroed out - that is their “Non GAAP.”
Ultra simple to build and calculate that! But complete waste of another 17 Gigabytes for almost an identical line.
IF Anaplan let users filter stuff and then dynamically changed the parent levels based on the visual filter, this would be easy! But that isn’t an option yet (right? is this roadmapped?) - so the only option I can think of is to use a filter that changes the values - but then you need User Dimension! Otherwise 50 users might be checking and unchecking the filter box.
And User Dimension…takes us right back to waste of size.
I know it’s a weird one and likely no solution to find - but curious if anyone has any wild ideas.
(One that we did in the past was settle for a User dimension, but make users click a button to add themselves to a subset that resets every hour, so it only eats storage while ppl are using it. But this is worst case user experience and frankly, embarrassing to have to do.)