Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

(warning) This wiki page is in development and is not yet complete. Any 'white space' simply means the wikis' author has not yet validated if that feature is supported or not.

(warning) The purpose of this wiki page is to collect information from various official sources and present them together here in one holistic view. Where possible official references will be mentioned.

(warning) Thus, information here is not to replace anything from official System Requirements page or official documentation, nor will any information held here overrides anything mentioned in the official System Requirements or official documentation. Official source information ALWAYS overrides anything mentioned in this wiki.

(warning) Caution is always used before an entry is made. The wikis' author has gone to great lengths to ensure it is accurate and up-to-date, however mistakes are made!. Nevertheless, in general, this wiki should be considered accurate and up-to-date. Any corrections needed are welcome to ensure its accuracy.

 

Models

Live Model Support

 SAP Cloud PlatformOn Premise (or SAP HEC)Reference page(s)Comments
HANA v1

(tick) (C) (D)

(tick) (A) (C) (D)

 
HANA v2(error) (D) (E)(tick) (A) (B) (D)  

BW

  • SAP BW running on any DB
  • SAP BW running on SAP HANA
  • SAP BW/4HANA

 

 

n/a

(tick)

  1. Support Matrix for SAP BW
  1. SAP Note CDS Transient Provider: CX_RODPS_OBJECT_NOT_FOUND shows additional requirements on BW
  2. Supported versions:

    1. SAP BW 7.5 SP8+ (recommendation)

    2. SAP BW 7.4 SP17+

    3. SAP BW/4HANA SP4+

    4. Latest correction notes must be applied for the versions listed above. See SAP Note 2541557.

  3. SAP Note 2541557 also contains additional information on the following:

    1. Support versions prior to SAP BW 7.5 SP8

    2. Support versions of SAP BW 7.51 SP2+ or SAP BW 7.52

    3. Support versions prior to SAP BW 7.4 SP17

  4. Can connect to ABAP-based CDS queries (these can also be acquired using the BW acquisition connector)
BPCn/a   
S/4

(tick)

(tick)

 
  1. A single SAP Analytics Cloud story can not display a visualisation from a BEx Query based off a CDS View, AND a visualisation from a BEx Query based off a HANA calculation view. Its one or the other, not both at the same time within the same story.

Universen/a(tick) 
  • Universes are hosted within on-premise software. The on-premise software can be hosted in the Cloud with a supported IaaS provider.
  • (A) If using choropleth layer when working with geospatial models you must download and import the new version of the delivery unit, SPATIAL_DATA-1.1.6.tgz. Access to this delivery unit requires an SAP HANA Spatial license.
  • (B) HANA 2.0 is supported for On-Premise: SAP HANA 2.0 SP01 or newer. Recommended HANA 2.0 SP2 rev 024.05 or higher) with the SAP HANA EPMMDS plugin. SAP Note 2456225 and SAP Note 2444261 provide additional setup information.
  • (C) for HANA 1.0 recommended to use SPS12 revision 122.14 or higher (to benefit from blending and other capabilities such as Aggregation Calculations (avg, count, min/max), Time Calculations (Previous Year/Quarter/Month, Year/Quarter/Month To Date.'Difference From'), Variances(Time,  Version and Measure), Blending (see below))
  • (D) can only consume HANA Calculation Views. A HANA based CDS view requires a HANA Calculation View to be created on it.
  • (E) HANA 2.0 is not currently supported for SAP Cloud Platform (support is planned. Please refer to public roadmap)

Related and useful references:

  1. Error "Failed to connect to system in SAP Analytics Cloud" when defining a live connection - KBA 2544696

Live Model Connection Support

 Browser (desktop)Mobile AppHTTP
 ConnectionAuthenticationConnectionAuthenticationProtocol
 TypeUsername and passwordSSOTypeUsername and passwordSSO 
HANA (on premise)

Direct (tick) (B)

(tick)SAML (tick)Direct (tick)(tick)SAML (tick)1
HANA (SAP Cloud Platform)

Cloud (tick)

(tick)SAML (tick)Cloud (tick)(tick) (G)SAML (tick)1
BW (on premise)

Direct (tick) (A)

