How to Open the Report Report Pages

There are two ways to open your report: By pressing the button on the toolbar: By selecting the item from the main menu “Workbook/Open”: The standard dialog window will appear where you should find the workbook file. When the report opens you will be able to see it on a separate tab: You can generate […]

Each report consists of several pages. To understand better what is the report page, let us recall how Excel document looks like: each page has a table with data. Pages are displayed as tabs in the bottom part of the window: You can add any number of pages to any report. Next sections of this […]

Basic Navigation on the Page Member Selection Selection in the Table Change of the Page Structure Measures Designer Other Operations Changing the Page Structure Data Refreshing on the Page Quick data formatting Charting

To demonstrate the page navigation let’s open the report based on a test database of the retail sales: We can see the product families on rows and quarters of the year on columns. Inside the table the total amount of sales is displayed. The items which are in rows and columns (products, time, etc) are […]

Manual Member Selection Searching Filtering of Selected Elements Sorting of Selected Members Additional options

There is a possibility to set arbitrary selection of the items not only by levels, but also with the help of this button: If you press it, you will get the member selector dialog. In this window there will be selected all those items which are displayed in the table: You can see the whole […]

In the member selector form you can search for necessary members: The button “Show Search / Hide Search” below opens or closes the search panel. On the search panel you can set the phrase, the level in the hierarchy where search will be performed (if not specified – the searching will be done on all […]

You can filter those elements which you’ve selected on the tab “Selection”. There is a second tab “Filter” which is used for this. Let us make an example: let us choose all mountain bikes which are in the top 10 by the sum of sales in the first quarter of 2017. In order to select […]

In most of the cases the dimension members are sorted by names, but you can override the method of member sorting. Let us build the following report: In order to set up sorting, open the member selector and choose the tab “Sorting”: There are 3 options here: Do not sort; Sort all levels by a […]