It's all about the answers!

Ask a question

RTC datawarehouse Duration value


Clement Liu (1.5k54249) | asked Nov 09 '10, 2:04 p.m.
found out that the Duration value in WS_STRING_EXT view is different than in WORKITEM_CHNGS table. the Duration value in WS_STRING_EXT is actually coming from WORKITEM_CHNGS, right? Why the number does not match?

http://2.bp.blogspot.com/_2YQMPJPq75s/TNmZ8oU8b2I/AAAAAAAAANA/AJi1_ZOuaE4/s1600/brit%2Bpreview.jpg

http://1.bp.blogspot.com/_2YQMPJPq75s/TNmaIy_W_0I/AAAAAAAAANI/qpfylR78J1E/s1600/brit%2Bpreview%2B2.jpg

One answer



permanent link
Rafik Jaouani (5.0k16) | answered Nov 10 '10, 10:48 a.m.
JAZZ DEVELOPER
WS_STRING_EXT auto-aggregates the DURATION column by doing a SUM. the rows you are seeing are not the real database rows but are probably an aggreagte of multiple rows.

Rafik Jaouani
Developer
Reports Team

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.