(tick)SAML (tick)Direct (tick)(tick)SAML (tick)2
BPCDirect (tick)(tick)SAML (tick)   1
S/4 (on premise)

Direct (tick) (F)

(tick)SAML (tick)

Direct (tick)

(tick)SAML (tick) 
S/4 (Cloud)Cloud (tick) (F)(error)OAuth (tick)Cloud (tick)(error)OAuth (tick)1
UniverseDirect (tick) (C) (D)(tick)SAML (tick) (E)Direct (tick) SAML (tick)1
  • A) requires BW 7.52 onwards. See blog
  • B) The SSL server certificate of the HANA XS system must be a valid one that is trusted by your users’ web browsers (see SAP Note 2502174 for details)
  • C) required BI 4.2 Support Pack 4 or greater
  • D) the web application server fronting the SAP BI Platform must be configured for SSL
  • E) SAML setup required on BI Platform. Each user must have an enterprise alias.
  • F) previously this was not supported, though it is now. The documentation may appear to limit this to PATH only, however DIRECT connection is also supported
  • G) Option to 'Save this credential for all users on this system'

 

Reverse Proxy Support

Requirements for all direct connections

  • Communication from the browser to the database must use HTTPS and thus the browser must trust the SSL certificate being used. Some organisations have special policies around the use of which Trusted Authorities can be used.
  • The browser must support 3rd party cookies
  • The browser must allow pop-ups

Limitations to SAP HANA and SAPCP Live Data Connections

 

Useful or related articles

  • HANA On Premise: InA role missing after HANA update SAP Note 2315536

Live BW Support

BW featureSupported in SAP Analytics Cloud
TableHierarchy - Show node above(tick)
Table/ChartDisable dynamic variables (customer/BW exit variables)(tick)

 

Requirements https://launchpad.support.sap.com/#/notes/2541557

Live BPC Support

BPC featureSupported in SAP Analytics Cloud
workstatus(tick)
Disaggregation(tick)
Formula(tick)
Cell Locking(tick)

 

Live Universe Support

SAP Analytics Cloud Wave and Live Universe Connector Support Matrix
Live Universe Connector VersionSAP Analytics Cloud Wave 14 on onwards

Version 1.04 (v1 SP4)

(error)
Version 1.05 (v1 SP5)(tick)

Version 1.06 (v1 SP6)

(tick)
Version 1.07 (v1 SP7)(tick)

KBA 2492800 Version 1 SP5 Release information and download

Acquired Model Support

Acquired Model Scheduling Support

 Import ScheduleExport ScheduleReference Page(s)Comments
Universe(tick)(error)  
CSV, Excel(tick)(tick)
  1. Blog on how to setup the Agent for scheduled imports
  • (A) The agent requires a small configuration change.
  • (B) Importing directly through the web browser is also supported, however only schedule imports can be made via Agent
Odata Cloud(tick)   
Odata on-premise(tick)   
HANA via OData(tick)?  

Expose as an Odata source, then consume the odata source in SAC https://help.sap.com/viewer/b3d0daf2a98e49ada00bf31b7ca7a42e/2.0.02/en-US/d6b3fe1a380f45e6b8845744dd77a540.html

HANA via JDBC(error)(error)  
SAP S/4HANA(tick)(tick)  
BPC(tick) (Planned)(tick) (Planned)  

SAC Agent requirements:

  • SAP Cloud Connector must be installed and configured on premise. Blog on how to setup the SAP Cloud Connector
  • If running the SAC Agent as a windows  services, then Environmental variables may not be read if the service runs as 'Local System Account', so for the properties path either start the service as a user (rather than Local System) or use the '-D' parameter.

Acquired Model Combining Data Support

(warning)This is a planned feature and is not currently available

FeatureValue
Join typesLeft outer, inner
Maximum data sources5
Maximum cells (in all the data to be joined)30 million

Support by Connection (also shows 'Live' with 'Import Data' comparisons)

Modelling Supported Features

 Live ConnectionsImport Data Connections
 HANABWBPCS4Universe 
