SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Increasing or Decreasing Sampling Size in SSAS Data Source View Data Explorer

Recently, I have begun my quest of mastering SSAS. I realize that it may take time and I am more than willing to put in the time to achieve this monumental task. J At any rate, as a network bandwidth conscientious guy that I am, I wanted to decrease the sampling size returned (from 5,000 to 100) when I explored data from within a data source view while creating a cube. To that end, I looked around the screen a little bit in my BIDS environment and there it was. In the top right corner of the Explore Data screen. It looks like a hand pointing to a properties sheet. Click it and modify your sample count accordingly. Figure 1 below shows you an example of this.

Figure 1: Data Exploration Options

Data Exploration Options 

Until next time, “keep your ear to the grindstone” – Good Will Hunting



Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant – Pragmatic Works Consulting

Email: bmcdonald@pragmaticworks.com | Blog: BI Developer Network

Convert with DTS xChange  | Develop with BI xPress  | Process with TaskFactory | Document with BI Documenter


No comments.

Leave a Comment

Please register or log in to leave a comment.