SAP Analytics Cloud Integration

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 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

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 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)

Authorizations

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.

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 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.

PeriodRAWHourDayWeekMonthYear

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