Introduction
The OData interface allows to publish any Focused Insights metrics (SAP Solution Manager or Focused RUN) to the SAP Analytics Cloud (SAC).
To use FINS2SAC interface, the SAC Tenant must be connected to the SAP Solution Manager or the FRUN with the SAP Cloud Connector.
The interface offers dedicated functions to access 3 types of format:
- time series,
- tables content (Solution Manager only),
- datasets.
On the SAC side, models are constructed out of a generic OData connection. The dimensions offered by the FINS2SAC interface can be selected and filtered with the graphical editor, so that only relevant information are sent and to the SAC.
Time Series Interface
Service Name
| OData Service | Type | Entity | Filter |
|---|---|---|---|
| /sap/opu/odata/STDF/SAC_EXTRA_SRV/ | Solution Manager | GadgetSeriesSet | GADGET_ID |
| /sap/opu/odata/sap/FRN_FI_DP_SRV/ | FRUN | SeriesSacSet | IdDashbaord / IdGadget |
Common Dimensions
| Name | Description | Filter | FRUN |
| Dashboard Id | Unique id of the dashboard | Yes (FRUN) | Yes |
| Dashboard Title | Title of the dashboard | Yes | |
| Gadget Id | Unique id of the gadget | Yes | Yes |
| Gadget Title | Title of the gadget | Yes | |
| Gadget Description | Description of the gadget | No | |
| Name | OCC query legend | Yes | |
| Query Number | Position of the OCC query in the gadget, starting from 1 (only visible queries are exported) | Yes | |
| Source | Technical name of the data provider used by the OCC query | Yes | |
| G2Y | Parameter G2Y in the OCC Query àThreshold Green To Yellow | Yes | |
| Y2R | Parameter Y2R in the OCC Query àThreshold Yellow To Red | Yes | |
| Trend | Attribute TREND of OCC query | Yes | |
| Aggregation | Attribute SLA of OCC query | Yes | |
| Value | Value of the data point | Yes |
Common Time Dimensions
| Name | Description | FRUN |
| Resolution | Gadget’s resolution (YEAR, MONTH, WEEK, DAY, HOUR, RAW) | Yes |
| Timestamp (*) | Timestamp corresponding to one single data point of a time series, with format YYYYMMDDHHMNSS
| Yes |
| Date (*) | Day corresponding to one or several data points of a time series, with format: YYYYMMDD
| Yes |
| Week (*) | If gadget’s resolution is WEEK, HOUR, DAY or RAW, this dimension contains the week number of a data point; it is empty otherwise. | Yes |
| Week Day (*) | If gadget’s resolution is DAY or below, this dimension contains the week day number of a data point; it is empty otherwise. | Yes |
| Hour (*) | If gadget’s resolution is HOUR or below, this dimension contains the hour (00-23); it is empty otherwise. Hour under 10 start with character ‘0’ to guaranty correct sorting in the charts | Yes |
(*) If the query doesn’t return a time series (i.e. X-Axis is free text), dimensions Timestamp & Date contain the X-Axis values while dimensions Week & Hour remain empty
Specific Dimensions
FINS2SAC time series interface returns 5 additional dimensions which depend on the data provider and the the OCC Query. The specific dimensions have the following generic names: Dim1, Dim2, Dim3, Dim4, Dim5
The values of specific dimensions come from OCC query data provider’s attributes. They are populated in the reading order, like in the example below:
Table Interface
Service Name
| OData Service | Type | Entity | Filter |
|---|---|---|---|
| /sap/opu/odata/STDF/SAC_EXTRA_SRV/ | Solution Manager | GadgetTableSet | gadgetid |
Common Dimensions
| Name | Description | Filter | FRUN |
| Dashboard Id | Unique id of the dashboard | Not supported | |
| Dashboard Title | Title of the dashboard | Not supported | |
| Gadget Id | Unique id of the gadget | Yes | Not supported |
| Gadget Title | Title of the gadget | Not supported | |
| Gadget Description | Description of the gadget | Not supported | |
| Name | OCC query legend | Not supported | |
| Query Number | Position of the OCC query in the gadget, starting from 1 (only visible queries are exported) | Not supported | |
| Source | Technical name of the data provider used by the OCC query | Not supported |
Common Time Dimensions
| Name | Description | FRUN |
| Resolution | Gadget’s resolution (YEAR, MONTH, WEEK, DAY, HOUR, RAW) | Yes |
| Timestamp | Timestamp corresponding to the beginning of the collected period, with format YYYYMMDDHHMNSS
| Yes |
| Date | Day corresponding to the beginning of the collected period, with format: YYYYMMDD
| Yes |
| Week | If gadget resolution is WEEK or below, this dimension contains the week number of the first week of the collected period. | Yes |
| Week Day (*) | If gadget’s resolution is DAY or below, this dimension contains the week day number of the first day of the collected period. | Yes |
| Hour | If gadget resolution is HOUR or below, this dimension contains the first hour of the collected period (00-23); it is empty otherwise. Hour under 10 start with character ‘0’ to guaranty correct sorting in the charts | Yes |
Column Dimensions
FINS2SAC Table interface returns 20 column dimensions which depend on table content. The column dimensions accept the following generic names: Col01, Col02, …, Col20
The values of column dimensions come from the content of the 20 first columns of the table as it is displayed by the OCC renderer DYNAMIC_TABLE. If the table has less than 20 columns, useless column dimensions remain empty
OCC query attribute SAC_TABLE_MAX_ROW indicates the maximum number of rows to return for the query
Specific dimensions Dim1, Dim2, Dim3, Dim4, Dim5 are available but optional.
Dataset Interface
The Dataset is the data source used by SAC Predictive Scenario. As for the time series & table interfaces, we use a 1:1 mapping between a gadget and a dataset.
Since the dataset contains a variable number of columns (one dedicated column per key figure) the FIN2SAC OData interface must rely on dynamic entity models. It means that one entity has to be generated per dataset/gadget exposed to the SAC.
To expose a gadget, we rely on the existing OCC dashboard flag “Discoverable”. Once an OCC dashboard is marked as discoverable, all its gadgets are automatically exposed to the SAC and the corresponding dataset entities are generated (one per gadget).
SAP Solution Manager examples:
Focused Run Examples:
Service Name
| OData Service | Type | Entity |
|---|---|---|
| /sap/opu/odata/STDF/SAC_EXTRA_SRV/ | Solution Manager | FIDS_[Gadgetname]_[GadgetID] |
| /sap/opu/odata/sap/FRN_FI_DP_SRV/ | FRUN | FIDS_[Gadgetname]_[GadgetID] |
JOBS
Datasets structures are dynamic and should be generated by a jobs in SAP Solution Manager or Focused RUN.
| Jobs Name | Type | Parameters | Filter |
|---|---|---|---|
| /STDF/GENERATE_DYN_ENT | Solution Manager | Gadget ID | NA |
| FRN_FI_GENERATE_DYN_ENT | FRUN | DashboardID / Gadget ID |
SAP Solution Manager
Focused RUN
Time Dimensions
| Name | Description | FRUN |
| Resolution | Gadget’s resolution (YEAR, MONTH, WEEK, DAY, HOUR, RAW) | Yes |
| Timestamp (*) | Timestamp corresponding to one single data point of a time series, with format: YYYYMMDDHHMNSS
| Yes |
| Date (*) | Day corresponding to one or several data points of a time series, with format: YYYMMDD
| Yes |
| Week (*) | If gadget resolution is WEEK, HOUR, DAY or RAW, this dimension contains the week number of a data point; it is empty otherwise. | Yes |
| Week Day (*) | If gadget’s resolution is DAY or below, this dimension contains the week day number of a data point; it is empty otherwise. | Yes |
| Hour (*) | If gadget resolution is HOUR or below, this dimension contains the hour (00-23); it is empty otherwise. Hour under 10 start with character ‘0’ to guaranty correct sorting in the charts | Yes |
Dimensions & Key Figure(s)
| Name | Description | FRUN |
| Dashboard Id | Unique id of the dashboard | Yes |
| Dashboard Title | Title of the dashboard | Yes |
| Gadget Id | Unique id of the gadget | Yes |
| Gadget Title | Title of the gadget | Yes |
| Gadget Description | Description of the gadget | No |
| Group | Name of the group if defined | Yes |
| <Key Figure(s)> * | One key figure per OCC query, it contains the time series values. The OCC query legends without the groups are used as columns names. For example, if the gadget contains 3 queries with legends “Average Response Time”, “Maximum Response Time” & “Number of alerts”, the FINS2SAC interface returns 3 key figure columns “Average Response Time”, “Maximum Response Time” & “Number of alerts”. The columns contain the time series values of the corresponding OCC queries. | Yes |
Remark about Group and Key Figure:
- If the OCC query legend is “Average Response Time”, then the name of the group is empty and the name of the key figure is “Average Response Time”
- If the OCC query legend is “A4H / Average Response Time”, then the name of the group is “A4H” and the name of the key figure is “Average Response Time”
Remarks
The graphical renderers used in the OCC gadgets data don’t influence the content exported by the FINS2SAC interface, only the OCC queries matters.
If a value is too long to fit in a SAC dimension (more than 256 characters), it’ll be automatically truncated by the FINS2SAC interface.See also: https://apps.support.sap.com/sap/support/knowledge/public/en/2651610