Forum Discussion

Richard_Shillinglaw's avatar
Richard_Shillinglaw
Copper Contributor
May 07, 2021

SSAS Cache Warming/RLS

I have taken over some SSAS cubes, making some developments, adding Row Level Security. After the cubes have been processed each night, when using Excel to search the cube, Excel returns a "connecting to data source" in the status bar after 1 character is added to the search e.g. F(lag). I have implemented the OLAPQueryLog table and it is returning a reference to the RLS in the MSOLAP_ObjectPath field and the combination of 0/1s in the Dataset. This occurs against either all cubes or the cube that was processed, if I've processed one during the day

 

To avoid this "connecting to data source", I need to implement cache warming after processing has finished? The 0/1s are the MDX I need to run, but I haven't been able to work out how to turn those 0/1s into MDX. I've looked at SQL Profiler and what that returns, and what seems a small number of articles on the subject but this hasn't helped.

 

Can anyone advise, with step by step examples for my benefit?

 

Thanks

 

 

Richard.

No RepliesBe the first to reply

Resources