URL
The permanent, unchangeable, URL for this page is https://wiki.scn.sap.com/wiki/x/dAfIH
Please use this URL as your bookmark. It will allow the page to be renamed and your bookmark will remain valid.
This wiki page is, and will always be, in development. Any 'white space' simply means the wikis' author has not yet validated if that feature is supported or not.
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.
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.
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.
Terminology
Term used in this wiki | Unless otherwise mentioned, refers to |
---|---|
HANA | HANA 1.0 and 2,0 on premise, HANA on SAP Cloud Platform, SAP HANA Cloud |
BW | BW on any DB, BW on SAP HANA, BW/4HANA |
Models
Live Model Support
On Premise (or SAP HEC) | SAP Cloud Platform | SAP HANA Cloud | Key References | Additional Comments | |
---|---|---|---|---|---|
HANA v1 |
|
| n/a | ||
HANA v2 |
| n/a |
| ||
HANA Cloud | n/a | n/a | |||
BW
| n/a |
|
| ||
BPC | n/a | Planning functionalities supported in SAC live connection to BPC Embedded Model
| Embedded model | ||
S/4 |
|
| |||
Universe | n/a |
|
- (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.
- (F) Star date join requires calculation view to be created.
Related and useful references:
- Error "Failed to connect to system in SAP Analytics Cloud" when defining a live connection - KBA 2544696
Live Model Connection Support
Connections Types: | means the connection is made.. | Applicable for (still need to check if the configuration is supported, even if it is applicable) | ||||
---|---|---|---|---|---|---|
Regular browser interface | SAP Analytics Cloud Mobile App | Scheduling/Publishing | Indexing of selected Metadata to enable Search To Insight (de-selection of dimensions is possible) | SAP Analysis for Office Edition for SAP Analytics Cloud SAP Analytics Cloud Add-in for Microsoft Office | ||
DIRECT and DIRECT+CC (Both are only applicable for on-premise sources) | DIRECT from the client directly to the database and the cloud servers are not involved in that connection. It means the client needs to access the source directly, either because its within the organisation network (or connected via a VPN) or the source is exposed to the internet for access outside of the organisation network. DIRECT+CC 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 directly 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 enabled on a regular 'direct' live connection, via the Advanced Features, and once the option 'Menu-Administration-Datasource Configuration-Live Data Sources' has been enabled. This option is not applicable for the regular browser interface, for that please use a 'Tunnel' connection. | DIRECT DIRECT+CC | DIRECT DIRECT+CC | DIRECT DIRECT+CC | DIRECT DIRECT+CC | DIRECT DIRECT+CC |
TUNNEL (only applicable for on-premise sources) | 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 'tunnel' live connection and can be created once the option 'Menu-Administration-Datasource Configuration-Live Data Sources' has been enabled. This option is applicable for the regular browser interface, unlike the 'Direct+CC' option. | TUNNEL | TUNNEL | TUNNEL | TUNNEL | TUNNEL Although applicable, currently not supported |
CLOUD | from cloud servers to other cloud servers. This option includes 'SAP HANA Cloud', 'SAP Cloud Platform' and 'SAP S/4HANA Cloud' | CLOUD | CLOUD | CLOUD | CLOUD | CLOUD |
Warning - a DIRECT connection can be changed to DIRECT+CC but not back again.
Browser Desktop Live Connection Support
DIRECT+CC is not applicable for the regular browser interface.
HANA | BW (on premise) | BPC | S/4 | Universe | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HANA (on premise) | HANA (SAP Cloud Platform) | HANA (SAP HANA Cloud) | S/4 (on premise) (L) | S/4 (Cloud) (L) | |||||||||||
Required Components | SAP Cloud Connector (SCC) | ||||||||||||||
SAP Cloud Agent | |||||||||||||||
Browser (desktop) | Connection | Type | DIRECT (B) | TUNNEL | CLOUD | CLOUD | DIRECT | TUNNEL | DIRECT | TUNNEL (planned 2022.5) | DIRECT (F) | TUNNEL | CLOUD | DIRECT (C) (D) | TUNNEL |
Authentication Support | Username and password | ||||||||||||||
SSO | SAML | SAML | SAML | SAML | SAML | SAML | SAML | SAML | SAML (I) | SAML (I) | OAUTH (M) | SAML (E) | SAML | ||
None (delegated, such as X509, Kerberos, SAP Logon Token) | |||||||||||||||
HTTP | Protocol | 1 | 1 | 1 | 2 (O) | 1 | 1 | 1 |
Mobile App Live Connection Support
DIRECT is applicable for the SAP Mobile Application, but it requires the Mobile device to be connected to the organisation network either directly, via a proxy (exposing the database) or via a Virtual Private Network. Typically a 'Direct' connection for mobile applications is not preferred.
TUNNEL is applicable for the SAP Mobile Application and means that the mobile device can enjoy live connectivity to on-premise source without the need for a VPN and without the need to expose the on-premise source directly to the internet (instead SAC will act as a proxy)
HANA | BW (on premise) | BPC | S/4 | Universe | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HANA (on premise) | HANA | HANA (SAP HANA Cloud) | BPC embedded (P) | S/4 | S/4 (Cloud) (L) | ||||||||||
Required Components | SAP Cloud Connector (SCC) | ||||||||||||||
SAP Cloud Agent | |||||||||||||||
Mobile App | Reverse Proxy (DIRECT connection) | Apache | n/a | ||||||||||||
SAP Web Dispatcher | |||||||||||||||
Connection | Type for iOS | DIRECT | DIRECT+CC | DIRECT | DIRECT+CC | DIRECT | DIRECT+CC | DIRECT | DIRECT+CC | ||||||
Type for Android | DIRECT | TUNNEL | DIRECT | TUNNEL | DIRECT | TUNNEL | DIRECT | ||||||||
Authentication | Username and password | ||||||||||||||
SSO | SAML | SAML | SAML | SAML | SAML | SAML | |||||||||
None (delegated, such as X509, Kerberos, SAP Logon Token) | |||||||||||||||
HTTP | Protocol | 1 | 1 | 1 | 2 (O) | 2 | 1 | 1 | 1 |
Schedule Publication Live Connection Support
HANA | BW (on premise) | BPC | S/4 | Universe | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|
HANA (on premise) | HANA (SAP Cloud Platform) | HANA (SAP HANA Cloud) | S/4 (on premise) (L) | S/4 (Cloud) (L) | |||||||
Required Components | SAP Cloud Connector (SCC) | | |||||||||
SAP Cloud Agent | | ||||||||||
Schedule Publication | Connection | Type | DIRECT+CC (N) | DIRECT+CC | DIRECT+CC | TUNNEL | |||||
Authentication | Username and password | ||||||||||
SSO | |||||||||||
None (delegated, such as X509, Kerberos, SAP Logon Token) | |||||||||||
(the above table needs many improvements)
- 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) Requires HANA 2.0
- O) HTTP 2 is 'disabled' when SPNego authentication is used, instead HTTP 1.1 is used which means a possible performance impact compared to other Authentication methods. Consider X509 certificate in this case. KBA 3126093
- P) Tunnel connection support for BPC embedded is only supported for the browser and not for SAC mobile applications.
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 Additional Features plus defect and performance improvements | Note Analyser file name found in SAP Note 2541557 |
---|---|---|---|
2019.21 | Yes (Q4 QRC) | Same as 2019.18 | SAP_BW_Analytics_Cloud_Connection_wave18_onwards_withsomeNotesAfterSP16.xml |
2019.22 | No | SAP Note 2541557 | SAP_BW_Analytics_Cloud_Connection_wave22_onwards_being.xml |
2019.23 | No | SAP Note 2541557 | SAP_BW_Analytics_Cloud_Connection_wave23_onwards_being.xml |
2019.24 | No | Same as 2019.23 | Updated 10/Jan/2020, 24/Jan/2020, 31/Jan/2020, 24/Feb/2020 with fixes. SAP_BW_Analytics_Cloud_Connection_for_2019_onwards_being.xml |
2020.01 | No | Same as 2019.23 | Updated 10/Jan/2020, 24/Jan/2020, 31/Jan/2020, 24/Feb/2020 with fixes. SAP_BW_Analytics_Cloud_Connection_for_2019_onwards_being.xml |
2020.02 | Yes (Q1 QRC) | Same as 2019.23 | Updated 10/Jan/2020, 24/Jan/2020, 31/Jan/2020, 24/Feb/2020 with fixes. SAP_BW_Analytics_Cloud_Connection_for_2019_onwards_being.xml |
2020.03 | No | Same as 2019.23 | Updated 10/Jan/2020, 24/Jan/2020, 31/Jan/2020, 24/Feb/2020 with fixes. SAP_BW_Analytics_Cloud_Connection_for_2019_onwards_being.xml |
2020.04 | No | Same as 2019.23 | Updated 10/Jan/2020, 24/Jan/2020, 31/Jan/2020, 24/Feb/2020 with fixes. SAP_BW_Analytics_Cloud_Connection_for_2019_onwards_being.xml |
2020.05 | No | Same as 2019.23 | Updated 10/Jan/2020, 24/Jan/2020, 31/Jan/2020, 24/Feb/2020 with fixes. SAP_BW_Analytics_Cloud_Connection_for_2019_onwards_being.xml |
2020.06 | No | Same as 2019.23 | Updated 10/Jan/2020, 24/Jan/2020, 31/Jan/2020, 24/Feb/2020 with fixes. SAP_BW_Analytics_Cloud_Connection_for_2019_onwards_being.xml |
2020.07 | No | Same as 2019.23 | Updated 10/Jan/2020, 24/Jan/2020, 31/Jan/2020, 24/Feb/2020 with fixes. SAP_BW_Analytics_Cloud_Connection_for_2019_onwards_being.xml |
2020.08 | Yes (Q2 QRC) | Same as 2019.23 | Updated 10/Jan/2020, 24/Jan/2020, 31/Jan/2020, 24/Feb/2020 with fixes. SAP_BW_Analytics_Cloud_Connection_for_2019_onwards_being.xml |
2020.09 | No | SAP Note 2541557 | SAP_BW_Analytics_Cloud_Connection_2020-04-08.xml |
2020.10 | No | Same as 2020.09 | SAP_BW_Analytics_Cloud_Connection_2020-04-08.xml |
2020.11 | No | Same as 2020.09 | SAP_BW_Analytics_Cloud_Connection_2020-04-08.xml |
2020.12 | No | SAP Note 2541557 | SAP_BW_Analytics_Cloud_Connection_2020-05-27.xml |
2020.13 | No | Same as 2020.12 | SAP_BW_Analytics_Cloud_Connection_2020-05-27.xml |
2020.14 | Yes (Q3 QRC) | Same as 2020.12 | SAP_BW_Analytics_Cloud_Connection_2020-05-27.xml |
2020.15 | No | Same as 2020.12 | SAP_BW_Analytics_Cloud_Connection_2020-05-27.xml |
2020.16 | No | Same as 2020.12 | SAP_BW_Analytics_Cloud_Connection_2020-05-27.xml |
2020.17 | No | Same as 2020.12 | SAP_BW_Analytics_Cloud_Connection_2020-05-27.xml |
2020.18 | No | SAP Note 2541557 | SAP_BW_Analytics_Cloud_Connection_2020-08-18.xml |
2020.19 | No | Same as 2020.18 | SAP_BW_Analytics_Cloud_Connection_2020-08-18.xml |
2020.20 | No | Same as 2020.18 | SAP_BW_Analytics_Cloud_Connection_2020-08-18.xml |
2020.21 | Yes (Q4 QRC) | Same as 2020.18 | SAP_BW_Analytics_Cloud_Connection_2020-08-18.xml |
2020.22 | No | Same as 2020.18 | SAP_BW_Analytics_Cloud_Connection_2020-08-18.xml |
In general, we recommend applying the latest SAP Notes referenced by SAP Note 2541557 even if your SAP Analytics Cloud service is not yet on the related version. An 'older' Quarterly Release version will always be supported on the most recent notes referenced by SAP Note 2541557.
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 feature | Supported in SAP Analytics Cloud | |
---|---|---|
Table | Hierarchy - Show node above | |
Table/Chart | Use a fixed value for a dynamic variable (customer/BW exit variables) |
Requirements https://launchpad.support.sap.com/#/notes/2541557
Live BPC Support
BPC feature | Supported in SAP Analytics Cloud |
---|---|
workstatus | |
Disaggregation | |
Formula | |
Cell Locking |
Live Universe Support
SAP Analytics Cloud Wave and Live Universe Connector Support Matrix
Live Universe Connector Version | SAP Analytics Cloud Wave 2020.02 and onwards |
---|---|
Version 2.03 (v2 SP3) | |
Version 2.04 (v2 SP4) |
KBA 2771921 Version 2 Release information and download
- Live Connection System Requirements
- Limitations to SAP Universe Live Data
- A single Universe context is supported, multiple Universe Contexts resulting in more than 1 dataset isn't supported.
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' version | Minimum SAP Analytics Cloud Agent version required | SAP Cloud Connector (A) | ||||||
---|---|---|---|---|---|---|---|---|---|---|
SAP HANA view (on-premise) | SAP ERP/ SQL Database | SAP Universe | SAP BW | SAP BPC (standard) | SAP BPC (embedded) | All others | ||||
2019.8 | Yes | 1.0.225 | 1.0.99 | 1.0.91 | 1.0.109 | 1.0.75 | ||||
2019.13 | No | 1.0.233 | 1.0.99 | 1.0.91 | 1.0.231 | 1.0.75 | ||||
2019.14 | No | 1.0.235 | 1.0.99 | 1.0.91 | 1.0.233 | 1.0.75 | ||||
2019.15 | Yes Q3 2019 | 1.0.237 | 1.0.99 | 1.0.91 | 1.0.233 | 1.0.75 | 2.12.x (B) | |||
2019.21 | Yes Q4 2019 | 1.0.248 | 1.0.235 | 1.0.99 | 1.0.91 | 1.0.233 | 1.0.75 | 1.0.109 | 1.0.75 | 2.12.x (B) |
2020.02 | Yes Q1 2020 | 1.0.257 | 1.0.235 | 1.0.99 | 1.0.91 | 1.0.233 | 1.0.75 | 1.0.109 | 1.0.75 | 2.12.x (B) |
2020.08 | Yes Q2 2020 | 1.0.271 | 1.0.235 | 1.0.99 | 1.0.91 | 1.0.233 | 1.0.75 | 1.0.75 | ||
2020.14 | Yes Q3 2020 | 1.0.235 | 1.0.99 | 1.0.91 | 1.0.233 | 1.0.75 | 1.0.75 | |||
2020.15 | No | 1.0.235 | 1.0.99 | 1.0.91 | 1.0.233 | 1.0.75 | 1.0.75 | |||
2020.16 | No | 1.0.235 | 1.0.99 | 1.0.91 | 1.0.233 | 1.0.75 | 1.0.75 | |||
2020.17 | No | 1.0.235 | 1.0.99 | 1.0.91 | 1.0.233 | 1.0.75 | 1.0.75 | |||
2020.18 | No | 1.0.235 | 1.0.99 | 1.0.91 | 1.0.233 | 1.0.75 | 1.0.75 | |||
2020.19 | No | 1.0.235 | 1.0.99 | 1.0.91 | 1.0.233 | 1.0.75 | 1.0.75 | |||
2020.20 | No | 1.0.235 | 1.0.99 | 1.0.91 | 1.0.233 | 1.0.75 | 1.0.75 | |||
2020.21 | Yes Q4 2020 | 1.0.297 | 1.0.235 | 1.0.99 | 1.0.91 | 1.0.233 | 1.0.75 | 1.0.75 | ||
2020.22 | No | 1.0.235 | 1.0.99 | 1.0.91 | 1.0.233 | 1.0.75 | 1.0.75 |
- 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 and Dataset Scheduling Support (Import and Export)
Import | Export | |||
---|---|---|---|---|
Model | Dataset | Model | Dataset | |
Universe | ||||
CSV, Excel | ||||
Odata Cloud | ||||
Odata on-premise | ||||
HANA via OData | ||||
HANA via JDBC | ||||
HANA (via Query Builder accessing all view types) or HANA (via Freehand SQL accessing all tables and procedures) | ||||
BW 7.5 | ||||
BW4/HANA 2.0 | ||||
SAP S/4HANA | ||||
BPC (D) | ||||
SAP IBP (SAP Integrated Business Planning) |
Please note the table above is for 'schedule' support. There are many other data sources supported for manual exporting compared to scheduled exporting
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.
- E) Requires BW4/HANA 2.0 Support Pack 4. SAP Note 2838883 - SAC BW Writeback - Part 1 for details on current restrictions
- F) Requires BW 7.5 SP18 SAP Note 2942754
- G) XS Classic and XS Advanced (XSA) Views are supported (XSA is the successor of XS Classic). XSA is supported with HANA 1.0 SPS12 and HANA 2.0. XSA HAVA Views are not restricted to schema location of _SYS_BIC. XSA View prompts are supported)
Acquired Model Combining Data Support.
Feature | Value |
---|---|
Join types | Left outer, inner. Composite Joins with up to 3 keys are supported |
Maximum data sources | 10 |
Maximum cells (in all the data to be joined) | 30 million |
Modelling Supported Features
Live Connections | Import Data Connections | ||||||||
---|---|---|---|---|---|---|---|---|---|
HANA | HANA (SAP Cloud Platform) | HANA (SAP HANA Cloud) | BW | BPC | S4 | Universe | Models | Datasets | |
Planning Models | | | |||||||
Single Date Dimension | |||||||||
Multiple Date Dimensions | |||||||||
Parent-child hierarchy on Dimensions | |||||||||
Level-based hierarchy on Dimensions | |||||||||
Hierarchy on Measures | |||||||||
Hierarchy on Date (Years to Days, which is 'Time') | |||||||||
Hierarchy on Time (Hours to milliseconds) | |||||||||
Convert a date or string-based time dimension into a time hierarchy (aka time enrichment) | |||||||||
Version (aka Category) (i.e. supports actuals, budgets etc.) | |||||||||
Cross Calculations on tables and charts |
- 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) | Live (2.3) | Live (2.4) | Import Data into a Model | Import Data into a Dataset | |
---|---|---|---|---|---|---|---|---|
Build an SAP Analytics Cloud Model off a... | UNV Universes | |||||||
Relational UNX Universes (Single and Multi Source) | ||||||||
Stored Procedure Universe | ||||||||
JavaBeans Universe | ||||||||
Multi-dimension Universes based off OLAP connection | ||||||||
Web Intelligence Data Model | ||||||||
Platform | Minimum BI Platform Version | BI 4.2 Support Pack 5 or greater | BI 4.2 Support Pack 5 or greater | BI 4.2 Support Pack 5 or greater | BI 4.2 Support Pack 6 or greater | BI 4.2 Support Pack 7 or greater (but SP8 is recommended) | BI 4.1 Support Pack 5 or greater | |
Web Application Server | Tomcat 7 and 8+ (C) | Tomcat 7 and 8+ (C) | Tomcat 7 and 8+ (C) | Tomcat 7 and 8+ (C) | Tomcat 9 | Tomcat 7 | ||
Capabilities | Model enrichment | |||||||
Define Universe Query as a data source for model definition | ||||||||
Multi language support | ||||||||
BI Platform authentication | Enterprise | |||||||
LDAP | ||||||||
SAP | ||||||||
Windows Active Directory | ||||||||
Others |
- 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.1 | Live Connector Version 2.2 | Comments | ||
---|---|---|---|---|
Results pane | Dimensions (with Data Type 'String', 'Numeric') | |||
Dimensions (with Data Type 'Date' and 'DateTime') |
| |||
Attributes (Detail objects) |
| |||
Measures (with Project function: sum, count, average, min, max) | ||||
Measures (with Project function: database delegated) |
| |||
Add a combined Query |
| |||
Maximum number of objects | 150 | 150 |
| |
Filters pane | Business Layer Filter |
| ||
Dimensions of Types: String, Numeric |
| |||
Dimensions of Type Date |
| |||
Measures |
| |||
Prompts |
| |||
Sub Query | ||||
Database Ranking | ||||
Nested filters with AND/ORs | ||||
List of values | Simple List of values |
| ||
Cascading List of values | ||||
Display | Business Layer Views |
| ||
By Navigation Path |
| |||
Object Description |
|
Relational Universe Features
Feature | Live (2.x) | Import Data | Comments | |
---|---|---|---|---|
Data Foundation | Multiple Contexts |
| ||
Data types | Numeric |
| ||
Character | ||||
Date, DateTime | ||||
Measure Objects | Projection Function 'sum' |
| ||
Projection Function 'database delegated' |
| |||
Projection Function 'min', 'max' |
| |||
Projection Function 'count', 'count without empty' | ||||
Projection Function 'average' |
| |||
Details | Detail Objects | |||
Object Properties | Descriptions |
| ||
List of Values | Simple List of values (just a single column of values) |
| ||
Multiple columns | ||||
Cascading Prompts (which form a hierarchy) | ||||
Nested, Hierarchical |
| |||
Security | Universe Overload / Business Security Profiles and Data Security Profiles / Security Access Level |
| ||
Filters | Filters (defined in the query panel) or BI Sets | |||
@ functions | @Prompt (E), @WHERE, @SELECT, @AGGEGATE_AWARE, @Variable (H) |
| ||
Universe Optimisations | Index Awareness, Select optimisation (DISTINCT_VALUES) |
| ||
SQL Optimisation (ANSI_92), Inline views (BOUNDARY_WEIGHT_TABLE) (I) |
|
Planning Models
Model based off ... | |||
---|---|---|---|
SAP Analytics Cloud Feature | BPC Live connection | BPC Import Data | File (generic Planning model) |
Advanced Planning (Spreading / Allocations) | |||
Predictive | |||
Data Action | |||
Value Driver Tree |
Model and Dataset Formula
Model and Dataset Exception Aggregation Support
Live Connections | Import Connections | ||||||
---|---|---|---|---|---|---|---|
HANA | BW | BPC | S4 | Universe | Models | Datasets | |
Count | |||||||
Avg | |||||||
Sum | |||||||
Min | |||||||
Max | |||||||
First | |||||||
Last | |||||||
First Quartile | |||||||
Median | |||||||
Third Quartile |
A) Requires HANA baseline level 5
Acquired Datasets Wrangling, Model Wrangling and Model Formula Support
(click to sort) | Available in Data Wrangling for Datasets | Available in Data Wrangling for all Import Data Connections (available before model creation). Also known as 'Basic Data Preparation' | Available in Modeller for Acquired Data Sources (available after model creation) |
---|---|---|---|
If | |||
SubString/SubStr | |||
Trim | |||
Contain/Contains | |||
Concat/Concatenate | |||
Replace | |||
Length | |||
Like | |||
LowerCase | |||
UpperCase | |||
DateDiff | |||
DateAdd | |||
DayOfWeek | |||
ToDate | |||
MakeDate | |||
Abs | |||
Link | |||
LookUp | |||
Log | |||
Log10 | |||
Int | |||
Float | |||
Double | |||
Exp | |||
GrandTotal | |||
%GrandTotal | |||
Mod | |||
Min | |||
Max | |||
Sqrt | |||
Power | |||
Restrict | |||
RestrictLookup | |||
Round | |||
ToNumber | |||
ToText/ToString | |||
Trunc | |||
Ceil | |||
Floor | |||
Not | |||
IsNull | |||
CAGR (Compound Annual Growth Rate) | |||
SMA (Simple Moving Average | |||
YoY (Year over Year) | |||
element | |||
in | |||
exp10 | |||
Inverse | |||
InverseIf | |||
FindIndex | |||
Right | |||
Left | |||
EndsWith | |||
To Integer | |||
TitleCase | |||
Split | |||
Position | |||
ReplaceContent | |||
DayOfYear | |||
DurationDiff | |||
SecondsDiff | |||
ToTime | |||
TimeAdd | |||
MakeTime | |||
ExtractDay | |||
ExtractMonth | |||
ExtractYear | |||
ExtractQuarter | |||
DayName | |||
MonthName | |||
ToQuarterFormat |
Geospatial
Model Building
Reference page(s) | Comments | ||
---|---|---|---|
Geo coding by longitude and latitude | |||
Geo coding by name | Countries, Region and Subregion are supported. |
Points of Interest
Points of Interest | Reference page(s) | Comments | ||
---|---|---|---|---|
Create point of interest from a | model |
| ||
CSV or an Excel File | ||||
ESRI shape file |
Planning
General Planning
BPC Live Connection | Data Import Connections | ||
---|---|---|---|
Data Actions | |||
Value Driver Tree |
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 Cloud | SAP Analytics Cloud Add-in for Microsoft Office | |
---|---|---|
Microsoft Excel On-line (and thus supported on non-Windows platforms) | ||
Microsoft Excel Desktop | ||
Available on all data centres | (SAP Data Centres are not supported) | |
Life-cycle management support for SAP Analytics Cloud (C) |
A) Windows requires Microsoft Office edition 2002, or 2004, or 2005.
B) Supported browsers: Chrome, Safari, Firefox, Microsoft Edge.
C) Life-cycle Management support for SAP Analysis for Office edition for SAP Analysis for Office is supported when managed via the SAP BI Platform. Life-cycle Management is not currently supported with SAP Analytics Cloud since the Workbooks are not currently hosted inside SAP Analytics Cloud as a native application preventing them from being transported from one Service to another and allowing the workbook relationship to Service to be respected. i.e. the Model Service URL will always point to the current service where the Workbook would be stored in.
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) | ||
---|---|---|---|
Acquired | Analytical Model | ||
Planning Model | |||
Live | HANA | ||
BW | |||
S/4 | |||
Other |
Useful links
SAP Analytics Cloud Add-in for Microsoft Office
Planning use-case (write back) | Analysis use-case (read only) | ||
---|---|---|---|
Acquired | Analytical Model | n/a | |
Planning Model | |||
Live | all |
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:
- Native. This means the blending occurs within SAP Analytics Cloud 'natively'. No additional technology is needed.
- 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.
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 Connections | Import Connections | |||||||||||
HANA | BW | S/4 HANA | Models | Datasets | ||||||||
HANA | SAP Cloud Platform | BW on HANA or BW/4HANA | BW (on any DB) | S/4HANA On-Premise | S/4HANA Cloud | Others | ||||||
Primary Model | Live Connections | HANA | HANA | NATIVE (A) | SDI (B) BROWSER (G) | SDI (B) BROWSER (G) | ||||||
SAP Cloud Platform | NATIVE (F) | |||||||||||
BW | BW on HANA or BW/4HANA | SDI (I) BROWSER (J)(E) | BROWSER (J)(E) | SDI (I) BROWSER (D)(J) | SDI (C)(D) BROWSER (J)(E)(D) | SDI (C)(D) BROWSER (J)(E)(D) | ||||||
BW (on any DB) | BROWSER (J)(E) | BROWSER (J)(E) | BROWSER (J)(E) | BROWSER (J)(E)(D) | BROWSER (J)(E)(D) | |||||||
S/4 HANA | S/4 HANA (On-Premise) | SDI (I) BROWSER (J)(E) | BROWSER (J)(E) | NATIVE (H) | SDI (C)(D) BROWSER (J)(E)(D) | SDI (C)(D) BROWSER (J)(E)(D) | ||||||
S/4HANA Cloud | ||||||||||||
Others | ||||||||||||
Import Connections | Models | SDI (B) BROWSER (G) | SDI (C)(D) BROWSER (J)(E)(D) | BROWSER (J)(E)(D) | SDI (C)(D) BROWSER (J)(E) | NATIVE | NATIVE | |||||
Datasets | SDI (B) BROWSER (G) | SDI (C)(D) BROWSER (J)(E)(D) | BROWSER (J)(E)(D) | SDI (C)(D) BROWSER (J)(E) | NATIVE | 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) unless the model to blended is an account model, then the blending will occur in the SAP Analytics Cloud server. 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
- D) Blending of date dimensions with BW is currently not supported.
- 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 or different S/4HANA instance/tenant using the same or different connection as defined inside SAP Analytics Cloud
- 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. | Live | All Import connections (Models and Datasets) | |||||
---|---|---|---|---|---|---|---|
HANA | BW | S/4 | BPC | Universe | |||
Live | HANA | ||||||
BW | |||||||
S/4 | |||||||
BPC | |||||||
Universe | |||||||
All Import connections (Models and Datasets) |
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 connection | Import connections | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
HANA | HANA Cloud Plat- form | BW | S/4 | BPC | Universe | Models | Datasets | |||
Measures | Create Measures: Calculated Measure / Restricted Measure | |||||||||
Restricted Measures with constant selection on subset of dimensions |
| |||||||||
Create Measure: Difference from (this is comparisons over time periods, like YoY etc.) | ||||||||||
Create Measure: Aggregation |
| |||||||||
Create Measure: Date Difference (max, min, average, sum) on Y Q, M, Week, Day (B) (V) | ||||||||||
Filter on Measures (on: Story, Page, Widget) | ||||||||||
Ranking Top N filtering on hierarchies | | |||||||||
Ranking Top N filtering on flat dimensions | | |||||||||
Sorting | ||||||||||
Currency Conversion | n/a | |||||||||
Dimensions | Hierarchical Drill | |||||||||
Hierarchical expand / collapse | ||||||||||
Filter on Dimensions | ||||||||||
Dimension Linking (not blending) | ||||||||||
Calculated Dimension by concatenating two dimensions | ||||||||||
Calculated Dimension by grouping members | ||||||||||
Calculated Measure-based Dimensions | ||||||||||
Custom Sorting of Dimensions | ||||||||||
Dynamic Filter |
| |||||||||
Custom Hierarchy | ||||||||||
Advanced Filter (tuple filters) | Tuple General Support (AND/OR) | |||||||||
Can Exclude | ||||||||||
Can contain Hierarchy | ||||||||||
Can filter Currency Unit | ||||||||||
Can be used with | ||||||||||
Linked analysis support if the receiver widget already has a tuple filter applied | ||||||||||
Linked Analysis | ||||||||||
Dynamic Text in titles (Charts already supported, planned for tables) | ||||||||||
Thresholds | ||||||||||
Positioning of Currency/Scale (i.e. €50 v 50€) based on Service setting | ||||||||||
Hyperlink (enables dynamic URL containing dimension value) | 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 On-premise 1909 (SAP Note 2977218 is required) or S/4HANA Cloud 1911
- AE) requires BW/4HANA 2.0 or BW on HANA 7.5 Support Pack 16. Queries with two structures are 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)
- AI) requires BW 7.5 Support Pack 16 or BW4/HANA with 2.0 SP0. See SAP Note 2715030. First and Last aggregations can only contain one aggregation dimension, while other aggregations will have a limit of 5 dimensions
- AJ) also works with input controls. Requires BW 7.5 SP16 and SAP Note 2541557
- AK) supports universe drill paths (UNX) or universe custom hierarchies (UNV) and choose aggregation level in charts and tables (requires SAP Analytics Cloud 2020.5 (or 2020 Q2 QRC))
- AM) Requires BW/4HANA 2.0 SP4 or greater. See SAP Note 2715030
- AO) SAP Note 2788384 - "Unsupported Features with SAP BW, SAP S/4HANA and SAP BPC Embedded Model Live Connections in SAC" lists this as unsupported but that is only because the button, in the user interface, called 'Advanced Filtering...' is not available. Advanced filters can still be created by selecting data points in the widget, its just the create dialogue isn't available.
Features particular to Charts
Live connection | Import connections | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
HANA (On-premise) | HANA (SAP Cloud Platform) | HANA (SAP HANA Cloud) | BW | S/4 | BPC | Universe | Models | Datasets | |||
Waterfall Charts | General Support | ||||||||||
Time Series Charts | General Support | ||||||||||
Apply fixed and dynamic filters to Time series charts (Y, Q, M, D, Hr, Min, S, mS, Current Y/Q/M) | |||||||||||
Time series chart hierarchies supported in the x-axis | Y, M, D | ||||||||||
Variance | Measure compared with another Measure | ||||||||||
Based on Version | |||||||||||
Based on Time Hierarchy |
| ||||||||||
Histogram | General Support | | | | |||||||
Dynamic Image Widget | General Support | ||||||||||
GeoMaps | General support (see table below) | ||||||||||
Hierarchies | |||||||||||
Custom Hierarchies | |||||||||||
Other chart types | General Support |
- AB) HANA 2.0 on SAP Cloud Platform does not currently support GeoMaps. Planned feature (SAP internal reference FPA00-29155)
- AF) Waterfall charts on restricted key figures with the waterline dimension being used in the restriction or waterfall chart on 2 structure queries are not supported. See SAP Note 2415249
- AL) Requires BW/4HANA 2.0 SP4 or greater. See SAP Note 2715030. Supports also custom shapes
- AN) Attributes from location show up as dimensions when building a filter in the builder panel
- 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) Time granularity must include day level. Tuple filters are not supported. Variance on a single value range filters are invalid if the range is incomplete. Recommended comparisons using drill down is not supported. Requires BW 7.5 Support Pack 16 and SAP Note 2786890. Support for BW4/HANA requires 2.0 SP4. See SAP Note 2715030.
- AP) No support for Choropleth. Only supported with SAP delivered CDS views. Please see SAP Note 2715030 for details
Features particular to GeoMaps
Live connection | Import connections (Models and Datasets) | ||||||||
---|---|---|---|---|---|---|---|---|---|
HANA (On-premise) | HANA (SAP Cloud Platform) | HANA (SAP HANA Cloud) | BW | S/4 | BPC | Universe | |||
Layer | Bubble | ||||||||
Point of Interest | |||||||||
Heat Map | |||||||||
Choropleth | |||||||||
Feature | |||||||||
Flow | |||||||||
Geo Coding | by Long/Lat | ||||||||
by Area Name | |||||||||
ISO2 name | |||||||||
ISO3 name | |||||||||
Feature | Distance Slider | ||||||||
Intersection Filter | |||||||||
Overlapping Geo Points | |||||||||
Geo Chart Outliers | |||||||||
Custom Tooltips | |||||||||
Custom Choropleth Map | ? |
- (A) Available from Q4 2020 QRC (Wave version 2020.21 which is the QRC release). Requires 'Public Synonyms' to be enabled via System-Administration-System Configuration-Use Public Synonyms for Choropleth Layer. Requires HANA 2.0+ (SAP internal reference FPA00-29155)
Features particular to Tables
Live connection | Import connection | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
HANA | HANA Cloud Platform | BW | S/4 | BPC | Universe | BW | BPC | Universe | General | |||
Tables | Table totals, when a Top N filter is applied | |||||||||||
Sorting | ||||||||||||
Custom Sorting of Dimensions | ||||||||||||
Export Data as CSV | ||||||||||||
Re-order (custom order) measures | ||||||||||||
Re-order (custom order) account dimensions |
- 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 connection | Import connection | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
HANA | HANA Cloud Platform | BW | S/4 | BPC | Universe | BW | BPC | Universe | General | |||
Exploration | Search on dimension value | |||||||||||
Exclude Dimension value | ||||||||||||
Dimension sorting on hierarchies |
KPI
Live connection | Import connection | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
HANA | HANA Cloud Platform | BW | S/4 | BPC | Universe | BW | BPC | Universe | General | |||
KPI | Create KPI | |||||||||||
Alerts |
|
- 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 | |||||||
---|---|---|---|---|---|---|---|
HANA | HANA Cloud Platform | BW | S/4 | BPC | Universe | ||
Prompts | Date Picker | ||||||
Prompts are not applicable for Imported data.
Story level formula (aggregation based functions)
Live connection | Import Data | ||||||
---|---|---|---|---|---|---|---|
HANA | BW | S4 | BPC | Universe | Models | Datasets | |
Sum | |||||||
Count, excl null, excl null 0 | |||||||
Min | |||||||
Max | |||||||
Average, excl null, excl null 0 | |||||||
First | |||||||
Last | |||||||
Median, excl null, excl null 0 | |||||||
First Quartile, excl null, excl null 0 | |||||||
Third Quartile, excl null, excl null 0 | |||||||
Standard Deviation | | | | | | | |
- A) Requires HANA 2.0
Story level formula (row based functions)
Live connection | Import Data | |||||
---|---|---|---|---|---|---|
HANA | BW | S4 | BPC | Universe | ||
Length | ||||||
SubString | ||||||
Like | ||||||
ToNumber / INT | ||||||
ToText | ||||||
%GrandTotal | ||||||
ABS | ||||||
Double | ||||||
Float | ||||||
GrandTotal | ||||||
If | ||||||
IsNull | ||||||
Log | ||||||
Log10 | ||||||
Not | ||||||
Power | ||||||
ResultLookup | ||||||
Trim | ||||||
Replace | ||||||
Concat | ||||||
LowerCase | ||||||
UpperCase | ||||||
Split | ||||||
FindIndex | ||||||
EndsWith | ||||||
Right | ||||||
Left |
- A) Requires HANA 2.0
Commentary Widget
Live connections | Import Connections | ||||||
---|---|---|---|---|---|---|---|
HANA | BW | S/4 | BPC | Universe | Models | Datasets | |
Commentary |
Story Visualisation of GeoMaps
Reference page(s) | Comments | ||
---|---|---|---|
Show data from a single model | |||
Show data from multiple models in a single geomap visualisation |
| ||
Predictive
Live connections | Import Connections | ||||||
---|---|---|---|---|---|---|---|
Feature | HANA | BW | S/4 | BPC | Universe | Models | Datasets |
'Time series' Chart time series forecast (Analytical Models) | |||||||
Line Chart Time Series Forecasting (Analytical Models) | |||||||
R Visualisations | |||||||
Search to Insights (H) | |||||||
Smart Discovery, including Simulation (E) | |||||||
Smart Insights (D) | |||||||
Smart Grouping (on Bubble and Scatter Plot Charts) | |||||||
Smart Predict (the source is the 'Data Set') |
- (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
- AP 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. SAP HANA Cloud is also 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. Supported on SAC mobile app for iOS, currently not supported on Android.
- (I) Requires SAP HANA 1.0 SPS12 rev 122.14 or higher
- (J) Official documentation. Official limitations include No support for: SAP BTP (aka SAP Cloud Platform), Tunnel Connection, HANA Cloud, i.e. its only HANA Direct connections that are supported. Blog: How to setup Smart Insights on Live HANA
- (K) Smart insights on a variance chart is supported for acquired models and not for acquired datasets.
Applications
API
Functionality | |
---|---|
postMessage() | |
onPostMessageReceived | |
OData Services |
Data Analyzer
Live connections | Import Connections | |||||
---|---|---|---|---|---|---|
HANA | BW | S/4 | BPC | Universe | All import connections | |
Connect to and query |
Odata Service (export) API
Odata export | |||||||
---|---|---|---|---|---|---|---|
HANA | HANA (SAP Cloud Platform) | HANA (SAP HANA Cloud) | BW | S/4 | BPC | ||
Odata Service export API |
Features in Stories, not yet in Applications
This table shows if a feature available in Stories, if the same feature available in Applications. 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.
Feature | Available in Applications |
---|---|
GeoMaps | |
Blending | |
Mobile Support | |
Export to XLS/CSV | |
Digital Boardroom Integration |
- A) Story filter is not supported in the app. Story styling overrides created in the Digital Boardroom canvas are not supported on mobile.
- B) Support for iOS. Planned for Android
Life Cycle Management
Import/Export Support
Object | Import (Upload) | Export (Download) | Content Network | Comments | ||
---|---|---|---|---|---|---|
Security | Team | Performs an 'add' operation/action for the team to role relationship in the target. i.e. when TeamA is a member of Role1 in the target, a TeamA is a member of Role2 in the source, the result of TeamA in the target will be a member of Role1 and Role2. User membership of teams is not transported. Unsupported sample scripts 9xx transports these relationships. The samples also provide many other operations/actions for relationships between source and target. Team transports via the Content Network mean (for non-SAP data centres) the SCIM API can not be used to manage them (see wiki), so team transport is necessary for team folder content (see below 'Team Folder Contents') or use unsupported sample scripts just mentioned. | ||||
Role | ||||||
User | Unsupported sample scripts 9xx transports users and teams (the sample don't really transport a user or a team, as users' personal folders and team folders are not transported. User and team properties are simply read and written from source to target) | |||||
Public Folder Contents | Acquired Analytics Model | |||||
Acquired Planning Model | Public Versions | |||||
Private Versions | ||||||
Live Model | ||||||
Dimensions | ||||||
Story | Story | |||||
Comments | ||||||
Translated Text | ||||||
Value Driver Tree | ||||||
Digital Boardroom | ||||||
Analytical Application | ||||||
Custom link (friendly URL) | The custom link to the Story or Digital Boardroom object is stored and remains in the service where it is defined, even if an updated version of the object (identified by the ID) is transported in. i.e. the custom link remains valid even when the underlying object is updated. Custom links can not be transported. | |||||
Metadata of content published to Analytics Catalogue | Currently content published to Analytics Catalogue can not be imported/exported. It may be supported that the file itself (like a Story, Digital Boardroom etc.) can be imported/exported, but the additional Analytics Catalogue metadata associated with the file is not. | |||||
Bookmarks | Global | (see comments) | 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 | (see comments) | User (who owns the bookmark) must already exist in target system for private bookmarks to be preserved, otherwise they are 'dropped'. | ||||
Custom Widgets | ||||||
Predictive Scenario | ||||||
Data Set | ||||||
Point of Interest | ||||||
External Content (URL) | ||||||
Predictive Scenario | ||||||
Personal Folder Contents | (all files) | |||||
Teams | The team itself | Team membership is not included, i.e. any users in the team are not transported. Unsupported sample scripts 9xx "transports" the user, and user to team relationships (though the users' personal folder isn't transported. The user isn't really transported. See the link mentioned for details) | ||||
Team Folder Contents | (all files) | |||||
Data Models etc | Dimension | |||||
Wrangler | ||||||
Currency | ||||||
Allocation Step | ||||||
Allocation Process | ||||||
Value Driver Tree (legacy) | ||||||
Point of Interest | ||||||
Task | (Calendar) Task | Generally not expected to be an object that should be 'transported'. Contact your SAP representative for feature availability | ||||
Process | Process | Generally not expected to be an object that should be 'transported'. Contact your SAP representative for feature availability | ||||
Connections | Connection - Live | |||||
Connection - Acquired | ||||||
PAi (Predictive Analytics Integrator) | ||||||
SAP Analytics Hub (A) | Asset Structure | |||||
Asset Structure - Facets | ||||||
Branding | ||||||
Branding - Header | ||||||
Branding - Home Page | ||||||
Hub Contents - Assets (Visible, Hidden) | ||||||
Hub Contents - Assets (Drafts) | ||||||
Hub Contents - Uploaded pictures | ||||||
Hub Contents - User Data | ||||||
Hub Contents - User Data - Favourites | ||||||
Hub Contents - Picked for you | ||||||
Hub Contents - Usage Data |
When importing content into a target environment, the first time import of the package will create the content and subsequent imports will create/update the content and permissions set on it
- (A) Upload file size limit is 100 MB. Additionally when uploading a full 'reset' is required.
Relationships
Source Object in SAP Analytics Cloud | Reference by | To the object | where the object is held in |
---|---|---|---|
BW live Model | Technical name of the BEx query | BW BEx query | BW |
BW key figure or characteristic | Technical name of the key figure or characteristic | BW key figure or characteristic | in the BEx Query in BW |
Universe live Model | Universe name and path as stored in the BI Platform 'universe' folder | Universe | SAP BusinessObjects BI Platform |
Universe BusinessObject (Dimension, Measure etc.) | Object ID | Universe BusinessObject | SAP BusinessObjects BI Platform Universe |
Story Widget (Chart/Table) | Model name | Model (when models are in the 'Menu-Models' container) | SAP Analytics Cloud |
Model ID | Model (when models are stored in Public and Private Folders | SAP Analytics Cloud | |
Maximum limits
Limit Value | Comments | ||
---|---|---|---|
Input Control | Maximum unique values | 4000 |
|
Export Story As 'PDF' | Batch Exporting - Maximum number of values in Input Control | 4000 | |
Comment | Maximum comment threads per model | unlimited (previously was 100) |
|
Geo Dimension | Maximum members that can be geo-enriched based upon latitude and longitudes | 1,000,000 | This is within the data preparation phase for acquired data. Previous limit was 200,000. |
Data Acquisition | Models/Data Sets | Various | Please refer to Connectivity wiki for data acquisition limits |
Story export | Scope 'All' | 3 million cells |
|
Scope 'Point of View' | 500,000 cells |
| |
Content Network | Storage size | 300 MB | |
Publication | Delivery size of attachment(s) to Publication email | 12 MB | |
Time for SAP Analytics Cloud to generate the PDF for a single recipient before timing out and passing to the next recipient | 60 seconds | ||
Notifications per Scheduled Application | 3 | For both email and notification panel | |
External email addresses per publication | 3 | ||
Planning | Validation Rules per model | 3 | |
Dimensions per Validation Rule | 3 | Dimensions used to define dimension combination rules | |
API
/api/v1/scim | user | team | role |
---|---|---|---|
create | |||
read | |||
update | |||
delete | |||
assign roles to | n/a | ||
set user preferences | n/a | n/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 NOT transferred to another user, unlike using the user interface
- 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
This wiki page received 4290 visits in the year 2019.
2 Comments
Martijn van Foeken
Hi Matthew,
Quick question: is there a min. version for BW/4HANA to support the live connection from Analysis for Office for SAP Analytics Cloud?
Kind regards,
Martijn van Foeken | Interdobs
Matthew Shaw
I suspect 2656100 applies, but best to log a support incident to confirm as its a little unclear.