Power BI dashboards
Snow Optimizer has an OData service that makes various Snow Optimizer data categories available in Microsoft Power BI. You can use this data to create dashboards in Power BI using a template or build your own customized dashboards.
Microsoft Power BI requires full support for the OData V4 protocol. OData V4 is only supported by ABAP NetWeaver systems from Basis Release 7.50 SP04 onwards. Therefore, systems running lower ABAP releases do not provide OData V4 capabilities and cannot be used as a Power BI data source via the Snow Optimizer OData service.
Set up Power BI dashboards
To make the Snow Optimizer data available in Power BI dashboards via the OData service, you have to make the following settings:
- Set up Snow Optimizer OData service at the system level in an SAP system to provide data.
- Release data in Snow Optimizer for the OData service.
- Set up Power BI to import data and create and publish dashboards.
Snow Optimizer data categories
The OData service makes the following Snow Optimizer metadata available:
| Data category | Description |
|---|---|
| ComplianceHeaderSet | The header information of the available compliance evaluation results. |
| ComplianceItemSet | The details of the available compliance evaluation results. |
| RuleSetResultHeaderSet | The header information of the available ruleset execution results. |
| RuleSetResultDetailSet | The details of the available ruleset execution results. |
| NoLogonUserCountForDaysInPastSet | A set of data pairs. The first value of a pair is the number of days in the past, the second value the corresponding (aggregated) count of users with no logon. |
| ContractExpirationSet | A list of contracts with their expiration dates. |
| ProdlicStatusSet | The status of the Snow Optimizer license. |
| TotalsSet | Gives the raw (unaggregated) number of user accounts and data sources (SAP systems) managed by Snow Optimizer. |
| ChargeBackHeaderSet | List of available result headers of user charge back results. |
| ChargeBackLicTypeItemSet | Details of the user chargeback results with the counts of license types. |
| ChargeBackLicTypeCostItemSet | Details of the user chargeback results with the costs for the license types. |
| AuditCounterSet | Number of days until the next SAP audit for your company. |