Calculate the cost of Oracle Cloud using the cost estimator
the data extract from Oracle Fusion cloud is managed by the Fusion BI Cloud Connector (BICC). This console can be access by the following typical URL: https://customername.fa.datacenterregion.oraclecloud.com/biacm/
For the login a dedicated user is recommended e.g. BICC_ADMIN, since this user will be used to create the extract. According to the documentation, this user must be assigned with the following application roles in order to inherit the required permissions for running the extract:
This user is typically created by the Fusion team and given to the BI team. The BI team can validate the assigned roles by logging in to the following url:
and clicking on the user name in the top right corner. This will list all the assigned application roles to the user:
After validating the user, the Oracle BI Application modules need to be selected within BICC for extraction. This can be done by clicking on the calender icon of the top right menu and clicking on Global Data Store List.
This opens the page to enable the Oracle BI Application product offerings / modules within BICC for Fusion cloud extract. The offering must be selected from the drop down list and then be enabled for extract.
After all required modules have been selected, the modules can be extracted to UCM (this is the bundled file storage of any Fusion Cloud instance and may be used by multiple Fusion modules e.g. the data import to Fusion Cloud itself). The extract can be configured by clicking on Manage Extract Schedules on the top right menu.
This opens the schedule of extracts pane. A extract job can be created from this pane:
A new extract can be created by clicking the plus icon on the top pane. This will open a guided workflow, which allows to select the modules which should be extracted. E.g. in an initial project phase you may only choose to extract (run) a single module extract, while you have actived multiple modules. For example the project consists of Financials, Supply Chain, Procurement, but only the Procurement module is scheduled for extract.)
In case of errors with the extract, the log can be downloaded by clicking the help icon in the top right area of the screen:
and by clicking download latest log:
The log file may then provide further insight into any issues with the extract:
For further reference, please check:
The following is a step-by-step guide to determine the Connection string for Oracle Analytics Cloud and Oracle Database Cloud.
When logging into your Oracle Cloud Service using your identity Domain, a similar page is being displayed:
Click on the Action Menu of the Database Cloud Service and select “Open Service Console”.
This Page shows details about your Cloud Services such as OCPUs, Storage or Memory:
click on the Database Service Name to get to the Details Page:
This reveals the Public IP of the Oracle Cloud Database and the required Service Name.
Within the Oracle BI Administration Tool, the connection string needs to be created in the Data Source Name Field:
Using the following format:
After modelling the data and saving the .rpd file, the Model can be uploaded to the OAC Cloud:
The following Link shows the Oracle Cloud Public IP Addresses in order to create a Virtual Cloud Network (VCN) between customers data centers and Oracle Cloud Data Centers:
Navigate to “Public IP Addresses for Your VCN”
The following Article is written as of April 2018. Since, the Cloud is evolving rapidly, it may not apply in full, in future.
The aim of the Article is to demonstrate the possibilities of connecting to Oracle Fusion Applications (FA) Cloud (via OTBI) without any data extraction (ETL). Thus, only using declarative approaches offered by Visual Analzer (VA) of Oracle Business Intelligence Cloud Service (BICS) / Oracle Analytics Cloud (OAC) and the downloadable version of VA, the Data Visualization (DV) Desktop (DVD). The following diagram re-iterates the scope of this Article:
The following Version and respective features are used as baseline for this Article (as available of April 2018)
|Oracle Fusion Applications Cloud / OTBI||R13|
Oracle Fusion Applications (FA) Cloud comes bundled with OTBI, which provides pre-built BI Subject Areas to access the data stored in FA:
However, OTBI does have some limitations when it comes to extensibility (no access to metadata model) and adding of additional data sources (limited to data connection of respective FA instance).
The Oracle Cloud offering for “stand-alone” analytics are BICS (and in the future OAC). Hence, there maybe the need to connect from BICS/OAC to Fusion Applications. This is possible by two general Options:
This Article only focuses on the latter three options (declaring the connection details without any data movement).
DV Desktop represents a offline Version of Visual Analyzer and can be downloaded from OTN. Once installed, it can be used to create a Connection to Oracle Fusion Applictions from the top right create Menu:
One of the Options from the “select connection type” list is “Oracle Application”:
This “Oracle Application” is the reference to Oracle Fusion Application’s Cloud via the OTBI URL !
It will not work with only the Oracle Fusion Application Cloud URL e.g. https://<IdentityDomain>.fs.em3.oraclecloud.com/homePage/faces/FuseWelcome , but only the respective OTBI URL e.g.: https://<IdentityDomain>.fa.em3.oraclecloud.com/analytics
If the URL is entered incorrectly, e.g. when using a trailing “/” it will not save the connection:
Once the correct OTBI URL, Username and Password are entered and saved, the connection is added to the list of available Data Connections:
As stated before: These “Oracle Applications” connections will only work with the respective OTBI URL, since the metadata (such as subject areas or Report from Catalog) is retrieved from this URL only. Once the connection is created, the Subject areas are available and the Analysis can be created in DVD:
The equivalent of DVD for the web is Visual Analyzer (VA), which is part of OBIEE 12c as-well as BICS (and OAC). The same connection to Fusion Applications Cloud can also be created within VA of BICS. To do this, the VA Projects needs to be selected from the BICS (Classic) Home Page:
Within VA, click on “Add Connection” under the “Add new Data Source”:
And choose “Oracle Application” as connection type once again:
For the web version, the list of available data connections is also much smaller (only Oracle Applications and Oracle Database) compared to DVD. The connection details need to be entered in a similar way for VA e.g. as shown below:
After the Connection was saved successfully, the Connection can be used to create a Visual Analysis. However, VA of BICS will only provide the possibility to access saved Reports, but not the Subject area’s itself (compared to DVD)!
The steps for connecting from VA of OAC to Oracle Fusion Applications (FA) are very similar to VA of BICS. Select VA from the OAC Homepage:
And create the connection in the same way. After successfully creation of the connection, it is listed as Connection in the Data list:
VA of OAC is not limited to create Analysis on predefined Reports (compared with VA of BICS). It is also possible to create an Analysis based on the subject area (similar to DVD):
The screenshot shows, the data preview from the Subject areas:
(as of April 2018) The possibility of connecting from BICS/OAC to Oracle Fusion Applications (FA) Cloud is only available with VA. This is not (yet) available for Reports and Dashboards:
For Reports and Dashboards only a Database Connection can be added, but not a Oracle Applications connection.
Oracle Fusion Cloud allows to enable text fields as multi lingual enabled attributes. As part of the batch upload process e.g. from Fusion Product Hub, these enabled attributes can be specified within different languages:
Within Oracle Fusion Cloud, these attributes are displayed in the respective Language of the logged in User. These is also true for OTBI. E.g. for US the respective item description is displayed in US:
If a user logges into OTBI with RUS language, the item description is automatically displayed with RUS description:
Within Oracle Fusion OTBI go to New > Analysis and click on Create Direct Database Query:
specify the connection Pool information within the editor:
The following connection pools can be entered:
Please note: when copying&pasting the connection pool names from WordPress, there may be an issue with the double quotes(“) and you may need to re-type the double quotes (“) within OTBI.
After that, a query may be entered for direct database execution on the Oracle Fusion Cloud (bundled) Database (identified by the Connection pool supplied before):
For a listing of all Physical Tables please refer to (only available for HCM): https://cloudcustomerconnect.oracle.com/posts/ac54c31fcf
This contains a Excel mapping with the Physical OTBI Tables:
For a full support note, please refer to:
For a similar approach using BI Publisher please check:
To check the general TechNote for OTBI and Fusion HCM, please refer to:
Link to information about business questions and answers for Oracle Transactional Business Intelligence (OTBI) Embedded Analytics Cloud, HCM Subject areas: http://www.oracle.com/technetwork/documentation/otbi-hcm-2225528.html
And for OTBI-E subject areas. The advantage of this is, that it is indeed very similar to Oracle BI Applications (OBIA) and can easily be applied for the same:
While current Cloud go lives have only a estimated timeline of six Month, these Go-Lives need to be put in perspective with a currently in use on-Premise Application Landscape by a given Company. The below Table tries to list the Clouds advantage over current on-Premise Application Landscape. After the typical six Month Go-live period from start of Development, the Cloud system may not be able to provide the same Functionality, but is already advantageous in other areas like simplicity or cost. Within a typical on-Premise scenario a Customer might needed to perform high level of customization in order to facilitate the business requirements. Going forward this customized functionality may become available within the Cloud as part of the standard coverage and development Roadmap. Below is a summary using certain criteria to compare a On-Premise Application and a new Cloud Application.
Oracle recently announced that it will enhance the EU Cloud in Germany/Frankfurt with additional services for PaaS and IaaS. This additional services are expected to be available during the second half of the calendar year and are enhancing the current SaaS services which are already available within the EU Cloud in Germany.
This expansion of the Oracle Cloud EU Region in Germany will consist of three high bandwidth/ low latency sites providing the required levels of failure protection and availability. As part of the EU Cloud Region, this will also ensure a single data jurisdiction (together with other sites in the UK and Amsterdam).
The full press release can be found here.