Power Queries and Case Series
Power queries include QBEs, filter value sets, and advanced conditions.
In a multi-tenant environment, power queries and case series work as follows:
- A new power query/case series created and saved stores the value of the enterprise
along with the other details.
- The value for the enterprise is derived from the logged-in enterprise.
- The Query and Case Series libraries display only the power query/case series specific to the logged-in enterprise.
- The Active function retrieves the active power query/case series for the user within the enterprise.
- You can grant permissions on a power query/case series to the groups that belong to the currently logged-in enterprise. The Permissions dialog box displays the User Groups that are associated with the logged-in enterprise.
-
The power query/case series created by users that are currently disabled or has been disassociated from the enterprise through which the power query/case series was created, are displayed in the respective library for users who have access to the respective power query/case series.
The power query/case series created by the users are deleted when the user account is deleted.
- When you execute a power query, the results display the cases from the currently logged-in enterprise only.
- All Query and Case Series libraries display the data pertaining to the logged-in enterprise only.
- SSO must be enabled to have the capability to switch client context and to open Oracle Argus Insight from the Application Access Portlet.
- There are no post-database upgrade considerations for existing users.
For more information, see: