Forum Discussion
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.