Ranet OLAP Pivot Table Commands

Ranet OLAP Pivot Table Commands

Ranet OLAP pivot table toolbar includes the following commands: Command Description Refresh Runs the current MDX query and shows the result. Navigate To Begin Navigates to the beginning of the pivot grid query history. Navigate Backward Navigates one item back in the...
Ranet OLAP Find Tab

Ranet OLAP Find Tab

Find tab is a visual element used to determine search parameters. It is a tree comprised of operations and operands. The operand is a list-type node of the tree. Each operation can be comprised of child operations and operands. The operation is a node determining the...
Ranet OLAP MDX Designer. Change Filter

Ranet OLAP MDX Designer. Change Filter

Change filter command in the MDX Designer calls a filters setup dialog allowing to modify the filter, where a list of elements included in the report is determined. Filter Type: Label Filter Value Filter Top N All three types of filters are shown in the figures...
Ranet OLAP Pivot Grid. Show MDX Query

Ranet OLAP Pivot Grid. Show MDX Query

The Show MDX command displays the MDX query generated as a result of design, or prepared manually by the user, in a special window. If the query contains more than two axes it can be converted into a typical query containing two axes (rows and columns). Often it is...
Ranet OLAP Pivot Grid. Drill Through

Ranet OLAP Pivot Grid. Drill Through

OLAP is great for aggregating data and hiding all of the database details. There are times when you want to know where values in some OLAP cells come from. Drill Through lets you retrieve the underlying rows in the database that give the cell its value. The OLAP...
Ranet OLAP Pivot Grid. Cell Properties

Ranet OLAP Pivot Grid. Cell Properties

Properties and Custom Properties commands show properties of a dimension member or cell, and their current values, in a special window. For a cell, it can display system properties and cortege structure (Tuple) with the current values. For a dimension member, both...
Ranet OLAP Pivot Table. Show Properties

Ranet OLAP Pivot Table. Show Properties

Ranet OLAP pivot table Show Properties command is called from the context menu in the row area. It can display properties of the dimension member in the table. With this command, it is possible to show or hide all dimension properties at once or show or hide...
Ranet OLAP Pivot Grid. Members group

Ranet OLAP Pivot Grid. Members group

Ranet OLAP pivot grid Members group mode includes commands that allow grouping data in the pivot grid table. Members in the row area and column area are grouped. The following grouping options are available: (None) - the data are not grouped, only the MDX query result...
Ranet OLAP Pivot Table Sorting Option

Ranet OLAP Pivot Table Sorting Option

Ranet OLAP pivot table sorting option includes commands for sorting data in ascending and/or descending order. Users can additionally configure sorting parameters. Sorting can be applied to a row area, column area, or data area in the pivot table. Sort Options allow...
Write US