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.

(warning) Unless otherwise notes, when the term BW is mentioned it also includes the product BW/4HANA.

 

Models

Live Model Support

 SAP Cloud PlatformOn Premise (or SAP HEC)Key ReferencesAdditional Comments
HANA v1

(tick) (C) (D)

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

 
HANA v2

(tick) (D) (E)

(tick) (A) (B) (D) 
  • String-based time dimensions or date dimensions that you want to enrich with time-hierarchy information requires a delivery unit to be installed on HANA. See KBA 2723743

BW

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

 

 

n/a

(tick)

(warning) Support Matrix for SAP BW

(warning) SAP Note 2415249  - Using SAP Analytics Cloud as Client for SAP BW queries on BW 7.50

(warning) SAP Note 2715030 - Considerations when using SAP BW and SAP S/4HANA Live Connections in SAC

  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(tick)Planning functionalities supported in SAC live connection to BPC Embedded ModelEmbedded model
S/4

(tick)

(tick)

(warning) SAP Note 2715030 - Considerations when using SAP BW and SAP S/4HANA Live Connections in SAC
  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) Typical HANA live connections can only consume HANA Calculation Views. A HANA based CDS view requires a HANA Calculation View to be created on it. However, a 'Data Set', that can be used for 'Smart Predict' can consume SAP HANA tables (row store or column store), and SAP HANA SQL Views. Perhaps confusingly, 'Data Sets' can not be based off HANA Calc Views.
  • (E) HANA 2.0 is supported for SAP Cloud Platform regardless of where the SAP Analytics Cloud Service is hosted. When HANA 2.0 is hosted as a service (HANA as a Service, HaaS) then there are a few limitations: GeoMaps are not supported (though this is planned to be resolved soon). Data Blending is limited to HANA Calculation Views on the same HaaS. It means browser based and SDI-based data blending is not supported.

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 Live Connection Support
 HANABW (on premise)BPCS/4Universe 
 HANA (on premise)HANA (SAP Cloud Platform)S/4 (on premise) (L)S/4 (Cloud) (L) 
Required ComponentsSAP Cloud Connector (SCC)(error)(error)(error)(error)(error)(error)(error) 
SAP Cloud Agent(error)(error)(error)(error)(error)(error)(error) 
Browser (desktop)ConnectionType

DIRECT (B)

 

CLOUD

 

DIRECT

 

DIRECT

 

DIRECT (F)

DIRECT (F)

DIRECT (C) (D)

 
AuthenticationUsername and password(tick)(tick) (error) (K)(tick)(tick)(tick) (I)(error)(tick) 
SSO

SAML

SAML

SAML

SAML

SAML (I)

OAUTH (M)

SAML (E)

 
None (delegated, such as X509,  Kerberos, SAP Logon Token)(tick)(tick)(tick)(tick)(tick)(tick)(tick) 
     

     
HTTPProtocol1121 11 
Mobile App Live Connection Support


HANABW (on premise)BPCS/4Universe 
HANA (on premise)HANA (SAP Cloud Platform)S/4 (on premise) (L)S/4 (Cloud) (L) 
Required ComponentsSAP Cloud Connector (SCC)(error)(warning) (O)(error)(error)(warning) (N)(error)(error)(error)(error) 
SAP Cloud Agent(error)(error)(error)(error)(error)(error)(error) 
Mobile AppReverse ProxyApache(tick)(tick)(tick)(tick)(tick)(tick)n/a 
Web Dispatcher(error)(error)(error)(error)(error)(error)(error) 
ConnectionType for iOS

DIRECT

SCC

CLOUD

 

DIRECT

SCC 

DIRECT

(error) ?(error) (H) 
Type for Android          
AuthenticationUsername and password(tick)(tick) (G)(tick) (tick)(error) ?(error) (H) 
SSO

SAML

SAML

SAML

 

SAML

(error) ?(error) (H) 
None (delegated, such as X509,  Kerberos, SAP Logon Token)(error)(error)(error)(error)(error)(error)(error) 
             
HTTPProtocol112 1 11 

 

Schedule Publication Live Connection Support (feature not currently available)


HANABW (on premise)BPCS/4Universe 
HANA (on premise)HANA (SAP Cloud Platform)S/4 (on premise) (L)S/4 (Cloud) (L) 
Required ComponentsSAP Cloud Connector (SCC)        
SAP Cloud Agent        
Schedule PublicationConnectionType

 

 

 

 

 

 

   
AuthenticationUsername and password        
SSO

 

 

 

 

 

   
None (delegated, such as X509,  Kerberos, SAP Logon Token)        
           

 

 

Connections Types:

 means the connection is made..

DIRECT

from the client directly to the database and the cloud servers are not involved in that connection

CLOUD

from cloud servers to other cloud servers

SCC

