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 |
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 |
|
Thanks Lidija, but the problem that we have (Vicky and me work together) that we don't have a model to know where we need to look for.
I need to know the available tables in each schema. I could not find that. Some on Jazz or Rational can help us? Thanks agaiN! |