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¶
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¶
*** 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
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
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.