Oracle Data Cloud: What Oracle knows about you..

As described in a previous article, many website connect and forward visitor information to other Parties in order to Analyse and Understand the Website visiting pattern. The best and probably well-known example is Facebook. Even when visiting another website, Facebook is often called in the backend by the web site e.g. by a hidden hyperlink or hidden pixel (which needs to be downloaded from Facebook) and by this Facebook receives the information that the respective website has been visited. Using this information, it is possible to create a certain profile of the Visitor in terms of interest and other attributes, which can be used for Target Marketing campaigns. While Facebook is well-known, Oracle also has a large presence within the Marketing World and acquired the data (profile) provider Bluekai, which is now called Oracle Data Cloud. This information can also be integrated with the Oracle Marketing Cloud (formally Eloqua) for the creation of Marketing Segments and Campaign execution.

Every User can also check the information kept about himself by visiting: http://www.bluekai.com/registry-de/ 

image

Oracle Business Process models are back for Fusion Cloud

For the earlier releases of Siebel CRM the Official Bookshelf (pdf version here) also contained a documentation of Business Processes to describe the activity flow within the Application from a starting point to a end point like the example below:

image

However, these have been discontinued from Version 7.5 for forth following releases. While some parts of the Oracle Organizations certainly maintained these afterwards as Assets, these were not general available as part of the official documentation anymore. For the new Fusion Application Software, which combines all previous separated products from PeopleSoft, e-Business Suite and Siebel into a single Application, the Business Process models are back. While they are not published on alongside the Official Documentation they are accessible via the Oracle Support Portal at the following site: Oracle Fusion Business Process Models: Homepage (Doc ID 1542019.1).

The above site lists the following Level 1 Business process area e.g. Marketing. Level 2 of the Business Process then describes the step in the process e.g. Develop Campaign and afterwards Execute Campaign. The Level 3 then contains a detailed activity flow in MS Visio e.g. Launch Campaign and Manage responses.

Business Process Area

01 Enterprise Planning and Performance Management

02 Marketing

03 Sales

04 Order Fulfillment

07 Supply Chain Planning

09 Product Management

10 Production

11 Procurement

12 Materials Management and Logistics

14 Project Management

15 Financial Control and Reporting

16 Cash and Treasury Management

17 Asset Lifecycle Management

19 Enterprise Information Management

21 Workforce Deployment

22 Workforce Development

23 Compensation Management

BICS development life-cycle

Within an on-premise scenario, the OBIEE development life-cycle was quite simple:

  1. connect to a data warehouse and import the warehouse tables (metadata import to physical layer)
  2. build OBIEE metadata model (RPD)
  3. upload the RPD into Weblogic using the Deployment screen

Within a cloud scenario the BICS development life-cycle is quite the same, but requires some additional steps and some decisions on the development model: either using web-based BICS developer or upload of full RPD file developed using OBIEE Admin Tool.

While it’s possible to develop the complete metadata model within the cloud using the BICS web-based Modeller, like below:

image

the capabilities of this web-based Modeller are more limited. Due to this there is no option to edit or change the uploaded RPD file within the web-based BICS modeller afterwards. The process to upload a locally developed (OBIEE) metadata model (.rpd file) to the BICS Cloud is called “lift&shift”.

The required setup for this OBIEE to BICS development life-cycle using lift & shift is described in below diagram:

image

For the BICS development life-cycle setup the data of the Fusion Cloud e.g. HCM or ERP is assumed to be already present within a Oracle Database Cloud (DBaaS/DBCS). For this setup all components (formally probably referred to as “server” components) are provisioned on the Oracle Public Cloud behind a firewall and only the IT Development Tools (IDE) are installed on a developer machine like a desktop or laptop.

The following integrations need to be setup:

Integration point Integration point Description documentation/links
BICS DBaaS Connect the BI Cloud (BICS) to the Database Cloud (DBaaS) to analyse the stored data e.g. extracted Fusion HCM data How Does Oracle BI Cloud Service Integrate with Oracle Database Cloud Service?

Managing Database Connections

(local) SQL Developer DBaaS Connect the local SQL Developer e.g. installed on a Computer or Laptop to the Database Cloud (DBaaS) Accessing a Database Cloud Service instance using Oracle SQL Developer

Connecting to a Database Cloud Service (DBaaS) Instance Through an SSH Tunnel

(local) BI Admin Tool  (RPD file) BICS upload the local developed .rpd file (using the OBIEE Admin Tool) into the BI Cloud (BICS) Uploading Data Models from Oracle BI Enterprise Edition

“Lift and Shift” On-Premise RPD to BI Cloud Service (BICS)

How to Upload OBIEE RPD to Oracle BICS

BICS Lift and Shift of BIAPPS Content

To create Backup as part of the development life-cycle refer to the following article:

BIAPPS on PAAS – Backup and Restore – Introduction

To connect between DBaaS and the Fusion Application Cloud (SaaS):

BIAPPS on PAAS – Source Connectivity

The above scenario uses the Oracle Database Cloud for storing the data. If the Data is not stored in the Oracle Database Cloud, but the Oracle Schema Cloud Service which is bundled for-free with BICS then the data must be loaded into BICS using the BICS Data Sync tool:

image

Within the all above scenario the (“server”) components are provisioned on the Oracle Public Cloud. For a scenario where some components like the Database still reside on-premise the following tool needs to be installed on the server hosting the Oracle Database:

image

as described in this article from Oracle.

ODI 12c: Upgrade Benchmarks

Please find below some Upgrade Benchmarks for upgrading the (Database) Repository for Oracle ODI 11g to ODI 12c using the ODI Upgrade Assistant which performs all necessary steps to convert the Repository e.g. upgrading the 11g interface to 12c mapping concept, as seen in below step:

image

Below is a table with the benchmarks for the respective Repositories:

Repository Repository Size in MB (measured by XML export size) Time duration
MASTER 150 33 Minuets
WORK REPO 1 250 15 Hours
WORK REPO 2 150 15 Hours

The Oracle support also features a Technote containing some tips to improve the process:

ODI Upgrade Hangs With Upgrade Progress Stucks at x% (Doc ID 1664300.1)

provide access to OTBI and BI Administration Role

Fusion Application Cloud users can access the Reporting and Analytics (OTBI) module via the Fusion Sitemap listed under “Tools”:

image

This opens the embedded Analytics Catalog which contains all items for each domain such as Human Capital Management:

image

To grant access to Reporting and Analytics the Cloud Admin User or another User having received the “IT Security” Role can provide access to OTBI:

image

And needs to assign at least the Employee Role to the respective User to access Reporting and Analytics:

image

To grant the BI User “OTBIUser” also the BI Administration Role requires to follow the TechNote from Cloud R12 and onwards as the standard BI Roles (such as BI Author or BI Consumer) can’t be assigned to Users directly anymore. Instead it is required to create a custom Role based on the standard (OOTB) Role and assign the custom role to the User to act e.g. as BI Administrator.

image

Link

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.

Oracle BI12c: placing custom images in BI Server and reference using fmap

For Oracle BI 12c custom content such as images or pdf help files needs to be placed in the following directory:

/domains/bi/servers/obips1/tmp/earmanager/analytics/../res/

where /../ is a dynamic folder name such as v-PLM12aFeu7Y.

Within a Report or Dashboard this path may be referenced using the following syntax:

fmap:file_name

or:

fmap:foldername/file_name (if a subfolder “foldername” was created below /res)

the below links provide further information on using fmap or placing custom resources within Oracle BI:
Storing Custom Files Locally and Using the fmap Function to Reference Them
How to configure static content in OBIEE 12c

fixing: BAR file export for non UTF-8 char set

The following Error message was display when exporting the BAR file from Oracle BI 12c:

SEVERE: Error while reading application-role.
apr 12, 2017 1:53:22 PM oracle.bi.jazn.bar.JaznFileExport ProcessApplicationRole

