This mode allows to edit data in the cubes. In order to edit data it is necessary for administrator to allow this functionality for the user, and 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 […]

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 […]

You can set the size of columns / rows on pages of the Table type. To do this, select “Set Size of Columns / Rows …” from the “Table” main menu: This submenu allows the user to specify the same width for all columns and the same height for all rows of the table:

For any report you can create a description using any text, used hierarchies and RTF formatting. Let us look at the example: In the “Table” menu select the “Report Page Description”: In the left part there is a list of hierarchies which are used on the report page. Using the mouse drag some hierarchies into […]

In order to explain what is “Visual Totals” let us build the following report. On the rows we will place the “Product Categories” hierarchy with the following selection: On the columns let us place the years from the “Date.Calendar” hierarchy. Inside the table – the “Reseller Order Quantity” measure. You will get the following report:

You can add summary rows and columns to the report. These rows and columns will show the SUM of the elements on the topmost visible level in the report. In the “Table” menu select the items “Show Summary Columns” and/or “Show Summary Rows”: Then you will get the following report: As you may see, in […]

In the sample report (above) you can see that the row with “Clothing” there is a total of all kinds of clothing, but NOT just 2 selected elements (“Caps” and “Jerseys”). In order to see the totals for only visible elements, you have to select “Show Visual Totals” item in the “Table” menu: If you […]

In the context menu there is an operation “Show By”. Let us look at the example. Assume you have a report of the following structure: Let us do the “Show By” operation in order to look the sum of sales for a specific product (for example, for “Road Bikes”) by all countries. Select menu items […]