Data warehouse questions
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
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 |
|
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 |
|
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. 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.
|
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.