FM CLM Reporting Dimensions metamodel question
Hello,
I've run Data Manager CLM jobs and it seems that datawarehouse is filled with data. I'm particular interesting in requests related data so I've inspected F_REQUEST_METRICS table.
I moved to Framework Manager and test related elements in Physical metadata and Dimensions folders. Physical metadata elements work fine but when I moved from F_REQUEST_METRICS (Physical metadata) to "Request Metrics" in Dimensions folder I've discovered that test doesn't return any data. I've checked underlying query. I'm confused by this JOIN condition:
where
((1 = 0) or (((1 = 1) and (F_REQUEST_METRICS.PROJECT_ID = VW_PROJECT_RESOURCE_LOOKUP4.PROJECT_ID)) and(VW_PROJECT_RESOURCE_LOOKUP4.RESOURCE_NAME = 'Anonymous') ))
I tried to execute the query without this highlighted statement. It works.
The question is if this statement is for the debug purpose and could be removed or this statement is correct but I still have incorrect data in datawarehouse so no data is returned by the query?
Thanks in advance
I've run Data Manager CLM jobs and it seems that datawarehouse is filled with data. I'm particular interesting in requests related data so I've inspected F_REQUEST_METRICS table.
I moved to Framework Manager and test related elements in Physical metadata and Dimensions folders. Physical metadata elements work fine but when I moved from F_REQUEST_METRICS (Physical metadata) to "Request Metrics" in Dimensions folder I've discovered that test doesn't return any data. I've checked underlying query. I'm confused by this JOIN condition:
where
((1 = 0) or (((1 = 1) and (F_REQUEST_METRICS.PROJECT_ID = VW_PROJECT_RESOURCE_LOOKUP4.PROJECT_ID)) and
I tried to execute the query without this highlighted statement. It works.
The question is if this statement is for the debug purpose and could be removed or this statement is correct but I still have incorrect data in datawarehouse so no data is returned by the query?
Thanks in advance
One answer
This check you discovered has to do with the security implementation in
the FM Model. Anonymous access is not allowed by default. You must make
the JTS the authentication provider and you the user must be a member of
the projects that you want to report on or the project must be public.
See Step 7 and 8 here:
http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/topic/com.ibm.rational.raer.integration.doc/topics/t_integrate_clm.html
We also posted papers that explain how to include legacy apps such as
ReqPro and CQ into this security model:
https://jazz.net/library/article/687
https://jazz.net/library/article/688
Hope this helps,
Peter.
the FM Model. Anonymous access is not allowed by default. You must make
the JTS the authentication provider and you the user must be a member of
the projects that you want to report on or the project must be public.
See Step 7 and 8 here:
http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/topic/com.ibm.rational.raer.integration.doc/topics/t_integrate_clm.html
We also posted papers that explain how to include legacy apps such as
ReqPro and CQ into this security model:
https://jazz.net/library/article/687
https://jazz.net/library/article/688
Hope this helps,
Peter.