Skip to Content
author's profile photo
Former Member

plan cube

Hello SDN,

should index be created/deleted for a plan cube?

If so, when performing a copy function writing into this cube (cube A to cube B) or writing within itself, is there a need to also drop index before this running planning function and then re-generating it after?

Also, should the request be closed before writing new or the request closed after writing the data into the cube? I believe there is no need to do so. please confirm.

thanks & regards

Mirella

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 01:14 AM

    Hi,

    I think for copying function you need not run the drop index... this step is usually required when entire data in the cube is wiped out and you want to ensure the integrity of the cube for usage later.

    I think you need to close the request on a daily/weekly basis as it can only take 50,000 records.

    Closing the open request in transaction cube

    My 2-cents worth.

    Hope this helps.

    Cheers,

    Gimmo

    Add comment
    10|10000 characters needed characters exceeded