- Working with Oracle Smart View for Office
- Smart View and Oracle Analytics Cloud
- Working with Views Using the View Designer
- Defining the View Type and Display Style
Defining the View Type and Display Style
When you are creating a view, you define the view type and display style. This is done only once, during the view creation process. Once the view is created, you cannot edit these two settings.
To define the view type and display style:
- If you have not already done so, invoke the View Designer (see Launching the View Designer .
- In View Type, select the type of view that you are creating:
-
Table
-
Pivot Table (the default)
-
Line Graph
-
Bar Graph
-
Column Graph
-
Area Graph
-
Pie Chart
-
Scatter Chart
-
Stacked Column Graph
The selection that you make affects the options available in Display Style along with the fields in the layout area.
Note:
You cannot change this selection when editing the view either in Oracle Smart View for Office or Oracle Analytics Cloud.
-
- In Display Style, select a View Type and Display Style option from Table 18-1.
Display style determines how the view is inserted into Excel.
Note:
You cannot change this selection when editing the view either in Smart View or Oracle Analytics Cloud.
Table 18-1 View Type Selected and the Display Style Available
View Type Selected Display Style Available Table
Excel Table
Table
Pivot Table (default)
Excel Pivot Table (default)
Pivot Table
Line Chart
Bar Chart
Column Chart
Area Chart
Pie Chart
Scatter Chart
Stacked Column Chart
Excel Chart
Chart Image
- Continue the view design process by following the procedure in Defining the View Layout .