Skip to main content
IM_T
Newcomer
Feb 10, 2025 10:44 AM UTC

How to hide several columns in Cube View?

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.

2 replies

BeatlesForever
Feb 10, 2025 4:48 PM UTC

You can calculate via Dynamic Member instead of CVMath. To do so, you need to create a member with FormulaType setting to DynamicCalc.

jbrem
Contributor
Feb 10, 2025 9:32 PM UTC

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.

Terms & ConditionsAccessibility statement