This discussion is archived
6 Replies Latest reply: Feb 11, 2013 11:43 AM by GlennS_3 RSS

ASO Partial Clear

user8927833 Newbie
Currently Being Moderated
we have a aggregated ASO cube and i want to do partial clear and then load data to the same intersection. This cube is aggregated cube.

i Have below questions regarding it


partial clear will take more time?
do i need to clear all aggregation and then perform the partial clear?
How to aggregate only the updated intersection if i can do partial clear on aggregated cube and then load data to it?
What is the use of Query Hints in ASO aggregation?
  • 1. Re: ASO Partial Clear
    Prabhas Journeyer
    Currently Being Moderated
    This link may help you...

    http://oraclebizint.wordpress.com/2009/03/05/hyperion-essbase-11110-clearing-regions-in-aso-cubes-using-mdx-and-maxl-part-1/
  • 2. Re: ASO Partial Clear
    sunil k Journeyer
    Currently Being Moderated
    Partial clear takes more time than full clear.

    You do not have to clear agg views but Partial Clear takes time if aggregate views are present.

    You can try slices but I am not sure if it works that nicely performance wise specially when agg views are present.

    Query hints are used for building aggregate views.

    You can refer to dbag to get more idea about loading to slices and Query hints.

    Regards,
    Sunil
  • 3. Re: ASO Partial Clear
    user8927833 Newbie
    Currently Being Moderated
    Thanks for the reply..

    my main motive is to reload same refreshed data for same intersection with less downtime..

    if i will clear aggregation then do partial clear followed by data load and aggregation then it will be take more time(not sure ..i am assuming it as aggregation take more time)


    just want to clear data set with aggregated view and load data to that intersection and aggregate that slice...


    looking for best approach or if any one as actually did tried that

    Thanks
  • 4. Re: ASO Partial Clear
    GlennS_3 Oracle ACE Director
    Currently Being Moderated
    you should note the syntax you were givven was for a logical clear wich is faster but creates slices. If you do a physical clear it will take longer
  • 5. Re: ASO Partial Clear
    user8927833 Newbie
    Currently Being Moderated
    Lets say Jan->FY12->Actual->ITdepartment needs to cleared and reloaded with new set of data in cube which has aggregated view.

    i am thinking this can be done without clearing aggregation but i dont know if i can reaggregate the new slice of data


    step 1) physical partial clear without clearing aggregation
    step 2) reload new refresh data for same intersection with aggregation
    step 3) how to reaggregate the new slice of data?


    is it the right approach ?
    will this be faster than clearing aggregation and then loading the slice of data?
  • 6. Re: ASO Partial Clear
    GlennS_3 Oracle ACE Director
    Currently Being Moderated
    If you do not clear the aggregations, the slice will get its own aggregations mimicing the aggregations on the main cube

Legend

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