SAP Analytics Cloud Integration

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:

  • time series
  • 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 ServiceTypeEntityFilter
/sap/opu/odata/sap/FRN_FI_DP_SRV/FRUNSeriesSacSetIdDashbaord / IdGadget

 

Common Dimensions

NameDescriptionFilterFRUN

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

NameFilterFRUN

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

  • If gadget's resolution is YEAR => YYYY0101000000
  • If gadget's resolution is MONTH => YYYYMM01000000
  • If gadget's resolution is WEEK => YYYYMMDD000000 (where DD is the 1st day of the week)
  • If gadget's resolution is DAY or below => YYYYMMDD000000

Yes

Date (*)

Day corresponding to one or several data points of a time series, with format: YYYYMMDD

  • If gadget's resolution is YEAR => YYYY
  • If gadget's resolution is MONTH => YYYYMM
  • If gadget's resolution is WEEK => YYYYMMDD (where DD is the 1st day of the week)
  • If gadget's resolution is DAY or below => 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:

Remarks & Additional Information

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.

PeriodRAWHourDayWeekMonthYear

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

Additional Information

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/