from the client to the database but uses SAP Analytics Cloud and the SAP Cloud Connector to 'proxy' that connection. It means the on-premise database does not need to be exposed to the internet for those users outside of the organisations network, nor do those users need to use a 'VPN' to connect. When the connection is used no data is stored in the cloud, the cloud servers are used only to transmit the data through them to the client. This connection type is not currently available, though it is planned.

 

  • 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'
  • H) Currently not supported, please refer to the SAP Roadmap for details on the plan
  • I) Username and password not supported (SAML is required instead) when S/4HANA on-premise is federated through an SAP S/4HANA Front-end server (FES) / SAP Fiori Front-end server (FES). Setup of the connection requires the user to have access to the S/4HANA backend system.
  • K) HANA as a Service (HaaS) version 2 does not support username/password authentication, only SAML SSO is supported. When HANA is hosted on Cloud Foundry a custom IdP is required, the default IdP is not sufficient.
  • L) S/4HANA means consumption via CDS views and not BW queries. BW query consumption is technically possible but not recommended.
  • M) Could optionally use a different Identity Provider compared to SAP Analytics Cloud (unlike when S/4HANA is on-premise, when the same IdP must be used)
  • N) Currently available in Beta only for selected customers. Current GA plan is for the Q2 2020 QRC release. Currently this method only works with the mobile app to connect to your SAP BW data source through a non-SAP data centre. A two-digit number in your SAP Analytics Cloud URL, for example eu10 or us30, indicates a non-SAP data centre.
  • O) Planned feature and currently in Beta for selected customers only. Current GA plan is for the Q2 2020 QRC release. Currently this method only works with the mobile app to connect to your SAP HANA data source through a non-SAP data centre. A two-digit number in your SAP Analytics Cloud URL, for example eu10 or us30, indicates a non-SAP data centre. The limitation on the data centre being used is planned to be removed in wave 2019.23 (but subject to change)

 

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

 

BW System Requirements changes by wave

This table shows, by wave release, when on-premise BW system requirements change to benefit from additional SAP Analytics Cloud features for BW.

Importantly this is NOT a list of the changes to minimum BW System requirements. Please refer to the official System Requirements page found within the help pages within your SAP Analytics Cloud Service.

Wave (SAC Service Version)Quarterly Release ?Requirements for Further Supported FeaturesNote Analyser file nameNotes Added or Updated compared to previous XML file version
(NOT an accurate number)
Need to update BW comments
2019.04Yes (for some Data Centres, not others)SAP Note 2541557SAP_BW_Analytics_Cloud_Connection_2019-wave04_onwards.xmlApproximately 46 SAP NotesIn general, update to BW is only needed if wishing to use new BW live features: Time Series, Waterfall, Waterfall delta and Basic Variance.
2019.05NoSAP Note 2541557SAP_BW_Analytics_Cloud_Connection_2019-wave05_onwards.xmlApproximately 18 SAP Notes 
2019.07NoSAP Note 2541557SAP_BW_Analytics_Cloud_Connection_2019-wave07_onwards.xmlTo be updated soon
 
2019.08Yes (for all Data Centres)Same as 2019.07SAP_BW_Analytics_Cloud_Connection_2019-wave07_onwards.xml  
2019.10NoSAP Note 2541557SAP_BW_Analytics_Cloud_Connection_wave10_onwards.xmlTo be updated soon 
2019.15Yes Same as 2019.10SAP_BW_Analytics_Cloud_Connection_wave10_onwards.xml  
2019.16NoSame as 2019.10SAP_BW_Analytics_Cloud_Connection_wave10_onwards.xml  
2019.17NoSAP Note 2541557SAP_BW_Analytics_Cloud_Connection_wave17_onwards_ECC_SP16.xml  
2019.18NoSAP Note 2541557SAP_BW_Analytics_Cloud_Connection_wave18_onwards_withsomeNotesAfterSP16.xml  
2019.19NoSame as 2019.18SAP_BW_Analytics_Cloud_Connection_wave18_onwards_withsomeNotesAfterSP16.xml  
2019.20NoSame as 2019.18SAP_BW_Analytics_Cloud_Connection_wave18_onwards_withsomeNotesAfterSP16.xml  
2019.21Yes
(Q4 QRC)
Same as 2019.18SAP_BW_Analytics_Cloud_Connection_wave18_onwards_withsomeNotesAfterSP16.xml  
2019.22NoSAP Note 2541557SAP_BW_Analytics_Cloud_Connection_wave22_onwards_being.xml  
2019.23NoSame as 2019.22SAP_BW_Analytics_Cloud_Connection_wave22_onwards_being.xml  
2019.24Noto be confirmed - at least same as 2019.22to be confirmed - at least SAP_BW_Analytics_Cloud_Connection_wave22_onwards_being.xml  
2020.01Noto be confirmed - at least same as 2019.22to be confirmed - at least SAP_BW_Analytics_Cloud_Connection_wave22_onwards_being.xml  
2020.02Yes (Q1 QRC)to be confirmed - at least same as 2019.22to be confirmed - at least SAP_BW_Analytics_Cloud_Connection_wave22_onwards_being.xml  

(warning)We strongly suggest for NW BW customers to upgrade at least to NW BW 7.50 SP16. For BW/4HANA customers we recommend to go to BW/4HANA 2.0 SP 4 which is planned for 2.2020. For S/4 customers we recommend release 1909. See also note 2715030 for the planned features on NW BW 7.50 SP16 ECC , BW/4HANA 2.0 SP 4 and S/4 in detail.

Additional information on the purpose of this table and how to understand it is available in a blog

 

Live BW Support

