Menus in BIPLUS

BIPLUS right click menu allows several tools which user can used. Following images shows menu and its options.

Some of the tools in this menu are already covered in documentation section. Lets see those which are not covered.

Summarize allows user to view summary of selects cells. This tools is specially for Table Reports. To use this tool just select the cells for which you want summary then right click and click on Summarize. A pop-up screen will display a summary of the highlighted rows in the report showing the 5 common aggregations for the highlighted cells. An aggregation is the sum, average, minimum, maximum or count of the selected items (members of the group to be aggregated). If applied on multiple column then separate summary is shown for each column.

Search tools allows you to search a keyword in the report. To search for a certain string (i.e. name, product, city etc.) inside a report, right click in the report to invoke the search dialog box. Inside the dialog box the search can be refined by:

• Selecting which column to search;
• Checking inside the buttons of the match case and/or match whole words and/ or sounds like;
• Nominating where to search either before or after the current cursor position by checking the up radio button for before and the down radio button for after.

To invoke the filter dialog box, right click in the report or click the filter icon. To add various filter elements, click on the add button which will open up a filter line. The columns for which the filter is to apply will be available from a drop down combo. Select an operator to apply to a column by clicking the one chosen and tab to the next criteria to filter by. Following image shows that after applying filter how filter data is displayed.

To sort the data into ascending of descending order within a column click on the column header and an up arrow will invoke an ascending sort and the down arrow will invoke a descending sort. For a more detailed sort within a report, right click in the report to invoke a sort dialog box. Click the add key to open the criteria sort by line and select the criteria to be sorted and nominate whether the criteria is to be sorted in ascending order or descending order.

Note: Unlike Excel, where there is a limit of only 3 columns to be sorted at once with in the report, BIPLUS has no limits as to how many columns to sort on.

Customize View allows you to do some changes in reports column like, Hiding, Renaming, Width adjusting and Sorting. Right click in the report to invoke the Customize View dialog. Below image displays that how table report looks like after applying Customize view. We have given new name to few columns. We are also hiding two columns SHIPCOUNTRY and FREIGHT and sorting ORDERDATE column.

Layout options changes according to report type. The most common used is Display Type for chart report. To change the display type right click in the report to invoke the drop-down list. Select layout then select change display type.

Refresh report refreshes the report and fetches new data from server if any.