Skip to main content
I
IM_T
Newcomer
February 10, 2025

How to hide several columns in Cube View?

  • February 10, 2025
  • 2 replies
  • 0 views

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

B
BeatlesForever
Newcomer
February 10, 2025

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

J
jbrem
Contributor
February 10, 2025

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