Post reply

Updating cube with data from datasource

  • May 7, 2003 at 5:05 am

    #105964

    if you have a cube, and the data source is set up to a SQL Server 2000 table, and you add a line to the table, that change will not be updated and displayed in the cube unless you reprocess the cube?

    Is this correct?

    Are you then able to set something up that when the data source data is changed that the cube will update to include the change in the SQL Table?

    Any help, please.

    Edited by - ryanm on 05/08/2003 01:32:21 AM

  • May 7, 2003 at 8:20 am

    #456400

    Hey Ryan,

    You are correct...if you add records to the table(s) underlying the cube, those records will not be reflected in the cube until you either perform an incremental or a full update on the cube. I am not sure how a cube refresh would work in this scenario.

    There may be articles on this site that will show you how to execute a dts package from within a stored procedure. I know there is sample code for this on http://www.sqldts.com. You could capture the insertion of new data in your Insert Into... query by checking the @@Rowcount value after the insert query runs then use that value to determine whether or not your sproc runs the excecute dts package sproc. Your dts package would include an Analysis Services task that would perform either an incremental update (if you can get the unique identifier of the inserted data row(s)) or a full cube update.

    hth,

    Michael

    Michael Weiss


    Michael Weiss

  • May 7, 2003 at 8:41 am

    #456403

    Thanks Michael,

    I appreciate your help.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply