Need help with better approach

SaiArpithaRavi

Hi, I am facing issue with the below senario. If someone can help me out with what is the best possible approach

I have hierarchy with lists from L1 to L6 levels
and a flat list D with list items from D1 to D5

Current setup: There are several hundreds of modules with combination of flat list D with one of the hierarchy list(L1 to L6)

Requirement: We need to have a capability to increase of decrease the flat list item(1 to 20)

If we increase from D5 to D6 the model size increases by 20% which is not feasible

Our approach: We tried to create parallel hierarchy at each level combining flat list and hierarchy list

for example:combining the codes of L2 & D and creating new list as child of L2

We are doing this at all the levels which requires a lot of change and effort at lineitem,modules,actions,saved views actions & dashboards. Could you please suggest if we have a better approach?

seb_mcmillan

Like you say re-engineering the model from 2 lists to a concatenated list will require effort but this should be a one off exercise. You will also need to build functionality in anaplan to maintain and maybe decode the new list.

I'd question if you need to do at all levels as this will also consume a fair bit of space, I generally just add the concat dimension at the leaf level, then if you need to see specific combinations, you can build a lookup modules that maps concat list and a multidimensional reporting module using sum

The other potential option is Polaris which could remove the need to combine lists but would potentially need some model redesign