We have enabled data security for our OBIEE environment. This security is based on Organization of an user. We now want to do an analysis of Resolution Time. We want to do this using KPIs feature in 11g. Now, for the Target Value, we want the average resolution time across all the organizations in the system. That is, we want to compare this user's organization against the performance of all the organizations in the system.
How can this be done in OBIEE 11g?