Hi, is it possible to hide 2 columns in a Cube View? I need them for calculation only, but hide from the report. If I set format IsColumnVisible to False or CVMathOnly for one column, it works. If I set it to two columns, I get no data on third data at all, while it should show data.
You can calculate via Dynamic Member instead of CVMath. To do so, you need to create a member with FormulaType setting to DynamicCalc.
Hiding columns can impact your CV math. The work around that I was told is to put those "hidden" columns at the end and format them as transparent. The data will still be there and usable in your CV but visually will not be displayed.
