March 29, 2009 at 12:45 pm
Hello,
Iam new to SSAS 2005/2008. Iam working on 2008 version of SSAS. I have a scenario. Data from a table needs to be loaded into respective dimension tables and one fact table followed by clearing all data (of the previous execution) in the cube and reloading fresh data. I am ready with the cube design and all dimension tables and fact table. Its a simple star schema. If you could pls suggest how to go about with this!!!!!!!!!!
March 29, 2009 at 4:04 pm
March 30, 2009 at 3:43 pm
If you simply want to reload the existing cube run a full process on the database to reload the entire thing or you can do a full process on the dimensions and then the specific cube if you have more than one cube.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 10, 2009 at 1:30 pm
Got it done with SQL statements that load the fact and dimension tables then process the cube. All in SSIS package.
Thanks guys!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply