In planning book.we need paricular key figure in change mode in drilldown

[Former Member]

Hi all,

In planning book.we need paricular key figure in change mode always in drilldown.

Presently,for paricular customers in drilldown

showing in display and change mode.

We want always in change mode for that keyfigure.

We tried in Planning book design mode, it does not work our requirement.

We tried with mavros also.

Pls. advice us

Dev

[Former Member]

Hi ,

Already we are using one macro for this,

but at customer group level when we want to give INPUTS manually we are able to give INPUTS for some products which are in change mode , some products are in displaymode we want to change it to change mode, so we can give inuts manually, how we can change it

Pls advise

Dev

[srinivas_krishnamoorthy]

You should be able to do this by the following:

1. Keep the key figure as editable (which is input/output) in the data view design by right clicking on the key figure, selecting the option

2. COnstruct a startup macro that uses the macro function ROW_INPUT(0) -> which is make the key figure uneditable

3. Construct a drill-down macro that uses the macro function ROW_INPUT(1)--> which is make the key figure editable

[Former Member]

Hi ,

Already we are using one macro for this,

but at customer group level when we want to give INPUTS manually we are able to give INPUTS for some products which are in change mode , some products are in displaymode we want to change it to change mode, so we can give inuts manually, how we can change it

Pls advise

Dev

[Former Member]

Hi Dev,

If I understand your issue, you want to have a keyfigure in display at agrgegate level and have it as edit at a particular drill down level.

This is easily accomplished using a macro.

You can use the function ROW_INPUT ().

ROW_INPUT( X ) sets the input status of a row. If X = 1, the status of the cell is set to ready-for-input. If X = 0, the status of the cell is set to read-only.

Set the key figure to 0 at the aggregate level and have a if condition saying if the AGG_LEVEL() is 0 ( detail level), then set the key figure to 1.

[Former Member]

Hi ,

Already we are using one macro for this,

but at customer group level when we want to give INPUTS manually we are able to give INPUTS for some products which are in change mode , some products are in displaymode we want to change it to change mode, so we can give inuts manually, how we can change it

Pls advise

Dev