BW featureSupported in SAP Analytics Cloud
TableHierarchy - Show node above(tick)
Table/ChartUse a fixed value for a dynamic variable (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 2019.08 on onwards
Version 1.07 (v1 SP7)(error)
Version 2.00 (v2)(tick)
Version 2.01 (v2 SP1)(tick)
Version 2.02 (v2 SP2)(tick)

KBA 2771921 Version 2 Release information and download

Acquired Model Support

Agent Versions by Analytics Cloud Service Version

You can download and update the SAP Analytics Cloud Agent before the scheduled date of your SAP Analytics Cloud Service update.
For more information, see 
SAP Analytics Cloud Agent Simple Deployment Kit.

Wave (SAC Service Version)Quarterly Release ?SAP Analytics Cloud Agent 'latest' versionMinimum SAP Analytics Cloud Agent version requiredSAP Cloud Connector (A)
SAP HANA view (on-premise)SAP ERP/ SQL DatabaseSAP UniverseSAP BWSAP BPC (standard)SAP BPC (embedded)All others
2019.8

Yes
Q2 2019

1.0.225 1.0.991.0.911.0.109  1.0.75 
2019.13No1.0.233 1.0.991.0.911.0.231  1.0.75 
2019.14No1.0.235 1.0.991.0.911.0.233  1.0.75 
2019.15Yes
Q3 2019
1.0.237 1.0.991.0.911.0.233  1.0.752.12.x (B)
2019.16No1.0.239 1.0.991.0.911.0.233  1.0.752.12.x (B)
2019.17No

1.0.241

 1.0.991.0.911.0.233  1.0.752.12.x (B)
2019.18Notbc 1.0.991.0.911.0.233  1.0.752.12.x (B)
2019.19No1.0.2431.0.2351.0.991.0.911.0.2331.0.751.0.1091.0.752.12.x (B)
2019.20No1.0.2451.0.2351.0.991.0.911.0.2331.0.751.0.1091.0.752.12.x (B)
2019.21Yes
Q4 2019
1.0.2481.0.2351.0.991.0.911.0.2331.0.751.0.1091.0.752.12.x (B)
2019.22No1.0.2491.0.2351.0.991.0.911.0.2331.0.751.0.1091.0.752.12.x (B)
2019.23No1.0.2511.0.2351.0.991.0.911.0.2331.0.751.0.1091.0.752.12.x (B)
  • A) There is no direct dependency between the SAP Analytics Cloud Agent and the SAP Cloud Connector. The versions listed are intended to be read 'for the SAP Analytics Cloud version (or wave)' listed only.
  • B) The SAP Cloud Connector supported version is as listed, however this requirement is actually and currently only applicable for when SAP Analytics Cloud is hosted on a non-SAP data centre (Cloud Foundry) due to the IP addresses changing over time. See SAP KBA 2822078. If SAP Analytics Cloud is hosted on an SAP data centre then this technical issue will not be present and an older version of the SAP Cloud Connector can be used. This is not officially documented or communicated, the official documentation will state this version.  It is likely SAP Product Support would request an update to this version should an issue occur.

Acquired Model Scheduling And Export Support

 Import ScheduleExport Schedule
Universe(tick)(error)
CSV, Excel(tick) (B)(tick)
Odata Cloud(tick)(error)
Odata on-premise(tick)(error)
HANA via OData(tick) (A)(error)
HANA via JDBC(tick) (C)(error)
HANA (via Query Builder accessing all view types)
or HANA (via Freehand SQL accessing all tables and procedures)
(tick) 
BW(tick)(error)
SAP S/4HANA(tick)(tick)
BPC (D)(tick) (Planned)(tick) (Planned)
SAP IBP (SAP Integrated Business Planning)(tick) (wave 2019.16)(tick) (wave 2019.16)

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.
  • Exports of model data is limited to 6 million rows of fact data and 1 million rows of calculations

References

  • A) Expose as an Odata source, then consume the odata source in SAP Analytics Cloud see help
  • B) The agent requires a small configuration change (see blog). Importing directly through the web browser is also supported, however only schedule imports can be made via Agent
  • C) By using the 'Generic JDBC driver' option in SAP Analytics Cloud Agent
  • D) For data acquisition (import), regardless of any scheduling, see SAP Note 2755379 to reduce memory consumption on BPC side.

Acquired Model Combining Data Support.

FeatureValue
Join typesLeft outer, inner. Composite Joins with up to 3 keys are supported
Maximum data sources10
Maximum cells (in all the data to be joined)30 million

Modelling Supported Features

 Live ConnectionsImport Data Connections
 HANABWBPCS4Universe 
Planning Models(error) (error) (tick) (error)(tick)
Single Date Dimension(tick)(tick)  (tick) (E)(tick)
Multiple Date Dimensions(tick)(error)   (tick) (C)
Parent-child hierarchy on Dimensions(tick)(tick)  (error)(tick) (F)
Level-based hierarchy on Dimensions(tick)(error)  (error)(tick) (B) (F)
Hierarchy on Measures(tick)(tick)  (error)(tick)
Hierarchy on Date (Years to Days, which is 'Time')(tick)(warning) (D)  (error)(tick)
Hierarchy on Time (Hours to milliseconds)(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)
Version (aka Category) (i.e. supports actuals, budgets etc.)(tick)(tick)(tick)(error)(tick)(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) Supported for both Analytical and Planning Models. For Planning models, only 1 fiscal date is supported, i.e. you can not currently have different dates for different fiscal periods.
  • D) Supported for time series charts
  • E) Supported to have a date dimension, but there are no date driven charts or calculations
  • F) A dimension can have one or more level-based hierarchies, or one or more parent-child hierarchies, but not both.