SEVERE: Error while reading application-role.
apr 12, 2017 1:53:22 PM oracle.bi.jazn.bar.JaznFileExport RemoveUnrequiredNodes
SEVERE: Failed on removing unrequired node during export.com.sun.org.apache.xerc
es.internal.impl.io.MalformedByteSequenceException: Invalid byte 2 of 3-byte UTF
-8 sequence.
apr 12, 2017 1:53:22 PM oracle.bi.jazn.bar.plugin.JaznMetadataManagerGenericPlug
inImpl exportServiceInstance
SEVERE: Failed in modifying content of migrated jazn file D:\workDir\exportSICus
tomization\ssi\metadata\authmodel\jazn\jazn-data.xml
apr 12, 2017 1:53:22 PM oracle.bi.bar.si.framework.handler.JaznServiceInstanceHa
ndler exportServiceInstance
SEVERE: Failed running exportServiceInstance API of oracle.bi.jazn.bar.plugin.Ja
znMetadataManagerGenericPluginImpl
oracle.bi.bar.si.framework.plugin.MetadataPluginException: Failed in modifying c
ontent of migrated jazn file D:\workDir\exportSICustomization\ssi\metadata\authm
odel\jazn\jazn-data.xml
at oracle.bi.jazn.bar.plugin.JaznMetadataManagerGenericPluginImpl.export
ServiceInstance(JaznMetadataManagerGenericPluginImpl.java:359)
at oracle.bi.jazn.bar.plugin.JaznMetadataManagerGenericPluginImpl.export
ServiceInstance(JaznMetadataManagerGenericPluginImpl.java:66)
at oracle.bi.bar.si.framework.handler.JaznServiceInstanceHandler.exportS
erviceInstance(JaznServiceInstanceHandler.java:525)
at oracle.bi.bar.si.framework.ServiceInstanceFrameWorkImpl.exportService
Instance(ServiceInstanceFrameWorkImpl.java:370)
at oracle.bi.bar.si.ServiceInstanceLifeCycleImpl.exportServiceInstance(S
erviceInstanceLifeCycleImpl.java:665)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.python.core.PyReflectedFunction.__call__(Unknown Source)
at org.python.core.PyMethod.__call__(Unknown Source)
at org.python.core.PyObject.__call__(Unknown Source)
at org.python.core.PyObject.invoke(Unknown Source)
at org.python.pycode._pyx133.exportServiceInstance$4(/D:/Oracle/Obiee12c
/bi/lib/bi-bar.jar!/wlstScriptDir/ServiceInstanceLifeCycle.py:84)
at org.python.pycode._pyx133.call_function(/D:/Oracle/Obiee12c/bi/lib/bi
-bar.jar!/wlstScriptDir/ServiceInstanceLifeCycle.py)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyFunction.__call__(Unknown Source)
at org.python.core.PyObject.__call__(Unknown Source)
at org.python.pycode._pyx165.f$0(<console>:1)
at org.python.pycode._pyx165.call_function(<console>)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyCode.call(Unknown Source)
at org.python.core.Py.runCode(Unknown Source)
at org.python.core.Py.exec(Unknown Source)
at org.python.util.PythonInterpreter.exec(Unknown Source)
at org.python.util.InteractiveInterpreter.runcode(Unknown Source)
at org.python.util.InteractiveInterpreter.runsource(Unknown Source)
at org.python.util.InteractiveInterpreter.runsource(Unknown Source)
at weblogic.management.scripting.utils.WLSTInterpreter.runsource(WLSTInt
erpreter.java:1095)
at weblogic.management.scripting.WLST.main(WLST.java:227)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at weblogic.WLST.main(WLST.java:47)

apr 12, 2017 1:53:23 PM oracle.bi.bar.si.framework.ServiceInstanceFrameWorkImpl
exportServiceInstance
SEVERE: Error during export service instanceoracle.bi.bar.si.exception.ServiceIn
stanceLifeCycleException: Failed running CreateServiceInstance API of oracle.bi.
jazn.bar.plugin.JaznMetadataManagerGenericPluginImpl
apr 12, 2017 1:53:23 PM oracle.bi.bar.si.ServiceInstanceLifeCycleImpl exportServ
iceInstance
SEVERE: Failed in running all the handlers during export service instance.
Traceback (innermost last):
File "<console>", line 1, in ?
File "/D:/Oracle/Obiee12c/bi/lib/bi-bar.jar!/wlstScriptDir/ServiceInstanceLife
Cycle.py", line 84, in exportServiceInstance
at oracle.bi.bar.si.ServiceInstanceLifeCycleImpl.exportServiceInstance(S
erviceInstanceLifeCycleImpl.java:669)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)

oracle.bi.bar.si.exception.ServiceInstanceLifeCycleException: oracle.bi.bar.si.e
xception.ServiceInstanceLifeCycleException: BAR-00005

 

To fix this error the special characters needed to be removed from the Application Role name, such as the following example:

image

After the removal of the special character from the Application Role name the BAR file could be created successfully.

changing the default data type of number formats

to change the default format used by the Oracle BI EE 11g the following configuration file needs to be changed:

/home/oracle/Middleware/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/SampleAppLite/root/system/metadata

image
E.g. for two digits behind the number separator:

<dataFormat minDigits="2" maxDigits="2" commas="true" 
negativeType="minus" xsi:type="saw:number";

After saving and restarting the BI Server, the numbers are displayed with two digits behind the number separator.