Planning Models(error) (error) (tick) (error) 
Single Date Dimension(tick)   (warning)(tick)
Multiple Date Dimensions(tick)    (tick) (C) (Planned)
Parent-child hierarchy on Dimensions(tick)(tick)  (error)(tick)
Level-based hierarchy on Dimensions(tick)(error)  (error)(tick) (B)
Hierarchy on Measures(tick)   (error)(tick)
Hierarchy on Date (which is 'Time')(tick)   (error)(tick)
Hierarchy on Time(error)(error)(error)(error)(error)(tick)
Convert a date or string-based time dimension into a time hierarchy (aka time enrichment)(tick) (A)(error)(error)(error)(error)(tick)
  • A) Requires HANA 2.0 and HANA Model Date Enrichment DU. Enables consumption of time based features without the need to model in the source system. String-based time dimensions supports formats YYYYMMDD, YYYYMM and YYYYQ
  • B) Maximum 8 levels
  • C) Planned for both Analytical and Planning Models, though Planning Models is planned for a little later. For Planning models, only 1 fiscal date is supported, i.e. you can not currently have different dates for different fiscal periods.

Universe Support Matrix

General Support for Universes
 FeatureLive (1.04)Live (1.05 onwards)Import DataComments
Build an SAP Analytics Cloud Model off a...

 

UNV Universes(tick)(tick)(error) 

Relational UNX Universes (Single and Multi Source)

(tick)(tick)(tick) 
Stored Procedure Universe(tick)(tick)(error) 
JavaBeans Universe(tick) (error) 
Multi-dimension Universes based off OLAP connection(error)   
 Minimum BI Platform VersionBI 4.2 Support Pack 4 (A)BI 4.2 Support Pack 4 (B)BI 4.1 Support Pack 5
  • (A) Recommended to use BI 4.2 SP5 Patch 1 due to performance improvements made with that version
  • (B) Recommended to use BI 4.2 SP5 Patch 4 due to performance improvements with large data sets and scalability
 Web Application ServerTomcat 7Tomcat 7 and 8+Tomcat 7 
 Model enrichment(error) (B)(error) (B)(tick)
  • (B) Planned
 Define Universe Query as a data source for model definition(error) (C)(tick)(tick) 
 Create a model off a Web Intelligence document(error)(error)(error) 
 Multi language support(error) (D)(error) (E)(error)
  • (D) the connection to the BI Platform specifies the language used to connect to it and it does not change dynamically. The model thus uses the language and this is why a single language is currently supported. @Variable('PREFERRED_VIEWING_LOCALE’) will not change
  • (E) Planned feature that will require an update to the BI Platform
Query as a data source Support Features

The live connector (v1.05 onwards) provides a query panel at the time of building a model in SAP Analytics Cloud. This section describes the features available with that query

  Live Connector Version 1.05 onwardsComments
Results paneDimensions (with Data Type 'String', 'Numeric')(tick) 
Dimensions (with Data Type 'Date' and 'DateTime')(tick)
  • Objects of type 'Date' (not DateTime) are required for 'Time Series' Charts
  • Objects of type 'Date' and 'DateTime' can not be filtered in the Story 'By Range', only 'By Member'
Attributes (Detail objects)(error)
  • They are not shown and so cannot be selected. For both measures and dimensions.
Measures (with Project function: sum, count, average, min, max)(tick) 
Measures (with Project function: database delegated)(error)
  • Due to the change in architecture with v1.05 this object type is no longer supported (officially it never was supported before, but it did work).
Add a combined Query(error)
  • It means performing a union, minus or intersect is not supported
Maximum number of objects150 
Filters paneBusiness Lever Filter(tick)
  • These can include prompts with/without list of values
Dimensions of Types: String, Numeric(tick)
  • 'String' data type objects in filters can have the following operators: Equal to, Except, Contains, Does not contain
  • 'Numeric' data type objects in filters can have the following operators: Equal to, Except, Greater than, Greater than or equal to, Less than, Less than or equal to
Dimensions of Type Date(tick)
  • 'Date' data type objects in filters can have the following operators: Equal to, Except, Before, Before or Including, After, After Including
Measures(tick)
  • 'Numeric' data type objects in filters can have the following operators: Equal to, Except, Greater than, Greater than or equal to, Less than, Less than or equal to
Prompts(error)
  • Defining a new prompt is not supported. Prompts need to be defined in the Universe.
Sub Query(error) 
Database Ranking(error) 
Nested filters with AND/ORs(tick) 
List of valuesSimple List of values(tick)
  • However there is a current restriction for objects defined with Index Awareness. It means the list of values shown in the query panels filter pane, when building the model, will show the Index Awareness values and not the actual 'SELECT' values as expected. This will cause the query to return no rows should any of the 'Index' values be selected. This is being tracked and under investigation (internal reference FPA55-852). It means you need to either enter the values manually, or avoid using a list of values on an Index Aware object.
Cascading List of values(tick) 
DisplayBusiness Layer Views(error)
  • Business Layer Views are supported, but you can not select the Business Layer View in the query panel to filter the objects seen.
By Navigation Path(error)
  • Hierarchies are supported, but you can change the view of objects to be listed by Hierarchies.
Object Description(tick)
  • Shown as tooltip
Relational Universe Features
 Feature

Live (v 1.04 or previous with wave <14)

Live (v1.05 on wards and wave >=14)Import DataComments
Data FoundationMultiple Contexts(error) (A)(tick) 
  • (A) Multiple contexts in the universe is possible. The requirement is a single 'run-time' context. All active objects (so ignoring all hidden/deprecated objects) must use only 1 context at run-time. For example multiple contexts are supported when used with @Aggregate_Aware objects as only 1 context is used. Multiple contexts resolved with JOIN_BY_SQL are not currently supported. There can not be any context prompt. Any Business Layer Security Profiles are ignored to determine the use of contexts when creating the model.
Data typesNumeric(tick) (D)(tick) (D) 
  • (D) All numerics will be given a decimal format 0.00
Character(tick)(tick)  
Date, DateTime(tick)(tick)  
Measure ObjectsProjection Function 'sum'(tick) (B) (F)(tick) (F) 
  • (B) The SQL must have an aggregation function (sum, min, max, avg, count etc.), this is best practice anyway.
  • (F) Display format is not supported, defaults to decimal 0.00
Projection Function 'database delegated'(tick) (B) (F)(error) (Planned) 
  • (B) The SQL must have an aggregation function (sum, min, max, avg, count etc.), this is best practice anyway.
  • (F) Display format is not supported, defaults to decimal 0.00
Projection Function 'min', 'max'(tick) (B) (F)(tick) (F) 
  • (B) The SQL must have an aggregation function (sum, min, max, avg, count etc.), this is best practice anyway.
  • (F) Display format is not supported, defaults to decimal 0.00
Projection Function 'count', 'count without empty'(error)(error)  
Projection Function 'average'(tick) (B) (F)(tick) (F) 
  • (B) The SQL must have an aggregation function (sum, min, max, avg, count etc.), this is best practice anyway.
  • (F) Display format is not supported, defaults to decimal 0.00
DetailsDetail Objects(error)(error)  
Object PropertiesDescriptions(error) (M)(tick) (N) 
  • (M) they are ignored
  • (N) they are displayed as tooltips in the Query Panel when defining the model
List of ValuesSimple List of values (just a single column of values)(tick)(tick) 
  • (J) Associated List of Values on objects are used by @Prompt only. For 'Data View', 'Input Control' and filtering, the list of values used is the list generated by the SELECT statement when run on its own.
Multiple columns(error)(tick)  
Cascading Prompts (which form a hierarchy)(error)(tick)  
Nested, Hierarchical(error)(error) 
  • These are list of values that are based on a custom hierarchy
SecurityUniverse Overload / Business Security Profiles and Data Security Profiles / Security Access Level(tick) (C)(tick) 
  • (C) though any Business Security Profile is ignored to determine if a context is used at model creation time. Only 1 context is supported.
FiltersFilters (defined in the query panel) or BI Sets(error) (D)(tick)  
@ functions@Prompt (E), @WHERE, @SELECT, @AGGEGATE_AWARE, @Variable (H)(tick) (E) (H)(tick) (E) (H) 
  • (E) though there are currently limitations to the list of values
  • (H) @Variable('PREFERRED_VIEWING_LOCALE') is not currently supported. Means a multi-lingual universe requires an SAC model per language. The language of the model is the language used in the SAC connection to the BI Platform. so the value of PREFERRED_VIEWING_LOCALE is fixed and set at model creation time.
Universe Optimisations

Index Awareness, Select optimisation (DISTINCT_VALUES)

(error) (G)(tick) (L) 
  • (G) The universe can be index aware but SAC will ignore any index awareness properties
  • (L) Currently this means the list of values shown in the query panels filter pane, when building the model, will show the Index Awareness values and not the actual 'SELECT' values as expected. This will cause the query to return no rows should any of the 'Index' values be selected. This is being tracked and under investigation (internal reference FPA55-852). It means you need to either enter the values manually, or avoid using a list of values on an Index Aware object. Objects with Index Awareness defined can be used in the model.
SQL Optimisation (ANSI_92), Inline views (BOUNDARY_WEIGHT_TABLE) (I)(tick)(tick) 
  • (I) BOUNDARY_WEIGHT_TABLE is supported, however a linked universe will ignore this setting, instead the linked universe must be included and the table row count set for this to work.

Planning Models

 Model based off ...
SAP Analytics Cloud FeatureBPC Live connectionBPC Import DataFile (generic Planning model)
Advanced Planning (Spreading / Allocations)(error)(tick)(tick)
Predictive(error)(tick)(tick)
Data Action(error)(tick)(tick)
Value Driver Tree(error)(tick)(tick)

Model Formula

(click to sort)Available in Data Wrangling for all Import Data Connections (available before model creation)Available in Modeller for Acquired Data Sources (available after model creation)
If(tick) maximum depth 97 levels(tick)
SubString(tick)(tick)
Trim(tick)(error)
Contain(tick)(error)
Concat(tick)(error)
Replace(tick)(error)
Length(tick)(tick)
Like(error)(tick)
LowerCase(tick)(error)
UpperCase(tick)(error)
DateDiff(tick)(tick)
DateAdd(tick)(error)
DayOfWeek(tick)(error)
ToDate(tick)(error)
MakeDate(tick)(error)
Abs(tick)(tick)
Link(error)(tick)
LookUp(error)(tick)
Log(tick)(tick)
Log10(tick)(tick)
Int(error)(tick)
Float(error)(tick)
Double(error)(tick)
Exp(tick)(tick)
GrandTotal(error)(tick)
%GrandTotal(error)(tick)
Mod(tick)(tick)
Min(tick)(tick)
Max(tick)(tick)
Sqrt(tick)(tick)
Power(tick)(tick)
Restrict(error)(tick)
RestrictLookup(error)(tick)
Round(tick)(tick)
ToNumber(error)(tick)
ToText(error)(tick)
Trunc(error)(tick)
Ceil(tick)(tick)
Floor(tick)(tick)
Not(tick)(tick)
IsNull(tick)(tick)

 

Geospatial

Model Building

  Reference page(s)Comments
Geo coding by longitude and latitude(tick)
  1. Creating a Model with Coordinate or Area Data for Geospatial Analysis
 
Geo coding by name(tick)
  1. Creating a Model with Coordinate or Area Data for Geospatial Analysis
  1. USA State and County data only
  2. Plans for other countries (SAP internal reference FPA00-3706)

Points of Interest

Points of Interest Reference page(s)Comments
Create point of interest from amodel

(tick)

  1. Creating points of interest
  1. Currently the model must be acquired model, either a normal Analytic model or a Planning model.
  2. (SAP internal reference: FPA00-8140)
CSV or an Excel File(tick)
  1. Creating Point of Interest Data from a CSV or an Excel file

 
ESRI shape file(tick)
  1. Creating Point of Interest Data from an Esri Shapefile
 

Planning

General Planning

 BPC Live ConnectionData Import Connections 
Data Actions(error)(tick) 
Value Driver Tree(error)(tick) 

Integration

SAP Analysis for Office Edition for SAP Analytics Cloud (not standard edition)

  Planning use-case (write back)Analysis use-case (read only)
AcquiredAnalytical Model(tick)(tick)
Planning Model(tick)(tick)
LiveHANA(error)(tick) indirect access via an SAC model
BW(error)(tick) indirect access via an SAC model
Other  

Useful links

  • utube connect to SAC from Analysis for Office

Stories and visualisations

Link Models (aka 'Blending'. Multiple data sources within a single visualisation)

Matrix to show which models can be blended to other models based upon the connection underlying the SAC model.Secondary Model
Live ConnectionsAll Import Data Connections
HANABWOthers
Primary ModelLive ConnectionsHANA(tick) (A)(error)(error)(tick) (B)
BW(error)(tick) (C) (Planned)(error)(tick) (C)
Others(error)(error)(error)(error)
All Import Data Connections(tick) (B)(tick) (C)(error)(tick)
  • A) Story level linking is supported when the data sources are HANA with a Live Connection to the same HANA instance/tenant using the very same connection as defined inside SAP Analytics Cloud (2 connections sharing the same connection properties are not enough). For HANA 1.0 this requires SPS12 revision 122.14 or higher and for HANA 2.0 this requires SAP Notes 2456225 and 244261. Story and Page Filtering on a measure is not supported with blended models
  • B) Requires HANA 2.0 and Smart Data Integration (SDI) to be setup between HANA and SAP Analytics Cloud. This means and SDI Agent to be running and connected to the HANA system. Remote Blending will require aggregated data to be moved to SAP Analytics Cloud servers (and temporarily stored there) if the primary data model is the acquired model. Equally if the primary data model is HANA, then aggregated acquired data will need to be moved to HANA (and temporarily stored there). The SAP HANA system must have a full use license (currently), an SAP HANA runtime (REAB) license is planned to be supported.
  • C) Requires SAP BW on HANA or SAP BW/4HANA. Blending is always processed in the SAP Analytics Cloud. BW aggregated data is held in SAP Analytics Cloud for 1 hour for blending purposes and then deleted. Restrictions: Two structure queries, Key Figure Model (temporarily restriction). SAP Note 2715871

Linking Variables (multiple data sources linked by the prompt/variable)

Matrix to show which models can be linked to other models based upon the connection underlying the SAC model.LiveAll Import connections
HANABWS/4BPCUniverse
LiveHANA(tick)    (tick)
BW (tick) (A)    
S/4      
BPC      
Universe    (tick) 
All Import connections(tick)     

When linking variables there are two options: link 'intersecting data only', or 'all data'.

Once variables are linked, the user is only prompted once for the variable instead of multiple times

  • A) BW can only 'intersect' data. BW hierarchy name and node variables are not supported

General features

Stories, Pages, Table and Charts

This section applies to tables and charts, subsequent sections may break out individual features by table or chart types

  Live connectionImport connection 
  HANAHANA Cloud PlatformBWS/4BPCUniverseBWBPCUniverseGeneral 
Measures Create Measures: Calculated Measure / Restricted Measure(tick)  (tick)(tick) (M)    
  • (M) requires BI 4.2 SP4 Patch 3
Create Measure: Difference from
(this is comparisons over time periods, like YoY etc.)
(tick)(error)(error)(error)       
Create Measure: Aggregation(tick) (N)(error)(error)(error)(error)(error)(tick) (tick) 
  • (N) SAP HANA models prior to version 122.14 do not support aggregations
