Skip to Content
avatar image
Former Member

Urgent help needed on Macros

Hi APO Gurus...

I want to know how to use Drill_Up and Drill_ Down macros in batch jobs. they work beautifully in interactive mode, but when processed in batch jobs they drill up only for the particular CVC's at the aggregated level specified in the job. We are selecting all the characteristics in the aggregation level while creating the job. Then we want to drill up on particular characteristic. We are using a collective macro with first macto for drill up and second macro for calculations at the aggregated level. It works fine in interactive mode but drill_up doesnt seem to work in batch jobs.

Help needed

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 19, 2007 at 04:24 PM

    see the notes 433166.

    Did you assing this macro for batch job or not?

    In the activity you have to assign the MAcro for batch job

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 22, 2007 at 09:01 AM

    Hi,

    You should not be using DRILL_UP and DRILL_DOWN functions in background jobs. Whatever processing you need to do after DRILL_UP should be a separate macro and that should be executed in background at the desired aggregation level (set for the job).

    There is no point in using a collective macro with a DRILL_DOWN, processing and DRILL_UP steps in background job.

    Thanks,

    Somnath

    Add comment
    10|10000 characters needed characters exceeded