Data warehouse schema description
I am trying to write reports for RTC2.0. Have looked at the data warehouse schema.
Unfortunately the schema basically talks about different snapshots, the 'tables' therein and the fields of the table. There is no write up or description on what the fields mean, or how everything fits together. This makes writing reports a frustrating exercise and takes much longer than should be the case. Is there some better description of the schema somewhere? Many thanks. |
3 answers
The following WIKI topic describes the schema.
https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20 |
The following WIKI topic describes the schema. Thanks for the link. I have seen this, that's why the original post. Take 'enumerations' for example, it is described in the schema as Logical Name Type Description Project_Area_Itemid UUID The UUID of the project area in which the enumeration is defined. Enumeration_Id String The id of the enumeration Literal_Id String The id of an enumeration entry Literal_Name String The human-readable name of an enumeration entry Now, there are 2 X_Id fields, how are they used. This is just one of many examples. Just wondering if there is a more 'user friendly' description of how the fields are used and how they are referenced. Many thanks. |
On 9/15/2009 10:38 AM, ltsao wrote:
rjaouaniwrote: In the specific case you mention, when you define work item enumerations in the process configuration tab, you give the enumeration an id - that is reflected in Enumeration_Id. Also, when defining an enumeration, each literal in the enumeration gets an id and a human-readable name. Those are reflected in Literal_Id and Literal_Name, respectively. Hope this helps. james RTC Reports Team Lead |
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.