Post reply

Report not refreshing?

  • August 22, 2006 at 5:36 am

    #170081

     

    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 23, 2006 at 11:49 am

    #656430

    Jules,

     

    In reports there is a database called reportservertempdb.

    There is a table that stores the reports with expiration date.

     

    Try this:

     

    use reportservertempdb

    go

    create trigger snapshotdata_ins on snapshotdata

    for insert

    as

    delete snapshotdata

  • August 23, 2006 at 12:21 pm

    #656434

    i dont think it is the report cach e because the report refreshes fine if i reprocess the cube . How do i get the cube to show incremental changes and not have to scedule reprocessing?

    www.sql-library.com[/url]

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

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