Re: Conditional Formatting on IsRowVisible Row Header Format

Hello Cathy

This post appears to be a duplicate of an incident you opened with support a few hours ago, so I need to be careful not to read on anyone's toes.
This seems to be known issue and has been logged with reference PF-2036
You may like to respond to support to ask if your customer name can be added to PF-2036.

In the meantime you will need a workaround, because the IsRowVisible property can't be set in conditional formatting (as far as I know)

One alternative solution may be keep it as one Cube View, but then have the cube view select one of two possible Row Templates at view-time, depending on the parameter selection. An example of doing this is on this thread:

https://community.onestreamsoftware.com/t5/Partner-Forum/Can-you-control-whether-a-parameter-is-visible-based-on-criteria/m-p/14714#M312

Alternatively you can look at this thread

https://community.onestreamsoftware.com/t5/Office-Hours/Is-there-a-way-to-suppress-a-row-in-a-cube-view-based-on-values/ta-p/1446

which is similar, and uses an XFBR to dynamically drive the IsVisible property of a row.

Hopefully one of these options can be adapted to work for you.