Step 1: Sign in to Cloud by proving your username and password & click on Sign In.
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.
Step 4: Then select the subject area on which you want to perform analysis on.
Step 5: Select the columns from the criteria tab and drop it in the selected column area.
Step 6: Now you can sort a column using the more options(the gear icon).
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.
Step 9: You can see the filters in the filter area in the criteria tab.
Step 10 : Click on the 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.
Step 12: Click on the ‘X’ to remove the view from the compound layout.
Step 13: Click on the new view button to add a pivot table to the compound layout.
Step 14: In the Pivot table click on the view properties.
Step 15: In the properties dialog box change the data viewing to content paging and checking the enable alternate styling and click OK.
Step 16: Now rearrange the columns in the pivot tables by dragging.
Step 17: Create another view and drag it to re-position in the compound layout.
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.
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.
Step 21: Finally you can view how the analysis will look in the dashboard.
Step 22: This is how your analysis will look in a dashboard. So, you have successfully completed your analysis.