Solved

SSAS - Question on partitioning non time series dimensions

Posted on 2013-01-07
3
284 Views
Last Modified: 2016-02-18
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
0
Comment
Question by:keplan
  • 2
3 Comments
 
LVL 12

Expert Comment

by:sachitjain
Comment Utility
You could do partitioning if 1.2 million records are not all relevant for your cubes.
0
 

Author Comment

by:keplan
Comment Utility
All required
0
 
LVL 12

Accepted Solution

by:
sachitjain earned 500 total points
Comment Utility
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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now