It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×12,008
×1,235
×403
×145
×5

question asked: Oct 25 '13, 12:03 p.m.
question was seen: 6,478 times
last updated: Apr 09 '14, 7:37 a.m.

Related questions

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

0
Francesco Chiossi (5.7k●1●11●19) | 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

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Francesco Chiossi (5.7k●1●11●19) | 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.


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.