There are some reports,we have to provide security to that
reports like the hr manager should have access to hr
department reports only and the accountant should have
access to accounts reports where as the CEO can have access
to all the reports. How to deal with this situation using
Cognos?
Answers were Sorted based on User's Feedback
Answer / cognos123
Firstly your application should have security set up in
place. eg: u must have LDAP server set up.
Having said that once u have users and roles have been
defined in security server u will create a macro in FM
with account.defaultuserName() session parameter.
Above defined macro will work as explicit filter when user
logs into cognos portal and based on given permissions
he/she will be able to see only his/her pertaining data
when ever then run report.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chiru
In framework Manager... we can give Security ...
1) Data level security
2) Object level security
3) Package level Security
Here Data Level Security means we can apply security to
Data item in a Table like ...
Another one is Object level Security.. i.e we can apply
security to Objects like... regions like India, England,
USA..
the particular region is Accessed by particular region
only...
For Example: India region can be accessed by India users
Only
Package Level Security:
This Security can Apply to Particular package only...
i.e Particular package can access only
| Is This Answer Correct ? | 0 Yes | 1 No |
what is slowly growing dimension??
What is the report studio?
What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?
--------------Diff b/w ODS and OLAP?
Can i apply drill through on chart in report studio?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
Why Star Schema is de-normalized? Please explain in detail probably with some examples.
what is your project workflow and your role in the project?
How can we find out cardinality between two tables?
What are all the components of Report Studio?
1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.
which difficult you faced in your project?