Search code examples
business-intelligencecognos

Filter report based on the role in Cognos BI

I have a report in Cognos BI with a field where stored username. A customer wanted to filter data report based on the user who runs this report. I used filter [report].[user_name]=#sq($account.defaultName)# and it works. But now the customer wants to show all data in the report for one specific role in Cognos BI. Is there any way how can I do that?

Solution

  • This is just a boolean expression. Adjust it to do what you want:

    (
[user_name]=#sq($account.defaultName)#
OR
[user_name]='The user name that can see everything'
)

    Don't forget the brackets.