Data warehouse questions

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...

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...

You can only access modeled attributes that were tagged as queryable.

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.

I am not sure I understand the question. Are you talking about custom attributes or the modeled built in attributes?

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?

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.

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

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.