Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BPC NW 10: hide columns dynamically

hi bpc experts:

I have a situation where I need to show in column axis: all base level members of entity,category (REAL and the one from the context) and base level members of year (time dimension), it works fine but I need to hide the columns based in the category, for example: for category = M03 (which means that january,february and march are already closed), in version REAL I need to hide from 2014.04 until 2014.12 and for M03 I need to hide from 2014.01 until 2014.03.

As you can see in the image Report 1 is the default layout and Report 2 is how it is supposed to be. 

I ve seen I can use the "excluded members" option from the report editor, but I need this to be dynamically, may be using the funcion EPMSupress using something like EPMSuppress("000",FALSE,"AR,REAL,2014.04") but I m shown this error : Members of Dimension CATEGORY can't be used to suppress on this axis as there are not from the outer dimension of the axis.

Regards

mah

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question