Hi, I am facing a problem that there is a Cognos report in which a column out of, say, 10 can only be viewed by report administrator. The other 9 columns can be viewed by all common users. Could anyone tell me any hint of how to do so? It seems the package, data and object securities taught in Framework Manager student guide are not possible solutions...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Column level security in report
- Thread starter volcano
- Start date
You should be able to conditionally hide the column when the user isn't an administrator using a macro. For example, we use this...
'Admin-group-name' in (#CSVIdentityNameList()#)
...as a filter in a dummy query which counts records in a small arbitrary table and then conditionally hide "admin only" things based on the data item in that query having a >0 value.
'Admin-group-name' in (#CSVIdentityNameList()#)
...as a filter in a dummy query which counts records in a small arbitrary table and then conditionally hide "admin only" things based on the data item in that query having a >0 value.
DataGirl67
Technical User
Here's a secondary question to this...
Can we determine the column names by the person looking at the report? We have a situation where depending on the customer (end user) we would want the columns to have certain names.
Can we determine the column names by the person looking at the report? We have a situation where depending on the customer (end user) we would want the columns to have certain names.
- Status
Similar threads
- Locked
- Question