Macro function to capture Details (All (Filter) )

[suren_thungathurti]

Hi All,

I have looked thru the different threads on Details (All (Filter)) in the forums and I haven't found a thread which specifically addresses capturing "Details (All (Filter) )" in Interactive Demand Planning (IDP) using Macros.

I'm looking to see how to capture a condition when the user selects "Details (All (Filter))" from IDP. Considering I have 10 products and presently I have a macro which can capture if the user is in the "Details All" or at "Aggregated Level" based on which I try to show a key figure at the aggregated /Total level. However if the user selects "Details (All(Filter))" it breaks the condition and shows individual products (which it shouldn't)

I would like to know if you have any ideas around this one.

Thanks in advance.

Surender

[Former Member]

Hi ,

For viewing the data at two different condition 1- Agg. level 2- Detail level can be map as follow.

1- Aggregated Level

IF

Condition >> Agg level

operator AGG_LEVEL (' PRODUCT ') =1

Action Box Drill Down the product

operator DRILL DOWN (' PRODUCT ')

2- Detail level

IF

Condition >> Detail level

operator AGG_LEVEL (' PRODUCT ') =0

Action Box Drill Down the product

operator DRILL DOWN (' PRODUCT ')

If you can to see particular key figure should be visible when u load DATA at Detail level then

IF

Condition >> Detail level

operator AGG_LEVEL (' PRODUCT ') =0

Operator " One more object for check"

ROW :- "name of the key figure"

operator ROW_VISIBLE(1)

END IF .

I think it will help you to create the macro .

Regards,

MJ