Create Measure: Date Difference (max, min, average, sum) on Y Q, M, Week, Day (B)(tick) (P)(error)(error)(error)(error)     
Filter on Measures (on: Story, Page, Widget)(tick) (Q) (T)(error)(error)(error)(error) (F) (Planned)(tick)(tick)(tick)(tick) 
 Dimensions      Hierarchies and drill(tick)   (error)     
Filter on Dimensions(tick)(tick)(tick) (H) (tick)(tick)(tick)(tick)  
Dimension Linking (tick)(error) (error) (Planned)    
  • Dimension linking enables filtering of one dimension in a model to filter the linked dimension in another. This is not blending!
Calculated Dimension by concatenating two dimensions(tick)   (error) (Planned)     
Calculated Dimension by grouping members(tick) (B)(error)(error)(error)(error)   (tick) 
Calculated Measure-based Dimensions(tick) (Q) (Planned)(error)(error)(error)(error)   (tick) (Planned) 
Custom Sorting of Dimensions (R)(tick) (Planned for tables. Charts supported today)(error)(error)(error)(error)   (tick) 
Dynamic Filter (tick)  (tick)    
  • Dynamic Filter is ability to set the widget to use a different variable compared to the story variable
 Linked Analysis(tick)(tick)(tick)(I)(tick)(tick)(tick)(tick)(tick)(tick) 
 Dynamic Text in titles (Charts already supported, planned for tables)(tick)(tick)(tick)(tick)(tick)(tick)(tick)(tick)(tick) 
 Thresholds    (error)     
 Positioning of Currency/Scale (i.e. €50 v 50€) based on Service setting(tick) (Q)(tick) (S)      (tick) Planned 
