cancel
Showing results for 
Search instead for 
Did you mean: 

Linking Dimensions extremely slows down performance

butfirstcoffee
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

SebastianBiela
Explorer
0 Kudos

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