Dear SAC pros,
I have a question regarding Link Dimensions - in my story I am using more than one DSP model - in some charts I need to be able to filter across models with Storyfilters/Pagefilters. Currently 2 dimensions (ID) are linked via "Link Dimensions" between Model A and Model B.
Though, what I get is a massive crash in performance.
12 seconds without existing model links:
Amost doubled with model linking:
Any suggestions? Code also welcome.
linked dimensions in SAC are usually a performance killer. If possible, you should try to join your models in DSP as this is pushing the join into the database. Currently it is not possible to merge two analytic models, so you would have to make this join in your Fact View/Analytical Dataset.