How to Transform and Enrich Data in Oracle Analytics Cloud? – Part 2
In this section we will have look into Data set.
Step 1: Logged into OAC and Click on Create to your right-side corner:
Click on Data Set and you will get below options:
In our last section we already got the idea on how to create static Data set as “Drop Data File here or Click to Browse”
2nd option is Local Subject Area, here you can get all local subject area
3rd option is Create Connection, here you can create connection which will point your SaaS Instance. Like I have created Dev6 and TEST.
Click on Create Connection and you will get multiple adaption, choose respectively and create a connection.
We have here two SaaS Connection already with us with the help of Oracle Application Adapter.
Give all the necessary details and create connection.
How To create Data set with the help of SaaS pointed connection, how to get details (Here we are talking about specifically OTBI how to get data extract/data from OTBI Analysis).
There are two ways to get data/data extract from OTBI analysis:
1. Create analysis in SaaS and then incorporate developed Analysis in OAC
2. Create Data Set in OAC instance itself
We will investigate two ways to get OTBI Analysis data set.
1. From SaaS:
Login to SaaS and go to tools –> Reports and Analytics –> Browse Catalog –> New –> Analysis
Create Analysis with the help of Subject area based on Your Requirement.
Then go to OAC Instance and click on
Create –> Data set –> Choose connection from respective SaaS Instance You will get window given below:
You will get 3 options:
Select Columns: Here you can select columns from Subject areas directly
We have here Financial Common Module – Intercompany Transaction Real Subject area.
Click on that and you will have a window as given below:
Select Necessary columns from Subject area and click on Add Selected. Selected columns can be removed one by one by clicking on Remove Selected. And for removing all Click Remove all.
Now click on Add and create a Project from same and save it.
Select Analysis: Here you will have your created Analysis from SaaS
For this click on option two select analysis and you will get below window:
Red circle path will be your created connection name + Folder structure from SaaS where you have saved your Analysis.
Click on add and create project from the same, save it.
Enter Logical SQL: Here you will have option to write logical query.
Want to read Part-1