The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Conditional Formatting on IsRowVisible Row Header Format
Has anyone used conditional formatting with the IsRowVisible row header format property before? I am developing a cube view form that is driven by an account input parameter where the user selects a...
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:
Alternatively you can look at this thread
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.
ChrisLoran
OneStream Employee
OneStream EmployeeHello 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:
Alternatively you can look at this thread
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.
Hi Chris,
I have the same question as Cathy_T. Now I understand why the conditional color formatting was working but not the "IsRowVisible = False" condition. I'm curious to know what other alternatives I have, but unfortunately, I'm unable to see the ones you posted as I'm denied access. This is a situation I haven't encountered before. Thank you in advance. ~ LC