It's all about the answers!

Ask a question

Data warehouse schema description


Lewis Tsao (2174458) | asked Sep 14 '09, 4:00 p.m.
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



permanent link
Rafik Jaouani (5.0k16) | answered Sep 14 '09, 4:57 p.m.
JAZZ DEVELOPER
The following WIKI topic describes the schema.

https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20

permanent link
Lewis Tsao (2174458) | answered Sep 15 '09, 10:27 a.m.
The following WIKI topic describes the schema.

https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20


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.

permanent link
James Moody (3.3k24) | answered Sep 15 '09, 11:12 a.m.
JAZZ DEVELOPER
On 9/15/2009 10:38 AM, ltsao wrote:
rjaouaniwrote:
The following WIKI topic describes the schema.

https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20

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.


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


Register or to post your answer.