Post reply

Scheduled MOLAP in settings

  • August 23, 2011 at 9:56 am

    #145967

    Hi All,

    I have a cube and set to scheduled MOLAP every 24hrs..Every partition shows cube is processed successfully for every 24hrs but I dont see the incremental data while browsing the cube..Follwoing are the setting I have set.

    Schedued MOLAP,

    Proactive Cashing on

    Update the cache periadically checked

    rebuild interval --1 days

    Please let me know,is there nything am missing..

    Thanks,

    rajun

  • August 26, 2011 at 7:11 am

    #1373744

    saprajun (8/23/2011)

    Hi All,

    I have a cube and set to scheduled MOLAP every 24hrs..Every partition shows cube is processed successfully for every 24hrs but I dont see the incremental data while browsing the cube..Follwoing are the setting I have set.

    Schedued MOLAP,

    Proactive Cashing on

    Update the cache periadically checked

    rebuild interval --1 days

    Please let me know,is there nything am missing..

    Thanks,

    rajun

    When you say incremental data - do you mean when the cube is processed you don't see the additional data post -process? If this is the case, can you confirm that there is additional data?

    Also have yuo reconnected to the cube after it has been processed?

  • August 26, 2011 at 7:49 am

    #1373767

    yes..every day we get 5miliion records into my fact tabel..

  • August 26, 2011 at 7:50 am

    #1373769

    yes..i have benn checking..connection works fine..and partitions are showing they do process every day but no incremental data

  • September 2, 2011 at 4:52 am

    #1376356

    Can you please go through below posts and check if you are missing something:

    http://www.msbiconcepts.com/2010/10/implementation-of-proactive-caching-in.html

    http://www.msbiconcepts.com/2010/10/proactive-caching-sql-server-2008.html

    Please reply back if you are doing same as mentioned and still missing the data.

    Thanks,
    Amit G
    http://www.msbiconcepts.com

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

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