How to know deep all the tables on the Data Warehouse to acces by JRS?
Hello everyone!
I have a question regarding how to know all the tables on the data Ware house in Rational.
I now that we have 3 types of schemas:
- 'Stakeholders' custom attribute, represented by the attribute type of 'contributor'.
- 'Score' custom attribute, represented by the attribute type of 'enumeration', with a list of values from 1 to 10.
The purpose of this WI type would be to capture the 'score' which should be provided by stakeholders on how they think the product/solution we deliver is doing.
Then, a JRS report would calculate the average score for each of the Releases (by using OOTB 'Found In' attribute).
The problem that I have is the following:
On the JRS server, I can not find the table that contain 'Stakeholders' custom attribute, .
Additional info about our development environment:
JRS 5.0.2 including DCC component
About the Jazz Reporting Service
Version: 5.0.2
Build ID: JRS_5.0.2-I20141028-2014
CCM & JTS are 5.0.2
Many thanks in advance,
Ichi
I have a question regarding how to know all the tables on the data Ware house in Rational.
I now that we have 3 types of schemas:
- RIODS
-
RICALM
- RIDW
- 'Stakeholders' custom attribute, represented by the attribute type of 'contributor'.
- 'Score' custom attribute, represented by the attribute type of 'enumeration', with a list of values from 1 to 10.
The purpose of this WI type would be to capture the 'score' which should be provided by stakeholders on how they think the product/solution we deliver is doing.
Then, a JRS report would calculate the average score for each of the Releases (by using OOTB 'Found In' attribute).
The problem that I have is the following:
On the JRS server, I can not find the table that contain 'Stakeholders' custom attribute, .
Additional info about our development environment:
JRS 5.0.2 including DCC component
About the Jazz Reporting Service
Version: 5.0.2
Build ID: JRS_5.0.2-I20141028-2014
CCM & JTS are 5.0.2
Many thanks in advance,
Ichi
3 answers
Hi Iciar,
You can look at the data dictionary https://jazz.net/help-dev/clm/index.jsp?re=1&topic=/com.ibm.rational.reporting.overview.doc/topics/c_reference_datadictionary.html&scope=null or try http://www.ibm.com/support/knowledgecenter/SSRL5J_1.1.1/com.ibm.rational.raer.models.doc/topics/ModelReport111/content/_PFxaMRkjEeCvlPIv3KTKYA_root.html?lang=en for more info on the data model.
Hi Ichi,
Please take a look at JRS v5.0.2 not filtering custom attributes of a custom Work Item type. It seems the discussion in that thread is applicable to your question
Please take a look at JRS v5.0.2 not filtering custom attributes of a custom Work Item type. It seems the discussion in that thread is applicable to your question