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

One answer


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