Linking Dimensions extremely slows down performance

[butfirstcoffee]

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.

Regards
Jessica

[SebastianBiela]

Hello Jessica,

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.

Best

Sebastian