Universe Support Matrix

General Support for Universes

 Feature

Live (2.0)

Live (2.1)Live (2.2)Import Data
Build an SAP Analytics Cloud Model off a...

 

UNV Universes(tick)(tick)(tick)(error)

Relational UNX Universes (Single and Multi Source)

(tick)(tick)(tick)(tick)
Stored Procedure Universe(tick)(tick)(tick)(error)
JavaBeans Universe   (error)
Multi-dimension Universes based off OLAP connection(error)(error)(error) 

Web Intelligence Data Model
(Web Intelligence document)

(error)(error)(error)(error)
Platform

Minimum BI Platform VersionBI 4.2 Support Pack 5 or greaterBI 4.2 Support Pack 5 or greaterBI 4.2 Support Pack 5 or greaterBI 4.1 Support Pack 5 or greater
Web Application ServerTomcat 7 and 8+ (C)Tomcat 7 and 8+ (C)Tomcat 7 and 8+ (C)Tomcat 7
Capabilities



Model enrichment(error) (D)(error) (D)(error) (D) (Planned)(tick)
Define Universe Query as a data source for model definition(tick)(tick)(tick)(tick)
Multi language support(error) (B)(error) (B)(error) (B) (Planned)(error)
BI Platform authenticationEnterprise(tick)(tick)(tick)(tick)
LDAP(tick)(tick)(tick)(tick)
SAP(error)(tick)(tick)(tick)
Windows Active Directory(error)(error)(error)(tick)
Others(error)(error)(error)(error)
  • A) Recommended to use BI 4.2 Support Pack 5 Patch 4 due to performance improvements with large data sets and scalability
  • B) 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
  • C) Needs JRE 8 or higher. SSL must also be configured. You cannot deploy BI Platform REST Web Services and Live Data Connect on the same Tomcat application server if you use SAML authentication
  • D) Except you can: change data source, set dimensions to be hidden, rename dimensions and group dimensions.

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 2.1Live Connector Version 2.2Comments
Results paneDimensions (with Data Type 'String', 'Numeric')(tick)(tick) 
Dimensions (with Data Type 'Date' and 'DateTime')(tick)(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) (A)(tick)
  • A) They are not shown and so cannot be selected. For both measures and dimensions.
Measures (with Project function: sum, count, average, min, max)(tick)(tick) 
Measures (with Project function: database delegated)(error)(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)(error)
  • It means performing a union, minus or intersect is not supported
Maximum number of objects150150
  • Can be adjusted by editing the 'boe.properties' file and setting boe.nbMaxObjects to the number desired
Filters paneBusiness Layer Filter(tick)(tick)
  • These can include prompts with/without list of values
Dimensions of Types: String, Numeric(tick)(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)(tick)
  • 'Date' data type objects in filters can have the following operators: Equal to, Except, Before, Before or Including, After, After Including
Measures(tick)(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)(error)
  • Defining a new prompt is not supported. Prompts need to be defined in the Universe.
Sub Query(error)(error) 
Database Ranking(error)(error) 
Nested filters with AND/ORs(tick)(tick) 
List of valuesSimple List of values(tick)(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)(tick) 
DisplayBusiness Layer Views(error)(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)(error)
  • Hierarchies are supported, but you can change the view of objects to be listed by Hierarchies.
Object Description(tick)(tick)
  • Shown as tooltip

Relational Universe Features

 FeatureLive (2.x)Import DataComments
Data FoundationMultiple Contexts(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) 
  • (D) All numerics will be given a decimal format 0.00
Character(tick)  
Date, DateTime(tick)  
Measure ObjectsProjection Function 'sum'(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'(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) (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)  
Projection Function 'average'(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)  
Object PropertiesDescriptions(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) 
  • (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(tick)  
Cascading Prompts (which form a hierarchy)(tick)  
Nested, Hierarchical(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) 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(tick)  
@ functions@Prompt (E), @WHERE, @SELECT, @AGGEGATE_AWARE, @Variable (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)

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

Model Exception Aggregation Support

 Live ConnectionsImport Connections
 HANABWBPCS4Universe
Count(tick)    (tick)
Avg(tick)    (tick)
Sum(tick)    (tick)
Min(tick)    (tick)
Max(tick)    (tick)
First(tick)    (tick)
Last(tick)    (tick)
First Quartile(tick) (A)    (tick)
Median(tick) (A)    (tick)
Third Quartile(tick) (A)    (tick)

A) Requires HANA baseline level 5

 

Acquired Model Wrangling and Formula Support

(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)
CAGR (Compound Annual Growth Rate)(error)(tick)
SMA (Simple Moving Average(error)(tick)
YoY (Year over Year)(error)(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

Countries, Region and Subregion are supported.
Country can be ISO2, ISO3 or English names and is mandatory

Regions and Subregions must be English names and are optional

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) 

Microsoft Office Integration

There are two products from SAP that offer integration between Microsoft Office and SAP Analytics Cloud

 SAP Analysis for Office Edition for SAP Analytics CloudSAP Analytics Cloud Add-in for Microsoft Office (beta soon)
Microsoft Excel On-line
(and thus supported on non-Windows platforms)
(error)(tick)
Microsoft Excel Desktop(tick)(tick) (A)

A) Requires Microsoft Office edition 1903

SAP Analysis for Office Edition for SAP Analytics Cloud

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

  Planning use-case (write back)Analysis use-case (read only)
AcquiredAnalytical Model(error)(tick)
Planning Model(tick)(tick)
LiveHANA(error)(error) (A)
BW(error)(error) (A)
Other(error)(error)
  • A) Planned. Likely to require Analysis for Office version 2.8

Useful links

  • YouTube connect to SAC from Analysis for Office.
  • KBA 2787445 - Live Model Support

SAP Analytics Cloud Add-in for Microsoft Office

This product is planned to enter Beta soon.

 


Consumable Artifacts

Stories

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

Technologies used for blending

There are 3 technologies used for blending:

  1. Native. This means the blending occurs within SAP Analytics Cloud 'natively'. No additional technology is needed.
  2. SDI (Smart Data Integration) based blending means the data is transmitted, via SDI, and temporarily stored in either the Primary or Secondary data source where the blending itself occurs. Smart Data Integration (SDI) need to be setup between the data source and SAP Analytics Cloud. This means an SDI Agent to be running and connected to the HANA system via SAP Cloud Connector.
  3. Browser based blending means the data is transmitted, via the users' web browser, and temporarily stored in either the Primary or Secondary data source where the blending itself occurs. Although no special setup is required it is highlighted as additional requirements or restrictions apply.

SDI is recommended over browser based blending.

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
HANABWS/4 HANA 
HANAHANA Cloud PlatformBW on HANA or BW/4HANABW (on any DB)S/4HANA On-PremiseS/4HANA CloudOthers
Primary ModelLive ConnectionsHANAHANA

NATIVE (A)

(error)(error)(error)(error)(error)(error)

SDI (B)

BROWSER (G)

HANA Cloud Platform(error)

NATIVE (F)

(error)(error)(error)(error)(error)(error) (L)
BWBW on HANA or BW/4HANA(error)(error)

SDI (I)

BROWSER (J)(E)

BROWSER (J)(E)

BROWSER (J)(E)

(error)(error)

SDI (C)

BROWSER (J)(E)

BW (on any DB)(error)(error)

BROWSER (J)(E)

BROWSER (J)(E)

BROWSER (J)(E)

(error)(error)

BROWSER (J)(E)

S/4 HANAS/4 HANA (On-Premise)(error)(error)

BROWSER (J)(E)

BROWSER (J)(E)

NATIVE (H)

(error)(error)

BROWSER (J)(E)

S/4HANA Cloud(error)(error)(error)(error)(error)(error)(error) 
 Others(error)(error)(error)(error)(error)(error)(error)(error)
All Import Data Connections

SDI (B)

BROWSER (G)

(error) (L)

SDI (C)

BROWSER (J)(E)

BROWSER (J)(E)

BROWSER (J)(E)

(error)(error)

NATIVE

 

  • 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. 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. Data size limit (of the aggregated data) is 1 Million cells (and not limited by the 2 MB size as for Browser Based Blending)
  • 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.  Tuple filters (filtering with multiple dimensions using the AND and OR operators) (which itself requires BW/4HANA 2.0 or BW on HANA 7.5 SP16 is not supported when blending.) For the minimum HANA requirements please see SAP Note 1600929
  • E) Tuple filters (filtering with multiple dimensions using the AND and OR operators) is not supported when using browser-based blending.
  • F) Requires HANA 2.0. 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).
  • G) Requires HANA 2.0 version 2.00.024.05 (EPMMDS 1.00.201815.00) or higher.  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)???. Data size limit (of the aggregated data) is 2 MB
  • H) Story level linking is supported when the data sources are S/4HANA with a Live Connection to the same S/4HANA instance/tenant using the very same connection as defined inside SAP Analytics Cloud (2 connections sharing the same connection properties are not enough)
  • I) 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.  Tuple filters (filtering with multiple dimensions using the AND and OR operators) (which itself requires BW/4HANA 2.0 or BW on HANA 7.5 SP16 is not supported when blending. Blending of 2 different queries from 2 different BW systems is supported as long as the BW systems fulfil the system requirements for blending.
  • J) Requires one of the following:
    • BW 7.5 (On any database. See SAP Note 2737952 for more details)
    • OR SAP BW4/HANA 1.0 SP12 (See SAP Note 2737953 for more details).
    • OR SAP S/4 HANA on-premise.
      Data size limit (of the aggregated data) is 6 MB. Blending is always processed in the SAP Analytics Cloud. 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. Blending of 2 different queries from 2 different BW systems is supported as long as the BW systems fulfil the system requirements for blending.
    • SAP Note 2541557. For S/4 HANA (on-premise) browser based blending support status and this includes the S/4 HANA (on-premise) with BW versions
  • L) Not supported, but browser based blending does work with the combination of SAP Cloud Platform hosting HANA 2.0 when SAP Cloud Platform itself is on Cloud Foundry (not NEO)

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

Features applicable for Tables and Charts
  Live connectionImport connection 
  HANAHANA Cloud Plat- formBWS/4BPCUniverseBWBPCUniverseGeneral 
Measures 
  
Create Measures: Calculated Measure / Restricted Measure(tick)(tick) (tick)(tick) (M)(tick)    
Create Measure: Difference from
(this is comparisons over time periods, like YoY etc.)
(tick) (Q)(error)(error)(error) (error)(tick)    
Create Measure: Aggregation(tick) (N)(error)(tick)(Planned Q3 2019) (X)(warning) (Planned) (AA)(error)(tick) (AG) (wave 2019.16)(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) (V)(tick) (P) (Q)(error)(error)(error)(error)     
Filter on Measures (on: Story, Page, Widget)(tick) (Q) (T)(error)(error)(error)(error) (F) (Planned)(tick)(tick)(tick)(tick) 
Ranking Top N filtering on hierarchies(tick)(error)(error)(error) (error)     
Ranking Top N filtering on flat dimensions(tick)(tick)(tick)(tick) (tick)     
Sorting  (tick)  (tick) (tick)    
Currency Conversion (tick)  n/a   (tick) 
 Dimensions      Hierarchies and drill(tick)   (error)(tick)    
Filter on Dimensions(tick)(tick)(tick) (H) (tick)(tick)(tick)(tick)  
Dimension Linking
(not blending)
 (tick)(error) (error) (Planned)(tick)    
Calculated Dimension by concatenating two dimensions(tick)  (error)(error) (Planned)     
Calculated Dimension by grouping members(tick) (B)(error)(error)(error)(error)   (tick) 
Calculated Measure-based Dimensions(tick) (Q)(error)(error)(error)(error)(tick)  (tick) (Planned) 
Custom Sorting of Dimensions (R)(tick) (Planned for tables. Charts supported today) (Q)(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
Advanced Filter (tuple filters)Tuple General Support (AND/OR) (tick) (AE)(tick) (AH)(tick)(AE)(tick)     
Can Exclude (error)(error)(error)(tick)     

Can contain Hierarchy

 (tick) (AE)(tick) (AH)(tick)? (AE)(error)     
Can filter Currency Unit (error) (error)(error)     

Can be used with
Blending

 (error) (error)(error)     
Linked analysis support if the receiver widget already has a tuple filter applied (tick) (tick)      
 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(tick)(tick) (Y)(tick) (Y) (tick)     
 Positioning of Currency/Scale (i.e. €50 v 50€) based on Service setting(tick) (Q)(tick) (S)      (tick) Planned 
 Hyperlink (enables dynamic URL containing dimension value)(tick)(tick)(tick)(tick)(tick)(tick)(tick)(tick)(tick)Limited to 1 URL per widget (chart/table). Measure values can not be included in the URL. If needed, create a dimension of the measure. If more than one URL is needed consider Application Building
  • M) requires BI 4.2 SP4 Patch 3
  • AA) requires S/4HANA 1909 (on-premise) or S4/HANA 1911 (cloud)
  • AE) requires BW/4HANA 2.0 or BW on HANA 7.5 Support Pack 16. Queries with two structures is not supported.
  • AG) requires your SAP Analytics Cloud service to be on version 2019.16 or greater. Supports Count, Count excluding Null, Count excluding 0 and null, Min, Max, Average. Conditional aggregation is not yet supported.
  • AH) requires S/4 HANA 1909 (on premise) or S/4 HANA 1911 (cloud)
Features particular to Charts
  Live connectionImport connection 
  HANAHANA Cloud PlatformBWS/4BPCUniverseBWBPCUniverseGeneral 
Waterfall ChartsGeneral Support(tick)(tick) (Z)(tick)(error) (tick)  (tick) 
Time Series ChartsGeneral Support(tick) (B)(tick)(error)(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 in the x-axis Y, M, D  (error)     
VarianceMeasure compared with another Measure(tick) (A?)(tick) (X)(tick) (X)(error)(error)   (tick) 
Based on Version(tick) (A)(tick) (X)(tick) (X)(error)(error)   (tick) 
Based on Time Hierarchy(tick) (U)(error) (Planned Q4 2019) (X)

(error)(Planned Q4 2019) (X)

(error)(error)   (tick) 
HistogramGeneral Support(tick) (Q)  (error)    (tick) 
Dynamic Image WidgetGeneral Support(tick) (Planned) (B)(error)(error)(error)(error)(error)(error)(error)(error) 
GeoMapsGeneral support(tick) (D)(warning) (AB)(tick) (E)(error)(error)(error)(tick)(error) (tick) 
Hierarchies(error)(tick) (E)  (error)   (tick) 
  • AB) HANA 2.0 on SAP Cloud Platform does not currently support GeoMaps
  • E) Supported in general, some exceptions: For GeoMap the Choropleth layer is supported for BW 7.5 SP16 or higher and BW/HANA 2.0 SP4 or higher. Please see SAP Note 2715030. The dimension needs to be configured in SAP BW as geo relevant. To use the choropleth layer in SAC, the attributes 0LONGITUDE and 0LATITUDE need to be maintained. Please refer to documentation for more details.
  • X) Support for variance based on 'time' for BW 7.5 Support Pack 16. Support planned for BW4/HANA at a later time. See SAP Note 2715030
