1 Reply Latest reply: Feb 29, 2012 3:29 PM by AdamMartin RSS

    During a cube build how do I use an IN list for dimension hierarchy?

    AdamMartin
      I have a "using" clause that I use with DBMS_CUBE.BUILD that looks something like this:
      'OWNER.CUBE_NAME' || q'[ USING(FOR OWNER.TIME_D WHERE OWNER.TIME_D.DIM_KEY IS DESCENDANT OR SELF OF ']' ||
          p_period || q'[' WITHIN OWNER.TIME_D.TIME_H BUILD(CLEAR, LOAD, SOLVE))]';
      Thanks David for coming up with this code in the first place. I am passing in a value for p_period like 201202. I know I can build several partitions in parallel, so how can I specify the equivalent of an IN list of time periods, like (201104, 201112, 201201, 201202) ?