Macro logic for aggregated level

[Former Member]

Hello Experts,

Currently we are working on SCM 5.0 V

I`ll explian my requirement. See, i have 3 Key figures, say X, Y & Z.

Logic is very simple.. X = Y+Z

But i dont want show any calculation at aggregated level. I mean key figure X will show blank at aggregated level & when we will go at detail level, then macro should be work as per logic.

Can anybody tell me this logic in macro...

Thanks in Advance!!!!!!!!!

Sujay

[Former Member]

Hi Sujay,

It is possible to hide the aggregated cell at details level using function ROW_VISIBLE() but as far as I know it is not possible to blank out the total row.

[Former Member]

Hi Sujay,

Please check macro :PLOB_DATA_VISIBLE()

PLOB_DATA_VISIBLE( X; 'planning object'...'planning object n' ) sets the visibility of the specified planning object(s). You use this function if you are working with drill-down in the Details (all) view. If X =1 the planning objects are displayed. If X=0 the planning objects are hidden. Use functions ACT_PLOB, MARKED_PLOB, or KEYFS_PLOB to specify the planning objects.

http://help.sap.com/saphelp_scm50/helpdata/en/1d/310eb3d0ee11d4b2e40050da385632/content.htm

Also check Calculate Objects at a Specific Level setting at macro step ( ADVM)

"If you set this indicator the macro is only effective on the level that

you specify in the field to the right.

In macros the level is defined by the current drill-down situation. This

means in interactive planning that when you enter the planning book by

making a selection, this level is at first the detail level, although

perhaps only one characterictic has had a value assigned. If you then

drill-down on characteristic A, this is level 1, and this level becomes

the detail level, the entry level is now the aggregate level (AGG

LEVEL). If you subsequently drill-down on a further characteristic B,

this is level 2 and becomes the detail level.

In batch mode the drill-down situation is controlled by the macro

functions DRILL_DOWN() and DRILL_UP().

Manish