Is it possible to write queries across Project Areas?
2 answers
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.
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