Hiding rows selectively in DP using macros

[Former Member]

Hi:

I want to selectively hide the rows of selected CVCs based on a key figure. Example below.

Characteristics and values:

Project: p1, p2, SUPPL

Product Family: series2, series3

Supply: plant1, plant2

THe following are the CVCs

Project,Product Family,plant

p1,series2,dummy

p2,series2,dummy

SUPPL,series2,plant1

SUPPL,series3,plant2

SUPPL,series2,plant2

SUPPL,series3,plant2

Suppose that I have the following key figures

demand

supply

In the planning table, I have selected show "Project" in the shuffler and loaded the above data. In the header, I have selected "details all" for the characteristic Project. The requirement is as follows:

For the demand KF, I want to hide rows thta have a Project value as "SUPPL" (these correspond to the supply CVCs)

For the supply KF, I want to show only those rows that have the Project value as "SUPPL" and hide rows that will have the actual project values (such as p1)

Is this conceptually doable through DP Macros?

Thanks.

Satish

[former_member220487]

Hi ,

Can you please elaborate, what is the exact business requirement. What exactly they are trying to achieve.

For the demand KF, I want to hide rows thta have a Project value as "SUPPL" (these correspond to the supply CVCs)

For the supply KF, I want to show only those rows that have the Project value as "SUPPL" and hide rows that will have the actual project values (such as p1)

With hide rows, do you mean

no data in Demand KF when Project value = SUPPL

data in Supply KF when Project value = SUPPL

Am I right ?

Can you use Plant (as you have Dummy plant whne Project value != SUPPL

Regards,

Nawanit

Edited by: Nawanit Rathi on Feb 10, 2011 5:52 AM