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:

  1. If you have not already done so, invoke the View Designer (see Launching the View Designer.
  2. 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 Business Intelligence Answers.

  3. In Display Style, select a View Type and Display Style option from Table 19-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 BI Answers.

    Table 19-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
  4. Continue the view design process by following the procedure in Defining the View Layout.