Advanced Analytics functionality coverage within TCM v10
The beqom Advanced Analytics feature leverages Sisense, a powerful analytics tool, in order to provide interactive within the beqom application. Sisense provides a very wide functional coverage, and the integration inside beqom does not allow users to exploit all of those features. Only certain features are implemented in the beqom application user interface.
This approach both ensures navigation consistency across the generic parts of the application and excludes the features that have not yet been implemented inside the beqom application.
This document offers a summarized overview of Sisense features and the available of those features per role in the beqom UI (or using the APIs), with a description of the main differences between the use of those features in the beqom UI and in the Sisense UI.
This is an attention message.
This document does not provide an exhaustive list of the Sisense features; the list is susceptible to evolve over time.
This is an note/information message.
The description of the different roles available in beqom for Advanced Analytics, and of the features available for each role, is available in FAQ article Advanced Analytics security roles & role assignment.
Reports, Widgets and Filters
The following table lists the Sisense features, the state of their integration inside the beqom application, if any, as well as their availability per role.
| Feature | beqom UI integration status |
Role Availability | |||
|---|---|---|---|---|---|
| Availability | Description | Viewer | Designer | Super Admin | |
| REPORTS | |||||
| Select a report | Yes | Report list available in beqom Web App, under (Undefined variable: CompoVariables_WA.Analysis) > Advanced Analytics > for all report types |
(missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| View a report | Yes | Viewers can drill in, jump to other reoirts, see all widgets and default filters (as defined by the report owner) | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Create a report | Yes | Available in beqom Web App, under (Undefined variable: CompoVariables_WA.Analysis) > Advanced Analytics > |
(missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Rename a report | Yes | Available in beqom Web App, under (Undefined variable: CompoVariables_WA.Analysis) > Advanced Analytics > | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Clone a report | Yes | Available in beqom Web App, under (Undefined variable: CompoVariables_WA.Analysis) > Advanced Analytics > | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Delete a report | Yes | Available in beqom Web App, under (Undefined variable: CompoVariables_WA.Analysis) > Advanced Analytics > | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Enable the toggle edit mode button | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Change the layout of a report | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Add a text element | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Select the color palette of a report | Yes | beqom recommends to use the "beqom - Ocean" palette | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Share a report with other users | Yes | In beqom it is possible to share a report by profile, in Web App, under (Undefined variable: CompoVariables_WA.Analysis) > Advanced Analytics |
(missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Access the edit script window for a report | Yes | For security reasons, it is reserved to the "super admin" role | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Export a report | No |
|
(missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Change the owner of a report | No | Not planned | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Manage folders in the report hierarchy | No | Not planned | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Restore report to the initial state in which it was shared | No | Not planned | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Copy a report to a different Sisense server | Partial |
Possible using APIs. For more information, see BQM71 - [[[Undefined variable FAQ_Titles.BQM71]]] |
(missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Import a report | Partial |
Possible using APIs. For more information, see BQM71 - [[[Undefined variable FAQ_Titles.BQM71]]] |
(missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Change the data model of a report | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Toggle the data exploration | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| REPORT FILTERS | |||||
| Delete a filter | Yes | Filter design feature | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Edit a filter | Yes | Filter design feature | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Reorder filters | Yes | Filter design feature | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Change the type of a filter | Yes | Filter design feature | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Define default filter values | Yes | Filter design feature | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Set the on/off option | Yes | Filter design feature | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Auto Update option | Yes | Filter design feature | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Save a filter | Yes | Filter design feature | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Use advanced report filters | Yes | Filter design feature | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Expand toggle | Yes | Filter display feature | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| View starred default filter | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Define a starred default filter | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| REPORT WIDGETS | |||||
| View a widget | Yes | * Read-only | (missing or bad snippet) * | (missing or bad snippet) | (missing or bad snippet) |
| Create a widget | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Edit a widget | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Rename a widget | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Duplicate a widget | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Change the type of a widget | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Delete a widget | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Copy a widget into a different report | No | Not planned | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Edit the script of a widget | Yes | Used to manage plug-ins | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Export a widget | Yes |
Export to:
This is an attention message. The password protection parameter defined at system level does not apply to Advanced Analytics widgets. At the moment, it is not possible to export widgets to Excel with password protection. |
(missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Exporting a widget to PDF | No | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Edit filter attributes and options | Yes | Between the slice showing only filtered items in the chart and the highlight showing filtered items highlighted | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Drill-down in a widget | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Pulse notifications | No | Not planned | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Add, edit & delete data fields and values in a widget | Yes | Widget data panel | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Rename data fields in a widget | Yes | Widget data panel | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Reorder data fields and values | Yes | Widget data panel | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Change data types and formats in a widget | Yes | Widget data panel | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Enable/disable data fields | Yes | Widget data panel | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Use predefined hierarchies (such as Sisense dates) | No | Widget data panel | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Edit formulas | Yes | Widget data panel | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Add, edit, save & delete widget filters | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Enable/disable widget filters | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Change the type and layout of widget filters | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Allow widget filters to change report filters | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Allow toggle widget filter panel | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| Use starred widget filters | Yes | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) | |
| PLUG-INS | |||||
| Configure the "Jump to Dashboard" plug-in | Yes | Script edition permission is required | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Blox | Yes |
This is a warning message. The use of this plug-in may impact the performance. This is a warning message. The use of this plug-in may introduce a security risk because it allows SQL injection. |
(missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
| Tabber | Yes | Script edition permission is required | (missing or bad snippet) | (missing or bad snippet) | (missing or bad snippet) |
Data Model Management
Data models are the basis for all Advanced Analytics reports. Authorized beqom users can create data models based on a single view in Web App, under (Undefined variable: CompoVariables_WA_Alternate."Admin") > Data > Reporting Models Advanced Analytics.
This part of the (Undefined variable: CompoVariables_WA.Admin) of the Web App interface enables you, provided that you have the relevant rights, to perform all data model (and data source)- related operations required for the operation of the Advanced Analytics. These activities are fully described in here.
When working on data sources/data models, beqom advises that you observe the following recommendations:
Maximum two Elasticubes should be build simultaneously, a at frequency that does not exceed once every hour (depending on building time)
Following every change to the data model, all reports that use that data model should be tested in the beqom application in order to confirm that they still work properly
The following table lists the features related to data model management and their implementation in beqom (UI/API).
This is an note/information message.
These features are available only for users who have been granted either the "Designer" role or the "Super Admin" role.
| Feature | Description | beqom UI | API/Other |
|---|---|---|---|
| Data model management (Elasticubes and Live Connection) | |||
| Add a data model (Elasticube or Live Connection) |
Available in the the Web App UI, under(Undefined variable: CompoVariables_WA_Alternate."Admin") > Data > Reporting Models > Advanced Analytics This is an note/information message. For Advanced Analytics, the data security is not configured here. |
(missing or bad snippet) | (missing or bad snippet) |
Edit a data model |
Available in the Web App UI, under(Undefined variable: CompoVariables_WA_Alternate."Admin") > Data > Reporting Models > Advanced Analytics | (missing or bad snippet) | (missing or bad snippet) |
| Build/publish a data model | Available in the Web App UI, under(Undefined variable: CompoVariables_WA_Alternate."Admin") > Data > Reporting Models > Advanced Analytics | (missing or bad snippet) | (missing or bad snippet) |
| Cloning a data model | Available in the Web App UI, under(Undefined variable: CompoVariables_WA_Alternate."Admin") > Data > Reporting Models > Advanced Analytics It is possible to clone a data model and change the model type from ElastiCube to Live Connection and vice versa. |
(missing or bad snippet) | |
| Delete a data model | Available in the Web App UI, under(Undefined variable: CompoVariables_WA_Alternate."Admin") > Data > Reporting Models > Advanced Analytics | (missing or bad snippet) | (missing or bad snippet) |
| Create/delete data sets and relations inside a data model |
Data sources management. Available in the Web App UI, under(Undefined variable: CompoVariables_WA_Alternate."Admin") > Data > Reporting Models > Advanced Analytics |
(missing or bad snippet) | (missing or bad snippet) |
| View the definition of a data model | Available in the Web App UI, under(Undefined variable: CompoVariables_WA_Alternate."Admin") > Data > Reporting Models > Advanced Analytics | (missing or bad snippet) | (missing or bad snippet) |
| Validate the export of a data model | * The beqom export feature provides a validation mechanism | (missing or bad snippet) | (missing or bad snippet) * |
| Build a visual data model | It is possible to build a data model from the Web App UI, but there is no schematic view. | (missing or bad snippet) | (missing or bad snippet) |
| Hide/display fields | In the product backlog | (missing or bad snippet) | (missing or bad snippet) |
| Drag-and-drop/add fields | In the product backlog | (missing or bad snippet) | (missing or bad snippet) |
| Create custom data sets (tables, fields, etc.) | (missing or bad snippet) | (missing or bad snippet) | |
| Change column display names | (missing or bad snippet) | (missing or bad snippet) | |
| Connect to data models |
Transparent in the beqom application. Automatically performed Only available for SQL databases |
(missing or bad snippet) | (missing or bad snippet) |
| Change connectivity settings | For instance, change from Live Connection to Elasticube | (missing or bad snippet) | (missing or bad snippet) |
| Share/assign rights to a data model |
Available in the Web App UI, under(Undefined variable: CompoVariables_WA_Alternate."Admin") > Data > Reporting Models > Advanced Analytics Data models can be shared to specific profiles |
(missing or bad snippet) | (missing or bad snippet) |
| Manage drill-down hierarchy | Available in the Web App UI, under(Undefined variable: CompoVariables_WA_Alternate."Admin") > Data > Reporting Models > Advanced Analytics as a colored indicator in the list of data models. | (missing or bad snippet) | (missing or bad snippet) |
| View the status of a data model | (missing or bad snippet) | (missing or bad snippet) | |
| Schedule build (for Elasticubes) | * "Scheduling" possible with ETL process by calling the build API | (missing or bad snippet) | (missing or bad snippet) * |
| Import a data model | (missing or bad snippet) | (missing or bad snippet) | |
| Export a data model | (missing or bad snippet) | (missing or bad snippet) | |
| Execute manual SQL queries to Elasticubes | (missing or bad snippet) | (missing or bad snippet) | |
Other Features
The following table lists the features related to data model management and their implementation in beqom (UI/API).
This is an note/information message.
These features are available only for users who have been granted either the "Designer" role or the "Super Admin" role.
| Feature | Description | beqom UI | API/Other |
|---|---|---|---|
| System management | (missing or bad snippet) | (missing or bad snippet) | |
| Admin page | Access, system configuration, SSO, etc. | (missing or bad snippet) | (missing or bad snippet) |
| Manage Sisense users |
Create, edit and delete users (infrastructure-related permissions) * An automatic mapping between beqom users and Sisense users is performed |
(missing or bad snippet) | (missing or bad snippet) * |
| Manage Sisense groups |
Create, edit and delete groups (infrastructure-related permissions) * Using beqom roles |
(missing or bad snippet) | (missing or bad snippet) * |
| Manage data hierarchies | (missing or bad snippet) | (missing or bad snippet) | |
| Access the data page | (missing or bad snippet) | (missing or bad snippet) | |
| Manage color palette definitions | (missing or bad snippet) | (missing or bad snippet) | |
| Branding | N/A, because of the integration inside beqom UI and color palettes can be customized in the application | (missing or bad snippet) | (missing or bad snippet) |
| Localization | As of today, the only way to provide report localization is to create another report in a different language | (missing or bad snippet) | (missing or bad snippet) |
| Security (data access rights) |
* Managed by beqom by applying the user and profile data security permissions for the logged in user. Also available:
|
(missing or bad snippet) | (missing or bad snippet) * |
| Report usage statistics | (missing or bad snippet) | (missing or bad snippet) |