“Context” is the designer that limits the data which you’re watching. It is located to the left of the table: You can drag dimensions into context (the same when you do it with columns and rows). Let’s assume we are interested in sales for “Miami”. Drag the dimension “Geography” from the “Dimensions” into “Context”. The […]

The page may contain time dimension in rows, columns or context: Member selector for time dimension will have additional functionality: There are two radio buttons in the upper part of the dialog. If you select “Date Range” option you will have a possibility to set either fixed or floating time period. If you use fixed […]

This designer allows you to set the measures that will be displayed in the table. The picture below displays only one measure – the store sales: Drag the measure “Reseller Order Count” from the list of the measures (to the left) onto the “Measures” designer: As you see, the table has changed its view. Now […]

Virtual Hierarchies Swapping Rows and Columns Data Editing (Write Back) Removing Controls from Rows, Columns and Context Hiding Empty Rows and Columns Grouping of Measures Size of columns/rows Description of a Page Displaying Totals Operation “Drill by” of the Context Menu

The hierarchies can be of several types: regular, attribute and parent-child: In the section 3 of this document we’ve already described the types of hierarchies. Let us look at the table where there are more than one attribute hierarchies: Let us join all the attribute hierarchies into ohe virtual hierarchy by pressing these buttons: As […]

There is a way to quickly swap rows and columns with the help of this button on the toolbar:

This mode allows to edit data in the cubes. In order to edit data it is necessary to have a measure group that supports  the writeback mode. During editing data it is possible to automatically update all the other data after finishing the edit operation:

Each control on designers has a cross icon: By pressing it you can remove the control from the page. The corresponding dimension will not be displayed in the table after you delete its control.

Sometimes it happens that the whole row or column has no data. To prevent the displaying of empty rows and columns on the page you can select the menu items “Hide Empty Rows” and “Hide Empty Columns” in the “Table” menu:

Let us look at the report where there are several measures from one folder: There is a possibility of grouping them. In the menu “Table” select the item “Group Measures”: As a result, the table will become as following: Grouping of measures means to display the folders as captions. Later you can rename and format […]