Blog Post

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

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating