OLAP server preferences set features of the OLAP server from Web Analysis Studio.
OLAP Server Preferences | Description |
|---|---|
Suppress | Omits components, as selected, from the query result set:
|
Show Linked Reporting Object Indicators | Enables and disables the display of LRO icons (triangles). |
Display Entity Currency | When using a 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 your 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. |
Save Filters only for User POV | User POV enables users to select members in Filters, Pages, Rows, and Columns (Data Layout and/or member selection controls) and applies them to multiple Web Analysis documents. All Subscription controls have Save Selection as a User POV option. A selection is saved as a filter to the User POV. |
Essbase imposes a maximum limit of 256 columns. Web Analysis Studio sets a column limit of 50,000 data cells for a query. There is also a query governor that enables you to set limits on the number of cells returned by a query; the default is also 50,000 data cells.