A wizard guides you through creating Web Analysis Studio spreadsheets and charts. The wizard requires that you know where a database connection is located, and have permission to use it.
To create a document:
Optional: Select Auto-Populate Dimensions to automatically populate and display a simple spreadsheet.
Selecting the Auto-Populate Dimension option and clicking Finish skips the remaining steps in the process. Auto-Populate Dimension uses the highest aggregate members of the time and measures dimensions to populate the rows and columns axes of a spreadsheet. This is the quickest method to display a simple spreadsheet using the wizard.
Optional: Select Use Point of View to populate the query from a predefined point of view (POV) definition.
Selecting Use Point of View and clicking Next inserts the dimensions and members that are of interest to you in documents. You can define multiple POV definitions, but Use Point of View only applies the current POV set in preferences.
Selecting Auto-Populate Dimension and Use Point of View and clicking Finish skips the remaining steps in the process and displays a simple spreadsheet using the active POV.
In Step 2: Select Row Dimension, you must select the dimensions to be used on the Rows axis. You must have at least one Row axis dimension and one Column axis dimension.
Optional: To specify dimension member selections, double-click the dimension name hyperlink in Rows.
The Dimension Browser dialog box is displayed. The dimension is presented as a node tree in the Browse frame. You must select dimension members in Browse and move them to Selections:
To select dimension members, click the dimension member name.
A check mark is displayed in the check box of selected members, and the member name is displayed in the Selections list.
To select dimension members dynamically, right-click a dimension member name and select an advanced member selection method.
You can set the label mode for each dimension to the default label, an ID label, or the alias table description set in Database Preferences dialog box, through preferences.
Click OK to dismiss the Dimension Browser dialog box and return to the Wizard.
After indicating all Rows axis dimensions, and defining their member selections, click Next.
Using the same methods used to define Rows, move a dimension name from Filters to Columns.
Optional: Using the same Dimension Browser methods, double-click the dimension name hyperlink in Columns to specify member selections for the Column axis.
In Step 4: Select Page Dimensions, you can select dimensions to be used on the Page axis. While all intersections in the document are relative to all dimension member selections, you can organize these row and column intersections by page dimension members.
Optional: Using the same methods used to define Rows and Columns, move a dimension name from Filters to Pages.
Optional: Using the same Dimension Browser methods, double-click the dimension name hyperlink in Pages to specify member selections for the Page axis.
In Step 5: Customize Filters, you select dimension members to be used on the Filters axis.
All cube dimensions participate in every spreadsheet intersection, regardless of the axis to which dimensions are assigned. The arrangement of intersections is defined by the Rows, Columns and Pages axes. The data values displayed at each intersection are determined by the member selections.
all intersections in the data object are relative to Filter dimension member selections. Filter dimension member selections focus the intersections, the data values, and consequently the data object analysis.
Cube dimensions left in the Filter axis are by default represented by the highest aggregate dimension member defined in the data source outline. If a POV definition is applied, its member selections are used. If you make Filter member selections, all intersections are relative to these selections.
Optional: To display the Dimension Browser for Filter axis dimensions, perform one:
Optional: Using the same Dimension Browser methods, make Filter axis dimension member selections and click OK.
In Step 6: Set Options, you can set a variety of document options
Optional: In the Select Layout list, select one:
Chart—Displays the result set as a chart data object.
Spreadsheet—Displays the result set as a spreadsheet data object.
Vertical Combination—Displays the result set as a chart data object and a spreadsheet data object stacked vertically.
Horizontal Combination—Displays the result set as a chart data object and a spreadsheet data object arranged side-by-side.
Custom—Displays a blank palette
You can change the display type of the Vertical Combination and Horizontal Combination layouts; for example you can convert the spreadsheet to a chart type. The objects, however, are linked and maintain a coordinated context.
In case you select a layout, the Data Layout dialog box is displayed.
Select dimensions and members and click OK to generate a Web Analysis document.
Optional: You can set the default Label mode to display dimension member IDs, or the alias table description set in database preferences.
This centrally sets all dimensions using the default Label mode to the same setting.
Optional: To suppress the display of one or more type of data, click the corresponding check box.
Missing Columns—Columns of data comprised of missing values.
Missing Rows—Rows of data comprised of missing values.
Shared Members—Dimension members that are used in multiple locations of one hierarchy.
Optional: To suppress the display Linked Reporting Object Indicators, click the corresponding check box.
Linked Reporting Object Indicators are orange triangles indicating Related Content definitions in Essbase.
Optional: To augment the query with a server-based Retrieve Only Top/Bottom analysis, click the corresponding button.
Optional: To augment the query with a server-based Restrict Data analysis, click the corresponding button.
See Restricting Data.
Click Finish to submit the query to the data source.
The data source is queried. The result set returned is displayed as a data object on a document.
, and select