Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus 11g Release 1 (11.1.1) Part Number B40105-01 |
|
|
View PDF |
Use this dialog to specify the page item values you want Microsoft Excel end users to specify when they open the current worksheet exported to Web Query (*.IQY) format. For example, if you export a worksheet with a Year page item, you might want Microsoft Excel end users to specify the year they want to analyze. If you do not prompt Microsoft Excel end users for page item values, they always see data for the current page items displayed in the worksheet.
Note: This dialog is displayed if you select Web Query for Microsoft Excel 2000+ (*.iqy) as the export type and select the Page Item Values check box on the "Export Wizard dialog: Format and Name page".
For more information, see:
"About exporting worksheets to Microsoft Excel Web Query format"
Page Items
Use this list to specify the page items you want Microsoft Excel end users to specify a value for when they open Web Query file.
Select
Use check boxes in this column to select and deselect page items. Select the check box to prompt Microsoft Excel end user for a value for that page item. Clear the check box to always see data for the current page item displayed in the worksheet.
Page Item
This column shows the name of the page items in the current worksheet.
Worksheet Name
This column shows the name of the worksheet that contains the page item.
Note: This column is only displayed if you export an entire workbook.
Select All
Use this button to select all page items in the list.
Select None
Use this button to deselect all page items in the list.