It's all about the answers!

Ask a question

Data warehouse questions


Roman Smirak (3164933) | asked Aug 17 '08, 2:28 p.m.
Hi,

1. I haven't found description of Workitem snapshot's LIVE_WORKITEM_CNT
table - could you please point me which java class/es implement it?

2. What if I change the type of an existing work item e.g. from Task ->
Enhancement => will you update existing snapshot data (e.g. new work item
per type count)? In general: should warehouse service interpret current
changes and reflect it to older snapshot data? I guess not if I understood
the role of datawarehouse service but I need to be sure...

Thanks a lot,

Roman

9 answers



permanent link
Rafik Jaouani (5.0k16) | answered Aug 18 '08, 11:06 p.m.
JAZZ DEVELOPER
1) LIVE_WORKITEM_CNT gives you a live view of the data from the repository. The data comes from the repsitory and not from the data warehouse.

2) Every 24 hours a snapshot of the data in the repository will be taken and stored in the data warehouse (of course in a more compact form). Once that data is stored in the data warehouse, it won't be modified. The next day a new snapshot will be stored. All the data stored for a particular snapshot will have a timestamp of when the snapshot was taken.
The data that does not change is stored in fact tables. Dimension tables store data that can change like Contributor names, Team Area names, Iteration start and end dates...

permanent link
Roman Smirak (3164933) | answered Aug 19 '08, 5:19 a.m.
Thanks I got it; about LIVE_WI_CNT: can I get an access to custom attributes
of a work item? Who and how creates the view?

Thanks,

Roman


"rjaouani" <rjaouani> wrote in message
news:g8dde8$291$1@localhost.localdomain...
1) LIVE_WORKITEM_CNT gives you a live view of the data from the
repository. The data comes from the repsitory and not from the data
warehouse.

2) Every 24 hours a snapshot of the data in the repository will be
taken and stored in the data warehouse (of course in a more compact
form). Once that data is stored in the data warehouse, it won't be
modified. The next day a new snapshot will be stored. All the data
stored for a particular snapshot will have a timestamp of when the
snapshot was taken.
The data that does not change is stored in fact tables. Dimension
tables store data that can change like Contributor names, Team Area
names, Iteration start and end dates...

permanent link
Rafik Jaouani (5.0k16) | answered Aug 19 '08, 4:21 p.m.
JAZZ DEVELOPER
You can only access modeled attributes that were tagged as queryable.

permanent link
Roman Smirak (3164933) | answered Aug 28 '08, 5:59 a.m.
And I can prepare such a live view and get all the attributes I like to be
included?

Roman

"rjaouani" <rjaouani> wrote in message
news:g8facb$ss8$1@localhost.localdomain...
You can only access modeled attributes that were tagged as queryable.

permanent link
Rafik Jaouani (5.0k16) | answered Aug 28 '08, 8:03 p.m.
JAZZ DEVELOPER
I am not sure I understand the question. Are you talking about custom attributes or the modeled built in attributes?

permanent link
Roman Smirak (3164933) | answered Aug 29 '08, 12:50 p.m.
Hi Rafik,

I need to extend (or create brand new live view) where I could include
all attributes I like to be there - in my cases my Custom work item type has
few custom attributes I should process in the report. It doesn't make sense
to have them in the snapshot data.

My question: how to create live view on repository data?

Regards,

Roman

"rjaouani" <rjaouani> wrote in message
news:g97emo$mhm$1@localhost.localdomain...
I am not sure I understand the question. Are you talking about custom
attributes or the modeled built in attributes?

permanent link
Rafik Jaouani (5.0k16) | answered Aug 30 '08, 12:45 a.m.
JAZZ DEVELOPER
The current live data sets only support querying data using jazz data queries. Jazz data queries only expose the modeled queryable non-custom attributes.

If you want to expose custom attributes, you could expose those by writing your own ODA driver.

permanent link
O. Frank Allen (16113) | answered Oct 03 '08, 1:21 p.m.
The current live data sets only support querying data using jazz data queries. Jazz data queries only expose the modeled queryable non-custom attributes.

If you want to expose custom attributes, you could expose those by writing your own ODA driver.


I have been read this thread with GREAT interest. So, If I understand correctly we can not access/query any custom attribute that were created on a Work Item. Correct?

What is an ODA driver?

Is there a tutorial here on Jazz net to provide an example as to how to create such a driver to access the custom attributes?

How would the data model be modified so that any new custom attributes would be associated to the Work Item?

Thanks in Advanced.
O. Frank

permanent link
Rafik Jaouani (5.0k16) | answered Oct 04 '08, 11:10 a.m.
JAZZ DEVELOPER
And ODA driver allows you to map any kind of data into some tabular form that BIRT can understand. You can start by looking at the Eclipse Data Tools and Birt projects for information.

Your answer


Register or to post 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.