BI Answers To Tableau

To extract data from OBI to Tableau follow these steps :

Step 1

Sign in to OBI(Oracle Business Intelligence) by entering User-Id and password.


Step 2

Click on Catalog to open the Catalog tab.


Step 3

Select the desired folder which you want to publish in Tableau. Let us consider the folder Supply Chain and Order Management under Shared Folders.


Step 4

On clicking on Supply Chain and Order Management, all sub-folders appear on right hand side.


Step 5

Out of all sub-folder let us consider the folder Sales Revenue and Fulfillment and click on Expand to open.



You can now find more sub-folders inside it. Choose any one folder to get into it. Let us consider the folder Customer and click on Expand.


Step 7

You will now find some reports inside it. Select any one and click on edit. Let us consider Industry Profile.


Step 8

You will be now directed to Result tab of that analysis and the result of analysis will be displayed.


Step 9

Now go to Advanced tab and click on it.


Step 10

Move down to Advanced SQL Clauses and write the code ” SET VARIABLE LOGLEVEL=5,DISABLE_CACHE_HIT=1;” in Prefix. Then click Apply SQL.


Step 11

After clicking on Apply SQL a pop up window appears that gives a notification. Click OK to proceed.


Step 12

Click on Save button on top right side to save the changes you made.


Step 13

To view the session log Click on Administration.


Step 14

Now move to Session Management and click on Manage Session.


Step 15

A list of Session log appears on screen. Choose the session which has time nearly equal to current time and prefix that you have added. Then click View log.


Step 16

You will now find a list full of logical SQL and physical SQL. Catch up the Physical SQL and run in Toad.


Step 17

Rename the columns by giving suitable names and run the code. Result will be displayed on the data grid.


Step 18

Your data is ready to be migrated to Tableau. So open Tableau Desktop and log into it through Oracle.


Step 19

Now provide the required server connection and log in to Tableau.


Step 20

Double click New Custom SQL. Then paste the executed SQL query in Edit Custom SQL and click OK.


Step 21

You can now see the columns that were generated while running the SQL command. Click on Update Now.


Step 22

The data will be displayed in Tableau. To create graphs go to WorkSheet.


Step 23

Now drag Customer_code and Date_1 to Rows and Sum_Of_Dis_Global and Sum_Of_Net_Global to Columns. You can see the datas in tabular format.


Step 24

Click on New WorkSheet icon to create another sheet.


Step 25

In the new Sheet drag Customer_code and Date_1 to Coulmns and Sum_Of_Dis_Global and Sum_Of_Net_Global to Rows. You can also use Show Me to create various graphs. You can also add Color by dragging Customer_code into Color Mark Card. The graph can be created as below :


Step 26

You can also change the color of the line graph so that bar graph and line graph color appears differently. To do this drag any one Measures into Color. The line graph color changes as below :


Step 27

Create a dashboard by clicking on New Dashboard icon.


Step 28

Drop the two sheets into dashboard. You can see both the data and the graph.



Step 29

Click on Dashboard present in Layout section and tick Show Title check box. The default name of Dashborad will appear.


Step 30

Rename the Dashboard to Industry Profile by right clicking on Dashboard 1 and choosing Rename Sheet.

30 a

Step 31

You can also add images either in tiled or in floating by clicking on image option and navigating to the specific location where the image is stored.


Step 32

Finally save the Tableau you have made. The Tableau will appear as follow.


Leave A Reply

Your email address will not be published. Required fields are marked *