You preview a query to confirm that it returns the expected results. When you preview a query, a syntax check is performed and errors are reported.
For new report worksheets, the number of columns required in the report is the same as the number of columns in the preview table. The number of columns depends on the hierarchy level of the dimension members specified in the query definition.
You can preview a query while creating it, and you can preview an existing query. You can preview the query by using base data in Integrated Operational Planning or by using scenario data.
To preview or edit a query:
In the Administration Workbench, go to the Presentation tab and select Queries.
To search for a query, enter text in the text boxes above the columns and click Enter. To cancel the query, clear the text boxes and click Enter.
Click Preview and select whether to preview the query against base data in Integrated Operational Planning or against scenario data.
If you preview the query using scenario data, select a scenario from the menu. If no names are displayed, no scenarios exist in the In Progress or Submitted state.
A separate browser window opens to display the query definition and syntax errors.
Correct errors in the query definition, and then click Preview to confirm your corrections.
Each time you preview the query, a browser preview window opens. If no errors exist, the query runs and a table of results is displayed.
Considerations when previewing a query:
Depending on the query, it may take time to retrieve results from the Integrated Operational Planning database. Keep the preview window open until the query finishes running.
MDX queries pause during preview whenever a Parameter(...) statement is encountered in the query definition. A dialog box opens, prompting you to enter a value for the parameter. Enter a value and click OK.
For example, if the parameter represents a dimension member name, enter the fully qualified dimension member name in the form dimension name/namespace name/member name; for example, Manufacturing/MY 2004/August.
RSQL queries pause during preview each time the variable “?” is encountered in the query definition. A dialog box opens, prompting you to enter a value to substitute for the “?” variable. Enter a value and click OK.