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.