This discussion is archived
5 Replies Latest reply: Jul 8, 2010 8:08 AM by 751552 RSS

restructuring process

751552 Explorer
Currently Being Moderated
Hi Gurus,

What happens in the background when we build the dimension with out dropping an existing partition!!
In my case..

the restructuring after the last built file got built , its taking lot of time to restructure!!
not lot of time its restructuring for ever!!

I know that otl and ddb is related!!


how exactly they are related!!
what all the process are taking place?

In may case its a transparent partition between BSO and ASO!!
BSO got builded with out any issue
while coming to the ASO the above is happening!!

Any suggestions?


Thanks,
Jeeth

Edited by: Jithendra on Jun 16, 2010 3:57 PM
  • 1. Re: restructuring process
    Srinivas Bobbala Expert
    Currently Being Moderated
    Once you logout all the sessions and disable the connections, Partition will not create any issues for the restructuring.
    In the BSO cube if you are building sparse dimensions, only .otl and .ind files will be restructured.
    It is very fast compared to dense restructure.(.otl+.ind+.pag files will be restructured).

    There is no dense/sparse concept in the ASO applications.
    Any dimension building will push the cube to full restructure.
    .otl and entire .dat file will be redefined.
    Obviously it takes time based on the .dat file size.
  • 2. Re: restructuring process
    751552 Explorer
    Currently Being Moderated
    Hi Srinivas,

    Thanks for your input!!
    We are still in Essbase 7.1.3!
    any dimension build in ASO will cause a full restructure and will clear all the data!
    so I think it is independent on .dat file!!

    let me explain my issue in detail!!

    lets say I'm building the XYZ application!!
    I'm copying the .OTL from other application to XYZ application and on that I'm building the dimentions!!
    that was our devlopment architecture!!

    when I'm doing the same with BSO every thing went good!!
    when I did the same thing with ASO the restructuring process is taking forever. (restructuring is being done after building every build file, the problem is only after the bilding the last file in the script).

    After dropping the partitions are running again every thing is going good!!

    any suggestions??


    Thanks,
    Jeeth
  • 3. Re: restructuring process
    751552 Explorer
    Currently Being Moderated
    Hi,

    any input? any suggestions?


    Thanks,
    Jeeth
  • 4. Re: restructuring process
    Srinivas Bobbala Expert
    Currently Being Moderated
    Then. No issues. Define the batch flow like this:
    1) Drop the partition
    2) BSO cube build
    3) ASO Cube build
    4) Recreate the partition.
  • 5. Re: restructuring process
    751552 Explorer
    Currently Being Moderated
    Hi Srinivas,

    I know abt that!!
    just want to know how it is affecting restructuring!!

    Thanks,
    Jeeth

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points