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:

Your answer

Register or to post your answer.