Data Export to Excel, PDF Saving the Pages to NRP file

To export pages data to the Excel or PDF file, you’ll need to perform one of the next actions: Select “Table / Export to Excel” (Word or PDF)» from the main menu; Press the right mouse button inside the table to call the context menu and then select “Export to Excel” (Word or PDF): When […]

NRP is a file format developed for compact and secure report saving. There is a special NRP files viewer available on the pages of Business Analytics Technologies portal: After downloading and installing this viewer you will be able to view NRP files, just the way you do it with PDF, Excel. To save your page […]

Detailed View (Drill Through operation) Data Highlighting Text Formatting Using Advanced Designers Calculated Members Gauges Other Report Page Types Treemap Scatter-diagram Map Dashboard

Drill through (detailed view) enables you to view the piece of data from DB that some value from the table is based on. Let’s perform the drill through operation on our example report page. Select an arbitrary cell from the table on which you wish to perform a detailed view. Now press the right mouse […]

Highlighting helps you to better analyze data. Let’s prepare the table of the next structure: On the rows – “Product Categories” dimension with a whole “Product” level selected under the “Touring Bikes” element: on columns – years 2017 and 2018. Inside the table – “Reseller Sales Amount” measure. Say, we need to emphasize somehow the […]

Apart from highlighting there exists a possibility to «paint» the text on rows, columns and inside the table. To do that select «Table / Formatting» in main menu or the similar item in the table’s context menu. The following form will appear: You can do the same thing from the context menu of the table: […]

Each hierarchy has a set of settings for automatic coloring of its levels. Let us look at the example. Click the right mouse button on the hierarchy “Product/Product Categories” and select “Formatting”: In the window below let us set up the following parameters for the level “Product Categories”: The table will look like this:   […]

For every level of the tab “Hierarchies” you can set up parameters of the body and the header. Let us look at the example: Let us select the following parameters on the tab “Header”: Set us “Apply header formatting to body”: As a result, the table will look like this: If we increase the height […]

Let us look at measure formatting: There is one more tab “Representation” in the dialog where you can set set the number of digits before the decimal point, the currency symbol, the color and the font parameters for the measure. Let us set up the following parameters for the “Reseller Sales Amount” measure: The table […]