Cube Processing

  • Hi,

    I am new to SSAS.i have 1 lakhs record in cube but next day i am getting another 10k records.So i want to process only new records.For this what i need to do?

    Please reply me.Thanks in advance

    Cheer's
    Rajesh

  • rajeshpalo2003 78748 (8/20/2012)


    Hi,

    I am new to SSAS.i have 1 lakhs record in cube but next day i am getting another 10k records.So i want to process only new records.For this what i need to do?

    Please reply me.Thanks in advance

    Hi Rajesh,

    Thanks for the question. Please be aware that this is an international forum and not all readers will understand the phrase "lakhs". Its best to write the actual figure so that we're all involved. I believe that 1 lakhs is 100,000 but please correct if I am wrong!

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • Found this in SSC which discusses cube updates.

    http://www.sqlservercentral.com/blogs/jamesserra/2012/01/25/improving-cube-processing-time/

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • Thanks Robin.Again i am repeating that question with proper phrase

    i have 100,000 records in cube but next day i am getting another 10,000 records.So i want to process only new records.For this what i need to do?

    Which is the best way for cube processing?

    Cheer's

    Rajesh

    Cheer's
    Rajesh

  • Hi Rajesh,

    Open the link and read the article - it should point you in the right direction.

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • The link seems to be busted today.

  • Just checked.... the link is fine

    http://www.sqlservercentral.com/blogs/jamesserra/2012/01/25/improving-cube-processing-time/

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

Viewing 7 posts - 1 through 6 (of 6 total)

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