Post reply

How to Update the new records cube processing option is ProcessFull

  • September 24, 2010 at 7:19 am

    #142855

    Hi All,

    I am not able get the new inserted records not processing after running OLAP cube..

    I have keep it option is ProcessFull for my OLAP cube.

    Manully run the cube even though i am not able to get the new recoreds which is there in database

    I have create SSIS Package. I have execute this package.

    I have written some vb.net code for calling cubes.. first time i am getting all the data from databse.

    Database level i have create new records. this time i am again calliing the SSIS package.

    this time i am not able to get the new records which i have inserted newly.

    //For Calling Cube i am using this code

    For Each oCube In oDB.Cubes

    oCube.Process(Microsoft.AnalysisServices.ProcessType.ProcessFull)

    Next

    //For Dimensions

    For Each oDim In oDB.Dimensions

    oDim.Process(Microsoft.AnalysisServices.ProcessType.ProcessFull)

    Next

    Note: when calling this first time Dimension it is not processing,

    Please help me how to resolved this issue,

    Thanks & Regards,

    Venu

    Reagards,

    Venu

  • September 25, 2010 at 4:21 pm

    #1227404

    First you are processing the Cube and then you do a process full on the dimensions? When you process full on a dimension it forces you to rebuild the cube (data partitions)

    You should do ProcessUpdate on dimensions first, then process full on the cube

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

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