how to clear and reload a cube

  • 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!!!!!!!!!!

  • Create a 'data source'

    then create a 'data source view'.

    This can be done in SSBIS or SSMS

    www.sql-library.com[/url]

  • 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

  • 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