Is it possible to write queries across Project Areas?
2 answers
Hello Harish,
an alternative to get data from multiple project areas would be using a reporting solution like RRDI, Insight or RPE.
You can also directly query the data warehouse database.
The limitation in this case is that you only have access to a subset of the information that a query can give you.
Jazz Reporting Service is also a promising solution, but at the current release only provide OOTB reports support
http://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.0/com.ibm.team.jp.jrs.doc/topics/c_jrs_intro.html
Best Regards,
Francesco Chiossi
an alternative to get data from multiple project areas would be using a reporting solution like RRDI, Insight or RPE.
You can also directly query the data warehouse database.
The limitation in this case is that you only have access to a subset of the information that a query can give you.
Jazz Reporting Service is also a promising solution, but at the current release only provide OOTB reports support
http://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.0/com.ibm.team.jp.jrs.doc/topics/c_jrs_intro.html
Best Regards,
Francesco Chiossi
Harish,
as far as I know this is currently not possible. This is a popular request however.
The problem with doing it is, each project area has potentially a different process definition with different attribute specifications. Not even attributes with the same ID are necessarily comparable, or provide the same values.
as far as I know this is currently not possible. This is a popular request however.
The problem with doing it is, each project area has potentially a different process definition with different attribute specifications. Not even attributes with the same ID are necessarily comparable, or provide the same values.