Oracle Analytics Server

RDS is provisioned with Oracle Analytics Server Data Visualization and BI Publisher capabilities. You can access these capabilities by navigating to the Retail Home Application Navigator and tapping Data Visualization or Analytics Publisher (BI Publisher also known as BIP).

These links are protected by the same OCI IAM instance and fully supports single sign-on. Access to both Data Visualization and BI Publisher is further controlled by OCI Groups. See the Post Installation Configuration of the Retail Data Store Security Guide for a list of OCI Groups and their purpose.

For full details on taking advantage of Data Visualization and Analytics Publisher in RDS, please refer to the Visualizing Data in Oracle Analytics Server documentation.

Data Connections

Data connections for each schema are mapped to the HIGH, MEDIUM and LOW consumer groups (see Database Service Names for Autonomous Transaction Processing and Autonomous JSON Database for additional details). You can see, for example, what data connections are available when you create a new dataset in Data Visualization or construct a SQL Query in BI Publisher. The full list of connections is shown in the following table.

Connection	Consumer Group
Remote RDS BCCS Connection	Low
Remote RDS BCCS Connection Medium	Medium
Remote RDS BCCS Connection High	High
Remote RDS MFCS Connection	Low
Remote RDS MFCS Connection Medium	Medium
Remote RDS MFCS Connection High	High
Remote RDS OCRE Connection	Low
Remote RDS OCRE Connection Medium	Medium
Remote RDS OCRE Connection High	High
Remote RDS OROB Connection	Low
Remote RDS OROB Connection Medium	Medium
Remote RDS OROB Connection High	High
Remote RDS SECS Connection	Low
Remote RDS SECS Connection Medium	Medium
Remote RDS SECS Connection High	High
Remote RDS SIOCS Connection	Low
Remote RDS SIOCS Connection Medium	Medium
Remote RDS SIOCS Connection High	High
Remote RDS XOCS Connection	Low
Remote RDS XOCS Connection Medium	Medium
Remote RDS XOCS Connection High	High

Access Management Limitations

At present, though content author tool use can be restricted to Data Visualization or BI Publisher, authors have access to all database connections as well as all tables and views within those connections. Like authors, content consumers can be restricted to using one tool or the other; however, consumers have access to all reports.

BI Publisher Reports Delivery Through Object Storage

Delivering scheduled reports through Object Storage

For details on how to set up reports delivery through object storage, refer to Set Output Options in Oracle Cloud Visualizing Data and Building Reports in Oracle Analytics Cloud.

While adding the destination for the reports delivery as Object Storage, you will need the following set of inputs that are required to push the file to object storage.

1. Server – The server is preconfigured as OS for any tenant. OS must always be selected.

2. Prefix – The prefix under the object storage bucket where the file will be uploaded

3. File Name – The file name with which the scheduled report output will be delivered to the object storage.

   For example:

   
   
   
   
   

Delivering Burst Reports through Object Storage

For details on how to create a burst query refer to Add Bursting Definitions in the Oracle Cloud Modeling Enterprise Data in Oracle Analytics Cloud.

After configuring the data model as you build your burst query by navigating to the bursting section you need to be aware of some of the key parameters to be supplied to the burst query

Sample Bursting Query for object storage as the delivery channel:

Copy
select i.DEPT KEY,
'<template_name>' TEMPLATE,
'RTF' TEMPLATE_FORMAT,
'en-US' LOCALE,
'PDF' OUTPUT_FORMAT,
'OBJECTSTORAGE' DEL_CHANNEL,
'<output_name>' OUTPUT_NAME,
'OS' PARAMETER1,
'<prefix>'PARAMETER2,
'<file_name>' PARAMETER3
FROM
ITEM_MASTER I

Key parameters to be noted here for object storage mechanism are:

1. DEL_CHANNEL — This needs to be keyed in as OBJECTSTORAGE.

2. PARAMETER1 — Use OS as the parameter value for this, because this is the preconfigured server name. The value for this should be kept as OS and should not be changed.

3. PARAMETER2 — Prefix under object storage bucket where the file will be uploaded.

4. PARAMETER3 — File name.

Downloading the BI Publisher reports from Object Storage

Once the reports are sent to object storage, use the createPar service to download the files. This service is available in Retail Home; it generates a PAR (Pre-authenticated Request) to download the file.

For more details on this, refer to the Retail Home documentation.