Data Layout Options

The bottom of the Data Layout dialog box enables you to specify server-based options in the query:

Option	Description
Default Label Mode	Sets all dimensions using the default label mode to: Descriptions—Current alias table specified by database preferences IDs—Unique ID label Both—When using Oracle Hyperion Financial Management, Fusion Edition, you can specify ID and Description simultaneously
Use Point of View	Enables and disables the active POV definition defined on the current database connection.
Retrieve Only Top/Bottom	Displays the Retrieve Only Top/Bottom dialog box, used to limit and rank the query result set.
Restrict Data	Displays the Restrict Data dialog box, used to restrict the query result set based on criteria.
Show Linked Reporting Object Indicators	Shows/Hides the orange triangle symbols that indicate Related Content definitions in Essbase.
Suppress	Omits components, as selected, from the query result set: 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 Zero Rows—Rows of data comprised of zero data values
Display Entity Currency	When using an Financial Management data source with defined Entity dimension currency information, you can enable the Display Entity Currency option, to append the Entity dimension members with their currency value. This can be set before querying using Data Layout options, after querying using the Data Display shortcut menu, and for all subsequently created documents using OLAP Server preferences. See Financial Management.
Use User Point of View	Selecting it adds a member selection to the Dim Browser for every dimension in the ReportDataSrc. The selected members in the User POV are utilized in the spreadsheet.