September 18, 2013 at 3:51 am
I am a new one in SSAS. I have cube of almost 800MB size without any partition and aggregation defined. User want data of almost all measures and at transaction level. When user browse data at DateKey level then It stuck for a long time and did not return any result. I have implemented partitions and Aggregations but result is same. In my scenario user want auditing and want 80% of cube data at row levels.
Should I go for Caching? Please suggest me any solution.
September 18, 2013 at 4:34 am
If the user almost always wants data at the transaction level, why build a cube in the first place? Cubes are designed to give fast aggregation results, but they are slow for detail rows. Maybe SSAS Tabular might be a better option? (if that's possible)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 18, 2013 at 4:46 am
Is there any way to bring whole cube in memory.
September 18, 2013 at 5:12 am
In SSAS Tabular yes, because that's an entire in-memory solution.
I'm not sure you can get the entire SSAS cube into cache with SSAS multidimensional:
http://richardlees.blogspot.be/2011/12/why-doesnt-ssas-cache-entire-cube.html
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2013 at 6:22 am
Is Tabular model is supported in SSAS 2008?
September 19, 2013 at 6:45 am
No, it was introduced in SQL Server 2012.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply