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 Focused Run system with the SAP Cloud Connector.
The interface offers dedicated functions to access two types of format:
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.
| OData Service | Type | Entity | Filter |
|---|---|---|---|
| /sap/opu/odata/sap/FRN_FI_DP_SRV/ | FRUN | SeriesSacSet | IdDashbaord / IdGadget |
| 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 |
| Name | Filter | 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.
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:
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 SAP Note 2651610.
| Period | RAW | Hour | Day | Week | Month | Year |
|---|---|---|---|---|---|---|
Hours | Unavailable | Available if hour >72 Default hour = 72 | Unavailable | Unavailable | Unavailable | Unavailable |
Days | Unavailable | Available If day > 31 Default day = 31 | Available If day > 366 Default day = 366 | Unavailable | Unavailable | Unavailable |
Weeks | Unavailable | Unavailable | Available if Week (1<52) Default week = 52 | Available if Week (1<52) default Week = 52 | Unavailable | Unavailable |
Months | Unavailable | Unavailable | Available if Month (1 < 12) Default month = 12
| Available if Month (1 < 12) Default month = 24 | Available if Month (1 < 12) Default month = 24 | Unavailable |
Years | Unavailable | Unavailable | Available if Year (1<) Default year = 1
| Available Year (1<3) Default year = 3 | Available Year (1<10) Default year = 10 | Available |
This link provides you with the information on how to build compelling SAC Story with https://blogs.sap.com/2019/01/11/access-any-focused-insights-metrics-from-sap-analytics-cloud/