How to connect a long list of vendors with multiple other lists

AlexGSG
Occasional Contributor

How to connect a long list of vendors with multiple other lists

Does anyone have experience creating a module with a long list of vendors (4000+) by multiple dimensions (market, department, legal entity, business unit) without breaking their module? Currently we are only able to show by one dimension but we really need it by all four, would greatly appreciate any insights on how to accomplish this.

5 REPLIES 5
KirillKuznetsov
Certified Master Anaplanner

@AlexGSG 

Do you mean pivot the dimensions?

Currently you can put up to three dimensions at each axis. But there is a small life hack how to bring more than 3.

2021-12-07_10h22_39.png

You have to drag the selected list to the small section (even to the very corner) which is marked red

2021-12-07_11h00_02.png

 

Regards, Kirill Kuznetsov
Advanced, LLC
AlexGSG
Occasional Contributor

Not exactly what I was looking for but good to know! We were able to make the data fit by splitting it into 6 subgroups. I really appreciate how quickly I got responses, thanks and have a fantastic week!

alexpavel
Certified Master Anaplanner

@AlexGSG  The alternative is to create a new list with the combination of all lists Vendor+Market+Department+Legal Entity+Business Unit and have all the dimensions defined as line-items and in rows to publish the combi list. 

 

@KirillKuznetsov : Thanks for sharing! 🙂 WOOW. 

KirillKuznetsov
Certified Master Anaplanner

@alexpavelOne small disclaimer that additional dimensions can cause possible performance issues, so keep that in mind

Regards, Kirill Kuznetsov
Advanced, LLC
alexpavel
Certified Master Anaplanner

Indeed...as everything in life, it has a price to pay 🙂