Linking Views in PAW

Post Reply
User avatar
20 Ton Squirrel
Posts: 71
Joined: Tue Jul 14, 2020 9:53 pm
OLAP Product: TM1
Version: Planning Analytics with Watson
Excel Version: Office 365
Location: Houston, TX

Linking Views in PAW

Post by 20 Ton Squirrel »

Let's say I have two views of the same cube on a single sheet, one shows Shipments and the other shows Shipment Share. If I change the filter in one, I'd have to change the filter in the other also. Terribly inconvenient for a lazy analyst doing data entry.

Is it possible to link the filters between these two views? Some kind of trigger or MDX madness to incorporate?
War teaches us geography, getting old teaches us biology.
luizg2019
Posts: 41
Joined: Thu Sep 12, 2019 11:02 pm
OLAP Product: TM1 - PAX-PAW-Perspectiv-Arc
Version: PA 2.0.9 - PAW 2.0.73
Excel Version: office 2016

Re: Linking Views in PAW

Post by luizg2019 »

Go into edit mode, select the first cube view, click on "Properties" (the last icon in the edit bar that pops up when you go into edit mode), go to "Synchronize" and select "Syncrhonize dimensions" + all dimensions that you want to sync. Don't forget to do that for the other view.

Also if you click on properties without selecting any object, you can change the syncrhonization scope from only 'this' sheet to the entire book.
User avatar
20 Ton Squirrel
Posts: 71
Joined: Tue Jul 14, 2020 9:53 pm
OLAP Product: TM1
Version: Planning Analytics with Watson
Excel Version: Office 365
Location: Houston, TX

Re: Linking Views in PAW

Post by 20 Ton Squirrel »

BRILLIANT. Thank you!
War teaches us geography, getting old teaches us biology.
Post Reply