Charts
  Live connectionImport connection 
  HANAHANA Cloud PlatformBWS/4BPCUniverseBWBPCUniverseGeneral 
ChartRanking Top N filtering on hierarchies for charts and tables(tick)(error)(error) (error)     
Ranking Top N filtering on flat dimensions(tick)(tick)(tick) (error) (Planned)     
Sorting    (tick)     
Waterfall ChartsGeneral Support(tick)(error) (E)(error)     (tick) 
Time Series ChartsGeneral Support(tick) (B)(tick)(error) (tick)     
Apply fixed and dynamic filters to Time series charts (Y, Q, M, D, Hr, Min, S, mS, Current Y/Q/M)(tick)(tick)  (error)   (tick) 
Time series chart hierarchies supported Y, M, D        
VarianceBased on Version(tick) (A)(error) (E)(error) (error)   (tick) 
Based on Time Hierarchy(tick) (U)(error)(error) (error)   (tick) 
HistogramGeneral Support(tick) (Q)       (tick) 
Dynamic Image WidgetGeneral Support(tick) (Planned) (B)(error)(error)(error)(error)(error)(error)(error)(error) 
GeoMapsGeneral support(tick) (D)(error) (E)(error) (error) (error) (tick)
Hierarchies(error)   (error)     
Tables
  Live connectionImport connection 
  HANAHANA Cloud PlatformBWS/4BPCUniverseBWBPCUniverseGeneral 
TablesTable totals, when a Top N filter is applied(tick)(error)(error) (error) (Planned)     
Sorting    (tick)     
Custom Sorting of Dimensions (to merge)(tick) (Planned)(error)(error)(error)(error)   (tick) 
Export Data as CSV  (error) (tick)     
Explorer
  Live connectionImport connection 
  HANAHANA Cloud PlatformBWS/4BPCUniverseBWBPCUniverseGeneral 
ExplorationSearch on dimension value (error)(error) (error)   (tick) 
Exclude Dimension value (error)  (tick)   (tick) 
Dimension sorting on hierarchies (error)  (error)     
KPI
  Live connectionImport connection 
  HANAHANA Cloud PlatformBWS/4BPCUniverseBWBPCUniverseGeneral 
KPICreate KPI    (error)     
Alerts  (tick) (J) (error)    
  • (J) except for SAP S/4HANA Cloud version 1702 when they are not supported
  • A) planned to be available from wave 2018.02 and this requires HANA 122.14 or newer
  • B) requires HANA 2.0
  • E) Planned to be resolved end of Q1 2019
  • F) define measure filters with @Prompt in universe as workaround.
  • H) Dimension members must not contain exclamation marks in description
  • I) SAP S/4HANA Cloud version 1702, Linked Analysis workflows may return errors with no results. Errors may occur when filtering on a member in a chart that results in the creation of a story filter, or when filtering on a member in a chart that is pushed to other charts in the linked group.
  • O) Requires HANA 2.0. Supported with Calculated and Restricted Measures. Not supported with Blended models. Calculated dimension cannot be used as aggregation context for measure based filter
  • P) Also works when time is enriched
  • Q) Requires HANA 2.0
  • R) Requires HANA 2.0. For hierarchical dimensions siblings can only be custom sorted within its parent. i.e. you can't move a member to a different parent
  • S) Requires SAP Note 270031
  • T) Calculated dimensions can not be used for measure based filters
  • U) Time based hierarchy must be defined in HANA 1.0, or for HANA 2.0 the hierarchy can be built directly in SAC modeller using a Date dimension

Story level formula

 Live connectionImport Data
 HANAOther Live connections 
