SSAS - Question on partitioning non time series dimensions

Hi,

I have Customer Dimension that has 1.2 millions records. my SSAS browsing performance is very poor.
how do I improve performance of browsing cube? is the partitioning right strategy?

thanks in advance
keplanAsked:
Who is Participating?
 
sachitjainConnect With a Mentor Commented:
Then could you please tell more information about tables involved in the logic, count of records in each of those tables and underlying query that is executing to generate your data?
0
 
sachitjainCommented:
You could do partitioning if 1.2 million records are not all relevant for your cubes.
0
 
keplanAuthor Commented:
All required
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.