Features particular to Tables
  Live connectionImport connection 
  HANAHANA Cloud PlatformBWS/4BPCUniverseBWBPCUniverseGeneral 
TablesTable totals, when a Top N filter is applied(tick)(error)(error) (error) (Planned)     
Sorting (tick)  (tick)(tick)  (tick) 
Custom Sorting of Dimensions(tick) (Q)(error)(error)(error)(error)   (tick) 
Export Data as CSV (tick)(error) (tick)(tick)  (tick) 
Re-order (custom order) measures (tick) (AC)        
Re-order (custom order) account dimensions(error)(error)(error)(error)(error)   (tick) (AD) 
  • AC) Ordering of measures is only possible when measures are not in a hierarchy
  • AD) Ordering can be performed at the same hierarchy depth. You can not re-organise the hierarchy.
Explorer
  Live connectionImport connection 
  HANAHANA Cloud PlatformBWS/4BPCUniverseBWBPCUniverseGeneral 
ExplorationSearch on dimension value (error)(error)(error)(error)   (tick) 
Exclude Dimension value (error) (error)(tick)   (tick) 
Dimension sorting on hierarchies (error) (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
  • D) Documentation reference, also SAP Note 2404590
  • 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
  • V) Both dates need to be from the same model
  • W) Re-ordering measures is support when the measures are not in a hierarchy. 
  • Y) Threshold measure to measure comparison is not currently support for BW live or S4 live connections.
  • Z) Waterfall charts require BW 7.5 (any DB, or HANA) or BW/4HANA. See SAP Note 2715030
Prompts
  Live connection
  HANAHANA Cloud PlatformBWS/4BPCUniverse
PromptsDate Picker(tick)(tick) (tick)  (tick)
      

Prompts are not applicable for Imported data.


Story level formula

 Live connectionImport Data
 HANABWS4BPCUniverse 
Length(tick) (A)    (tick)
SubString(tick) (A)    (tick)
Like(tick) (A)    (tick)
ToNumber(tick) (A)    (error)
ToText(tick) (A)    (error)
%GrandTotal(error)(tick) (B)   (tick)
ABS(error)    (tick)
Double(error)    (tick)
Float(error)    (tick)
GrandTotal(error)(tick) (B)   (tick)
If(error)    (tick)
INT(error)    (tick)
IsNull(error)    (tick)
Log(error)    (tick)
Log10(error)    (tick)
Not(error)    (tick)
Power(error)    (tick)
ResultLookup(error)    (tick)
  • A) Requires HANA 2.0
  • B) Available from SAC wave 2019.17

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
Based uponFeatureHANABWS/4BPCUniverseAll import connections
Models






