Skip to content

Analytics Report Generator Elements

The analytics report generator adds features to let users quickly and without advanced knowledge of tools like Power BI create charts based on Power BI datasets. This feature can be turned off using the system parameter "Comma separated list of disabled features".

When using a layout with more than 1 visual the slicing of the data works the same as it does within Power BI, meaning that if you select a dimension member in one visual the other visuals will slice the data based on the selection.

To be able to use this feature the Power BI Service and the Performance API (BUSMOD) Service need to be installed and configured (part of IFS Advanced Analytics).

Analytics Report Generator properties

image-20210720083123352

Element Layout and Information

The element layout and information properties sections work the same as for the other elements.

Data

Name Description
Workspace This property is used to filter the contents of the Dataset selector. The dropdown shows all the available workspaces the environment has access to. Selecting one will cause the Dataset selector to only show datasets contained in the selected workspace. This property does not need to be set before a dataset can be selected. If the Dataset selector is used first, the Workspace property will auto populate with the workspace which contains the selected dataset.
Dataset The Power BI Dataset to use for this visual, it is only possible to use data from one dataset for a report.
Layout The layout determines the number of visuals that can be placed on the report and the positioning of the visuals.
Add new visual Can be used to add a new visual to the report, see Adding / editing a visual
VisualsTable -> Visual Name The name of the visual, this is also used as the title of the visual when Visual Format Properties -> Title is turned on.
VisualsTable -> Layout position The position this visual will be showed on, the locations are visualized in the preview section.
VisualsTable -> visible / hidden It is possible to define visuals that are not shown on the report, visuals are not shown when the layout position is set to the empty string or to a position that is outside the available positions of the layout, in these cases this column will show "Hidden" instead of "Visible".
VisualsTable -> ... -> Edit Edit the visual of the selected row.
VisualsTable -> ... -> Delete Delete the visual of the selected row.
Add Date Filter See Power BI Element Data properties -> date filter
Add Dimension Filter See Power BI Element Data properties -> Dimension filters

Adding / editing a visual

image-20220216152059892

*** Visual configuration properties***

Name Description
Choose The Visual Type The type of chart
Visual Title The title that will be shown when visual format -> Title is turned on
Position At Layout Block The position this visual will be showed on, the locations are visualized in the preview section.

Visual Fields properties

image-20220217161002822

Name Description
Drop zone's For each Power BI Data Role of a visual a drop zone is created, where Power BI Data Fields can be dropped on, dropping a field from the All data fields section on the drop zone will bind the data field to the data role, meaning that the column will be used for example to show on a axis or tooltip. This list is created dynamically based on the information that is retreived from the Power BI Authoring API.
All data fields Here a list of all columns and measures are shown per table available in the dataset, these fields can be bound to the data roles by dropping them on the drop zones as described above.

Visual Format properties

image-20220216153243998

Name Description
Title Bound to the Power BI property title, indicates if the title needs to be visualized in the chart.
Legend Bound to the Power BI property Legend, indicates if the legend needs to be visualized in the chart.
Tooltip Bound to the Power BI property Tooltip, indicates if a tooltip needs to be shown when a user hovers over a chart (data point).
Data Labels Bound to the Power BI property Data Labels, indicates if the data labels needs to be shown in the chart.

Known Limitations

It's currently not possible to create visuals or specify date and dimension filters for Power BI reports connected to SQL Sever Analysis Services Datasources running in SSASNoRls or SSASWithRls mode.