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.



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