We are using Cognos 10.1.1.
In report studio we need to display a chart series based on the user role. For example, if the user that is logged in is not a member of the Sys Admin role, then do not render Series A, however continue to render Series B and C.
We already have logic in place to get the user role, so that's not an issue. The problem is we cannot seem to find anywhere to add a conditional style to the chart series to accomplish our goal. We've messed around with putting logic directly in the query to make the values all null which removes all the points and line from the chart, but it still displays the series name in the legend. We are looking for a clean way to just drop the series from the chart.
Is there a way to do this with conditional styles? If so how? If not does anybody know how to accomplish this?