Skip to Content
Author's profile photo Guru Charan

Turn on[/off] input/output mode + DP macro

Yeah, it’s better to have this here rather than explaining it every time someone asks about how to make a key-figure or a column (non-)editable in DP by a macro.

The below macros will make it possible

  1. to make columns non-editable [COL_INPUT] in the period defined in the step;
  2. to make key-figure [CELL_INPUT] non-editable [for the period defined in the step, of course];

Parameter 0 is false and 1 is true. So, if it is said COL_INPUT( 0 ), it means that inputting the column is false – meaning, not possible. So, COL_INPUT( 0 ) is turning a column in a non-edit mode while the parameter 1 is edit mode. Same applied to CELL_INPUT function while it is only for a key-figure, i.e. at row level and not the column level.


Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Solutions to specific problems should be given like this....Not using high level english language and referring to the standard stuff available online.

      Being able to explain in correctly, in short, exhibits the level of understanding and clarity of thoughts.

      Thanks for this solution this helped me today, take pride.