Connect to Oracle Fusion Cloud Applications Suite
You can connect to Oracle Fusion Cloud Applications Suite and create datasets that help you visualize, explore, and understand your applications data.
About the Oracle Applications Connector
The "Oracle Applications" connection type () enables you to use Oracle Analytics to visualize data from applications in Oracle
Fusion Cloud Applications Suite. For example, Oracle
Fusion Cloud Financials.You can also use the "Oracle Applications" connection type to connect to your on-premises Oracle BI Enterprise
Edition deployments (if patched to an appropriate level) or connect to another Oracle Analytics service.
You can connect to these applications in Fusion Applications Suite:
-
Oracle Fusion Cloud Financials
-
Oracle Fusion Cloud Human Capital Management
-
Oracle Fusion Cloud Loyalty
-
Oracle Fusion Cloud Procurement
-
Oracle Fusion Cloud Project
-
Oracle Fusion Cloud Supply Chain Planning
-
Oracle Sales Automation
Note:
When you connect to applications in Fusion Applications Suite, you access the data from an Oracle Transactional Business Intelligence report. These reports are subject to caching in Oracle Transactional Business Intelligence, and the data available in Oracle Analytics is based on the cached data. You can't control the cache behavior in Oracle Transactional Business Intelligence from Oracle Analytics.Connect to an Application in Oracle Fusion Cloud Applications Suite
Create a connection to an application in Oracle Fusion Cloud Applications Suite to visualize data from that application. For example, you can connect to Oracle Fusion Cloud Financials with Oracle Transactional Business Intelligence. You can also connect to Oracle BI Enterprise Edition.
The connection is visible only to you (the creator), but you can create and share datasets for it.
Configure Impersonate User for the Use Active User's Credentials Option
You can configure "impersonate user" to enable the active user's credentials option when you use the Oracle Applications connection type.
Tips on setting up impersonation
- Provision one administrator user in the Oracle Fusion Cloud Enterprise Performance Management (EPM) identity domain with the necessary roles and permissions to impersonate other users.
- Specify the credentials for this EPM administrator user when you import the metadata using the Model Administration Tool. The credentials are stored in the connection pool of the RPD data model created by the Model Administration Tool.
- In addition, the SSO checkbox must be checked on the Planning server connection pool in the RPD.
- With this setup, only one native user needs to be provisioned in the EPM identity domain. Other end users log into Oracle Analytics using their SSO credentials, and Oracle Analytics passes the SSO username to Planning and Budgeting Cloud Service when connecting, along with the credentials of the native EPM administrator user that has impersonation permissions.
- Note: Logging into EPM using SSO credentials isn't supported by the REST API or the Planning ADM driver.
Provision Impersonate User for Connection to Oracle Fusion Cloud Applications Suite
You can provision the impersonate user functionality in Oracle Fusion Cloud Applications Suite when your connection target is an application in Oracle Fusion Cloud Applications Suite with Oracle Transactional Business Intelligence.
Create a Dataset from a Subject Area in Oracle Fusion Cloud Applications Suite
You can create a dataset from subject areas stored in an applications in Oracle Fusion Cloud Applications Suite. For example, Oracle Fusion Cloud Financials with Oracle Transactional Business Intelligence.
- On the Home page, click Create and then click Dataset.
- In the Create Dataset dialog, select a connection to the application you want to analyze. Oracle Applications connections have this icon:
- In the Dataset editor, go to the Connections pane and browse or search for a subject area.
- Drag and drop one or more subject areas to the Join Diagram.
- To add columns to a table, go to the Table Page Tabs, click a subject area table, and use the Transform Editor to specify which columns to include in the table. Click OK.
- In the Join Diagram, locate the table that you want to join, hover over it to select it, and then click and drag and drop it on to the table that you want to join it to. Open the Join editor to inspect or update the join type and conditions.
- Click Save Dataset.
- Change the default name "New Dataset" displayed top left.
Create a Dataset from an Analysis in Oracle Fusion Cloud Applications Suite
You can create a dataset based on analyses from applications in Oracle Fusion Cloud Applications Suite. For example, Oracle Fusion Cloud Financials with Oracle Transactional Business Intelligence.
- On the Home page, click Create and then click Dataset.
- In the Dataset editor, go to the Connections pane and browse or search for an analysis.
- Drag and drop one or more analysis to the Join Diagram.
- In the Join Diagram, locate the table that you want to join, hover over it to select it, and then click and drag and drop it on to the table that you want to join it to. Open the Join editor to inspect or update the join type and conditions.
- Click Save Dataset.
- Optional: Change the default name "New Dataset" displayed top left.
Edit an Oracle Applications Connection
You can edit an Oracle Applications connection. For example, you must edit a connection if your system administrator changed the Oracle Applications login credentials.
- In the Data page, click Connections.
- In the Edit Connection dialog, edit the connection details. Note that you can’t see or edit the password that you entered when you created the connection. If you need to change the connection’s password, then you must create a new connection.
- Click Save.