Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Career advice for the IT professional
Browse by Tags · View All
SQLServerPedia Syndication 194
SQL Server 60
SSAS 40
#SQL SERVER 19
SSIS 18
2012/Denali 17
Career 17
Denali 14
SQL Server 2012 13
MDS/MDM 12

Archive · View All
June 2011 20
August 2011 15
July 2011 15
March 2012 15
October 2011 14
September 2011 14
May 2011 13
November 2011 12
February 2012 11
April 2012 10

James Serra's Blog

SSAS development quick tip

Apr 9 2012 12:00AM by James Serra   

When creating a new cube in SSAS, you are frequently making changes that cause the whole cube to reprocess when you use the “Deploy” option (such as structure changes or aggregation design changes).  This means a lot of sitting around and waiting for the cube to process if you have a large fact table.  What I usually do to avoid this problem is to go to the Data Source View that the cube is using, right-click the fact table, choose “Replace Table With New Named Query” and modify the resulting SQL SELECT statement to use a “TOP 1000? or create a WHERE clause that filters by a particular day or month.

This works great, and processing becomes very quick as I build out the cube.  Then when the cube is far enough along that I want to check it out with all the data, I revert back to the unmodified SELECT SQL statement.  A word of warning: a few times I created a new named query and filtered the results, only to forget about the filter and I winded up wasting my time trying to figure out why my cube is not pulling in all the data.  So don’t make the mistake I made!


Republished from James Serra's Blog [70 clicks].  Read the original version here [2 clicks].

James Serra
35 · 5% · 1664
3
 
0
Lifesaver
 
0
Refreshed
 
 
0
Incorrect



Submit

1  Comments  

  • Thanks for this tip!

    commented on Apr 11 2012 12:38AM
    Paras Doshi
    16 · 10% · 3265

Your Comment


Sign Up or Login to post a comment.

"SSAS development quick tip" rated 5 out of 5 by 3 readers
SSAS development quick tip , 5.0 out of 5 based on 3 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]