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

Option “Show Parent Elements” Option “Display Mode”

If you want to see for each element its parent elements, you don’t obligatory need to include the parent elements into selection. You can use the option “Show Parent Elements” on the tab “Options” of the member selector form: If you select this option, you will be able to set up the topmost level of […]

On the “Options” tab there is one more useful option – possibility to display properties of elements in the table. Select any set of goods in the member selector, for example: Open the “Options” tab. Select the radio button “Advanced”:   Find the property “Standard Cost” and add it to the list of displayed properties, […]

You can select the necessary items with the help of context menu (opens with the right mouse button) in the table: We invoked the popup menu for the “Bikes” item on the picture. Let us look at every possible action. The action “Show By” changes the structure of the table. Therefore we will look at […]

Operation “Drill down” makes so that the selection goes inside the element on the deeper level. If we apply it for “Bikes” we will see all product subcategories which belong to the “Bikes” category: Operation “Drill Up” is the opposite one to “Drill Down”.

Operation “Hide Item” hides the item from the selection. If we apply it to the “Road Bikes” (as it is shown on the picture): the element will disappear from the table: In order to show all hidden elements under “Bikes” you need to select the item “Show All Children” for the “Bikes” element: After that […]