BI Composer wizard -- Create Analysis: Edit Table panel

This panel is available only if you have added a tabular view to the analysis using the "BI Composer wizard -- Create Analysis: Select Views panel".

Use this panel of the "BI Composer wizard" to:

• Edit the layout of the tabular view (if you have included a tabular view). You can create prompts, use a column to section the analysis, and exclude certain columns from the tabular view.

• Preview the results.

For more information, see:

• "What Is BI Composer?"

• "Creating Analyses Using BI Composer"

• "Editing Analyses Using BI Composer"

This panel is also displayed as:

Edit Analysis Analysis_Name: Edit Table panel

Components

Rows

This target area is available only for a pivot table.

Displays the columns that are to be shown as rows in a pivot table.

Use this target area to modify the way that data is arranged in the pivot table by moving rows to different target areas.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Columns

Displays the columns that are to be shown as columns in a table or pivot table.

Use this target area to modify the way that data is arranged in the table or pivot table by moving columns to different target areas.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Move To

Displays the following options to move a column to a different target area:

• Rows — (This option is not available in the Move To menu in the Rows target area.) Moves the column to the Rows target area.

• Columns — (This option is not available in the Move To menu in the Columns target area.) Moves the column to the Columns target area.

• Prompt For — (This option is not available in the Move To menu in the Prompt For target area.) Moves the column to the Prompt For target area.

• Section By — (This option is not available in the Move To menu in the Section By target area.) Moves the column to the Section By target area.

• Excluded — (This option is not available in the Move To menu in the Excluded target area.) Moves the column to the Excluded target area.

Additional Layout Options

Use this option to display the following target areas Prompt For, Section By, and Excluded.

Prompt For

Displays the columns that are to be displayed as prompts.

Use this target area to move a column to another other target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Section By

Displays the columns that are to be to used to divide the table or pivot table into sections.

Use this target area to move a column to another target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Excluded

Displays the columns that are to be excluded from the view.

Use this target area to move a column to another target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Up and Down Arrows

Use these buttons to reorder the columns in the target areas.

Preview

Use this box to specify whether to display a preview of the results:

• Select this box to display a preview of the actual analysis and data.

  
  

  Note: Selecting this box might impact performance if the query for data results in very large data sets.

  
  

• Deselect this box to display an image that represents each view in the analysis.

Show how results will look on a dashboard

Use this button to show a fully interactive view where you can page through large result sets, drill, and so on.

Report XML

Use this button to show the XML code for the analysis. This information is helpful for debugging purposes.