Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Howto find if the CLM Data Model used is with security or not in Report Studio

How do I find if the Reporting Data Model (DW) loaded in Insight/RRDI is with or without the security feature enabled, without re-importing it?


0 votes



One answer

Permanent link
data model security

To find out if the data model with or without security is used you can perform this test:
a) Open Report Studio
b) Create a simple report with just for example Request ID from Operational Data Store > Request Area > Request
c) From the Report Studio menu select Tools > Show Generated SQL/MDX
d) Compare the resulting Navite SQL with the screenshot attached for the condition marked in red around line 4:
- where 1 = 1 : indicates that the model WITH security is used
- where 0 = 1 : indicates that the model WITHOUT security is used


For the differences between the 2 data models see:
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m6/topic/com.ibm.rational.rrdi.admin.doc/topics/t_admin_switch_data_models.html

1 vote

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019
× 403

Question asked: Oct 25 '13, 12:03 p.m.

Question was seen: 6,542 times

Last updated: Apr 09 '14, 7:37 a.m.

Confirmation Cancel Confirm