Post reply

how to load the upcoming data in Cubes in SSAS

  • July 28, 2008 at 5:18 am

    #191629

    I have designed already cubes in SSAS....for this cubes i need to update the day to day transaction data...how can i do this....

    for example: In my cube(Revenue cube)data is upto date of july 16th...now i need to update the cube(i;e load the fresh data)upto date of july 26th.how can i do this ...is there any automatically process so that it updates the data in cube every day...plz let me know

  • July 28, 2008 at 5:22 am

    #849082

    hi,

    yopu can use the proactive caching feature of SSAS.By using that feature we can set the cube updation property.Check the Sql Server help online for how to implement the proactive caching concept.All the best mate..

    Regards

    vijay

  • July 29, 2008 at 12:44 am

    #849574

    hi

    You can use Integration Services Analysis Services Data Flow Items, which will allow you to process Dimension and Partition with ProcessAdd option, you can Schedule this package to run periodically to process your CUBE.

  • July 29, 2008 at 11:26 pm

    #850260

    hi...Can u plz explain me in detail....

  • July 30, 2008 at 5:19 am

    #850369

    hi

    You will need to create an SSIS package which will use Analysis Services processing task where you can add what objects to process , set processing and error handling options. you can schedule execution of this package.

    for details check this :http://msdn.microsoft.com/en-us/library/ms141779.aspx

Viewing 5 posts - 1 through 4 (of 4 total)

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