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?
Linking Views in PAW
- 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
War teaches us geography, getting old teaches us biology.
-
- 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
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.
Also if you click on properties without selecting any object, you can change the syncrhonization scope from only 'this' sheet to the entire book.
- 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
BRILLIANT. Thank you!
War teaches us geography, getting old teaches us biology.