Length(tick) (A) (tick)
SubString(tick) (A) (tick)
Like(tick) (A) (tick)
ToNumber (Planned)(tick) (A) (Planned)(error)(tick)
ToText (Planned)(tick) (A) (Planned)(error)(tick)
  • A) Requires HANA 2.0

Story Visualisation of GeoMaps

  Reference page(s)Comments
Show data from a single model(tick)
  1. Creating a GeoMap
 
Show data from multiple models in a single geomap visualisation(tick) 
  1. Currently linked models do not work in a GeoMap. This means if model A is Geo-coded, you can't link to it, from another model B, and expect the data to be geo-coded in Model B.
  2. Plans for future (SAP internal reference FPA34-612)
    

Predictive

  Live connectionsImport Connections
  HANABWS/4BPCUniverseall others (except BPC)BPCS/4File
 'Time series' Chart time series forecast (Analytical Models)(tick)(tick)(tick) (tick) (B)(tick)  (tick)
 Line Chart Time Series Forecasting (Analytical Models)(error)(error)(error)(error)(error)(tick)  (tick)
 R Visualisations(tick) (A)(tick) (A)(tick) (A) (tick) (A)(tick)  (tick)
 Search to Insights(tick)(error)(error)(error)(error)(tick)  (tick)
 Smart Discovery, including Simulation(error)(error)(error)(error)(error)(tick)  (tick)
 Smart Insights(error)(error)(error)(error)(error)   (tick)
 Smart Grouping (on Bubble and Scatter Plot Charts)(tick)(tick)(tick) (tick)(tick)  (tick)
 Smart Predict (the source is the 'Data Set') (warning) (C)(error)(error)(error)(error)(error)(error)(error)(tick)(tick)
  • (A) limitations for the remote R server visualisations:
    • 5 millions rows and 3 million data cells.
    • 110 MB remote data size limit.
  • (B) requires a 'Date' object, not a 'DateTime' object. There is currently no hierarchy support on the 'Time', for example no month, quarter, yearly view.
  • (C) Feature dependent on hosting service.

Maximum limits

  Limit ValueComments
Input ControlMaximum unique values4000Influence (SAP internal reference)
CommentMaximum comment threads per modelunlimited (previously was 100)
  • Adding comments on Planning Models requires the model currency to be displayed, not a local currency
  • Default setting is 3,000. Can be adjusted in 'System-Administration-System-Configuration'

Life Cycle Management

SAP Analytics Cloud

Import/Export Object Support

ObjectImport/Export 
Team(error) 
Role(tick) 
User(tick) 
Public Acquired Model(tick) 
Public Live Model(tick) 
Public Dimensions(tick) 
Public Story(tick) 
Public Digital Boardroom(tick) 
Public Analytical Application (Beta)(tick) 
Public Roambi  
Connection - Live  
Connection - Acquired  

Relationships

Source Object in SAP Analytics CloudReference byTo the objectwhere the object is held in
BW live ModelTechnical name of the BEx queryBW BEx queryBW
BW key figure or characteristicTechnical name of the key figure or characteristicBW key figure or characteristicin the BEx Query in BW
Universe live ModelUniverse name and path as stored in the BI Platform 'universe' folderUniverseSAP BusinessObjects BI Platform
Universe BusinessObject (Dimension, Measure etc.)Object IDUniverse BusinessObjectSAP BusinessObjects BI Platform Universe
Story Widget (Chart/Table)Model nameModel (when models are in the 'Menu-Models' container)SAP Analytics Cloud
Model IDModel (when models are stored in Public and Private FoldersSAP Analytics Cloud
    

SAP Analytics Hub

Upload/Download Object Support

ObjectUploadDownload
Asset Structure(tick)(tick)
Asset Structure - Facets(tick)(tick)
Branding(tick)(tick)
Branding - Header(tick)(tick)
Branding - Home Page(tick)(tick)
Hub Contents - Assets (Visible, Hidden)(error)(tick)
Hub Contents - Assets (Drafts)(error)(tick)
Hub Contents - Uploaded pictures(error)(tick)
Hub Contents - User Data(error)(tick)
Hub Contents - User Data - Favourites(error)(tick)
Hub Contents - Picked for you(error)(tick)
Hub Contents - Usage Data(error)(tick)

 

 

  • No labels