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.