Post reply

Cube not refreshing.

  • August 22, 2006 at 5:34 am

    #119331

    AS  and RS 2005

     

    My cube is built on views both for dimensions and the fact table.

     

    I am using reporting services and the report i have designed works fine except it does not update when i change the data. I can see the change in a select from the view so it is definitly there. It does refresh if i reprocess the cube. This happens in rolap as well as molap.

     

    Any Ideas?

    www.sql-library.com[/url]

  • August 22, 2006 at 1:53 pm

    #656218

    Jules,

    Cube is not updated automatically when underlying data changes. You do need to reporcess the cube to reflect changes

  • August 22, 2006 at 3:33 pm

    #656241

    But isnt it possible to make the cube real time as in jholap or rolap which listens for changes and updates automatlically? Is this not possible if your dimensions and fact table are views. 

    www.sql-library.com[/url]

  • August 23, 2006 at 5:21 am

    #656319

    The "cube" is simply a database. There is no automatic update process unless you create one. The cube pulls data (and metadata) from the views you defined on command and stores them in most solutions.

    You might investigate proactive caching which would create an almost real-time environment. I have read about this, but not created one.

    You could Google "real time BI" or start with a link: http://www.microsoft.com/technet/prodtechnol/sql/2005/solvngbp.mspx

     

    Good luck!

     

  • August 23, 2006 at 7:29 am

    #656354

    Hi

    If you do want to look at re-process your cube you can look at DTS and the Analysis Services Processing Task. 

     

     

    Mike 

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

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