TM1 Forum

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?

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.

BRILLIANT. Thank you!