'Time series' Chart time series forecast (Analytical Models)(tick)(tick)(tick) (tick) (B)(tick)
Line Chart Time Series Forecasting (Analytical Models)(error)(error)(error)(error)(error)(tick)
R Visualisations(tick) (A)(tick) (A)(tick) (A) (tick) (A)(tick)
Search to Insights (H)(tick) (I)(tick)(tick)(error)(error)(tick)
Smart Discovery, including Simulation (E)(error)(error)(error)(error)(error)(tick)
Smart Insights (D)(error)(error)(error)(error)(error)(tick)
Smart Grouping (on Bubble and Scatter Plot Charts)(tick)(tick)(tick) (tick)(tick)
Data SetsSmart Predict (the source is the 'Data Set') (warning) (C)(tick) (G)(error)(error)(error)(error)(warning) (F)
  • (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. Requires that SAP Analytics Cloud is hosted on a non-SAP data centre. A two-digit number in your SAP Analytics Cloud URL, for example eu10 or us30, indicates a non-SAP data centre.
  • (D) Dimensions with > 1,000 members are not considered, Calculated measures not supported as targets.
  • (E) Data size limitation of 1 million cells, (calculated as number of measures * number of rows).
  • (F) Data sets can be created from the following data sources:
  • File and File Server
  • SAP HANA
    • On-premise sources. Cloud sources not currently supported
    • Username/password authentication is supported only
    • Connectivity is JDBC
  • SAP S/4 HANA
    • Cloud and on-premise editions supported
    • Basic Authentication or no Authentication (i.e. delegated) is supported only.
    • Connectivity is OData
  • SQL Databases (On-premise sources)
  • –Generic OData (Cloud and On-premise sources)
  • –SAP SuccessFctors
  • –SAP Business ByDesign
  • –SAP Cloud for Customer
  • –SAP Cloud for Customer Analytics
  • –SAP Integrated Business Planning
  • SAP Cloud Platform Open Connectors (including but not limited to: Amazon S3, Dropbox, Egnyte. Microsoft Dynamic CRM, Microsoft OneDrive, Netsuite CRM 2018 Release 1)
    Please remember note (C) applies.
  • (G) Support for HANA on-premise only. When HANA is hosted in the Cloud it is NOT supported. Supported on-premise HANA versions are SAP HANA 1.0 SPSP12 rev 122.04 and beyond; SAP HANA 2.0 SPS00, SPS01, and SPS02; SAP HANA 2.0 SPS03 and beyond are supported (always check the official documentation and SAP Note 2444261). Supported: SAP HANA tables (row store or column store), and SAP HANA SQL Views. Not supported: HANA Calc views. Please remember note (C) applies.
  • (H) Supported on live models that have an index created on them. Once a live model is indexed, metadata such as dimension and measure names, and dimension members, is stored on SAP servers. Measure values are never stored. Index a model by editing the model preferences. Acquired (imported data) models are supported when there is no data access controls defined upon them.
  • (I) Requires SAP HANA 1.0 SPS12 rev 122.14 or higher

Applications

API

Functionality 
postMessage()(tick)
onPostMessageReceived(tick)
OData Services(tick)

Data Analyzer

 Live connectionsImport Connections
 HANABWS/4BPCUniverseAll import connections
Connect to and query(error)(tick)(error)(error)(error)(error)

Features in Stories, not yet in Applications

 

This table shows if a feature available in Stories, if the same feature available in Applications.
(warning) Please remember that the same connectivity limitation apply for Applications are they do for Stories. It means if something is not listed here, because the feature is supported in Applications as it is in Stories, then you must still also check the connectivity requirements.

FeatureAvailable in Applications
GeoMaps(warning) Planned
Blending(error)
Mobile Support(error)
Export to PDF/XLS/CSV(error)
Digital Boardroom Integration(error)

 

Life Cycle Management

Import/Export Support

 

 ObjectImport (Upload)Export (Download)Comments
Security


Team(error)(error) 
Role(tick)(tick) 
User(tick)(tick) 
Public Folder Contents






Acquired Analytics Model (tick)(tick) 
Acquired Planning ModelPublic Versions(tick)(tick) 
Private Versions(error)(error) 
Live Model(tick)(tick) 
Dimensions(tick)(tick) 
Story(tick)(tick)Planned from wave 2019.20 to include translated text
Digital Boardroom(tick)(tick) 
Analytical Application(tick)(tick) 
BookmarksGlobal(tick)
(see comments)
(tick)Default bookmarks are always included. However, 'suggested defaults' are not imported. A 'suggested default' occurs when more than 1 global bookmark is shared, each with their own default. Here a user selects which one is the 'default' and this is 'suggested default'.
Private(tick)
(see comments)
(tick)

User (who owns the bookmark) must already exist in target system for private bookmarks to be preserved, otherwise they are 'dropped'.
The sharing relations are always preserved when imported into a target system, even if the recipient user doesn’t exist yet. Once the user has been created it will automatically be granted access to the bookmark. The user is identified by the userID, so the userID will need be consistent across systems.

Personal Folder Contents(all files)(error)(error) 
Team Folder Contents(all files)(error)(error) 
Data Models etcDimension(tick)(tick) 
Wrangler(tick)(tick) 
Currency(tick)(tick) 
Allocation Step(tick)(tick) 
Allocation Process(tick)(tick) 
Value Driver Tree(tick)(tick) 
Point of Interest(error)(error) 
Task(Calendar) Task(warning)(warning)Generally not expected to be an object that should be 'transported'. Contact your SAP representative for feature availability
ProcessProcess(warning)(warning)Generally not expected to be an object that should be 'transported'. Contact your SAP representative for feature availability
ConnectionsConnection - Live    
Connection - Acquired    
PAi (Predictive Analytics Integrator) (error)(error) 
SAP Analytics Hub (A)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) (tick)(tick) 
Hub Contents - Assets (Drafts) (tick)(tick) 
Hub Contents - Uploaded pictures (tick)(tick) 
Hub Contents - User Data (tick)(tick) 
Hub Contents - User Data - Favourites (tick)(tick) 
Hub Contents - Picked for you (tick)(tick) 
Hub Contents - Usage Data (tick)(tick) 
  • (A) Upload file size limit is 100 MB. Additionally when uploading a full 'reset' is required.

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
    

Maximum limits

  Limit ValueComments
Input ControlMaximum unique values4000
  • Input controls for flat dimensions are NOT limited to 4000 members as the search allows access to any number of values when the 'All Members' option is selected.
  • For static filters where story designers have fixed selections then the 4000 limit still applies.
  • De-selecting values can result in an 'exclude'. This could cause an issue when dimensions are linked.
  • This is also supported for BW live connections except that for BW cascading filters are not supported.
Export Story As 'PDF'Batch Exporting - Maximum number of values in Input Control4000 
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'
Geo DimensionMaximum members that can be geo-enriched based upon latitude and longitudes1,000,000

This is within the data preparation phase for acquired data. Previous limit was 200,000.

Data AcquisitionGoogle Sheets5 million cells per sheetRestriction applied by Google

API

/api/v1/scimuserteamrole
create(tick)(tick)(error)
read(tick)(tick)(tick)
update(tick)(tick) (A) (C)(tick) (A)
delete(tick) (B)(tick)(tick)
assign roles to(tick)(tick)n/a
set user preferences(tick)n/an/a
  • A) Current limitation on 'Cloud Foundry' with regard to reading specific 'Group' (team/role) and putting a 'Group' (team/role) as all members are needed to be set not just new ones.
  • B) Content (private, team and public) owned by the user is transferred to a user with the 'admin' role however not all content types are transferred, some non-private folder content is left without a clear owner. More clarity to follow.
  • C) A current limitation for some data centres (Cloud Foundry) is that team updates are only possible via the API if the team was also created via the API
  • No labels