It's all about the answers!

Ask a question

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


Francesco Chiossi (5.7k1819) | asked Oct 25 '13, 12:03 p.m.
edited Oct 25 '13, 12:07 p.m.
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?


One answer



permanent link
Francesco Chiossi (5.7k1819) | answered Oct 25 '13, 12:04 p.m.
edited Apr 09 '14, 7:37 a.m.
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

Your answer


Register or to post your answer.