The OData interface allows to publish any Focused Insights metrics (SAP Solution Manager or SAP 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 | 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 6 additional dimensions which depend on the data provider selected during the OCC query configuration. The specific dimensions have the following generic names: DIMENSION1, DIMENSION2, DIMENSION3, DIMENSION4, DIMENSION5, DIMENSION6 (as of FRUN 3.0 FP03)
The general authorization concept described in the SAP Focused Run Expert Portal (Dashboard Authorizations) applies to the technical user (e.g. Communications Data) that can be used to configure the OData Connection on SAC Tenant.
Assign roles according to the least privilege principle, that is, define and assign only those roles that are explicitly needed, and nothing else.
Required roles are any display role mentioned in the "Dialog User Roles with Application Authorization" section of the SAP Focused Run Security Guide, depending on the Data Provider/use case used in the queries.
A dedicated role (e.g. SAP_FRN_CNW_ACCESS) must be also used to enable and restrict access to specific customer namespaces.
The graphical renderers used in the OCC gadgets data don't influence the content exported by the FINS2SAC interface, only the OCC query definition matters. If a value is too long to fit in a SAC dimension (more than 256 characters), it will be automatically truncated by the FINS2SAC interface, see also SAP Note 2651610.
| Period | RAW | Hour | Day | Week | Month | Year |
|---|---|---|---|---|---|---|
Hours | Available if hour <= 2 | 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/