Creating your First Analysis Using Oracle BI Cloud Service

Step 1: Sign in to Cloud by proving your username and password & click on Sign In.

Sign in to cloud

Step 2: Click on the Analyses link on the homepage of the Oracle BI Cloud Service.



Step 3: In the Analysis tab click Create Analysis button. Here, you can also view the recent analyses & click on actions then select the required option directly from in here if required.

click create analysis

Step 4: Then select the subject area on which you want to perform analysis on.

select subject area

Step 5: Select the columns from the criteria tab and drop it in the selected column area.

select columns from criteria tab

Step 6: Now you can sort a column using the more options(the gear icon).

sort descending

Step 7: Now you can add the filters to the analysis.



Step 8: In the filter dialog box, select the appropriate operators and set the values. Click OK.

filter dialog box

Step 9: You can see the filters in the filter area in the criteria tab.

see filter here

Step 10 : Click on the results tab.

results tab

Step 11: Add a new column region and rearrange it inside the table by hovering over the column names and dragging it before the the column you want to position it.

add another table region and rearrange by dragging it

Step 12: Click on the ‘X’ to remove the view from the compound layout.

remove the view from compound layout

Step 13: Click on the new view button to add a pivot table to the compound layout.

click on new visualisation

Step 14: In the Pivot table click on the view properties.

select a pivot table

Step 15: In the properties dialog box change the data viewing to content paging and checking the enable alternate styling and click OK.

pivot table properties

Step 16: Now rearrange the columns in the pivot tables by dragging.

rearrange the pivot table

Step 17: Create another view and drag it to re-position in the compound layout.

reposition the views

Step 18: See the different views in the layout as you want to. You can add many other views and rearrange it in the compound layout accordingly as it want it to view in the dashboard.


Create a graph view

Step 19: Click the floppy icon to save the analysis.


Step 20: In the save as dialog box, open your own folder and save the analysis by providing a suitable name and Click OK.

Saved message will be displayed.

You can view the analysis inside the catalog in the same folder you have saved it.

click okanalysis saved

Step 21: Finally you can view how the analysis will look in the dashboard.

click on preview

Step 22: This is how your analysis will look in a dashboard. So, you have successfully completed your analysis.

see your analysis

Leave A Reply

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