Web Analysis documents display in data objects the data values returned from data sources. A document can have multiple data objects, and data objects have a display type:
Spreadsheet
Chart
Pinboard
SQL spreadsheet
Freeform grid
You can review all display types, but you can create spreadsheets and charts only by using the new document wizard.
To create a document you are required to specify:
Data source—provides data values
Data object—displays these values
Query—gets data values from the data source and returns them to the data object.
Properties customize each of these elements.
The database connection wizard specifies the type of data source, logon credentials, database applications, dimension formatting and drill-through properties.
Each data object can be set to a display types that features specific formatting options.
Queries can be explicit, requesting information on particular dimension members, or dynamic, requesting information about any dimension member that satisfies a set of criteria.
You have two document creation options:
Use the new document wizard
Modify Web Analysis documents and save them under new names or to new locations