EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB46356: Support of SAP HANA 1.0 SP7 with MicroStrategy Analytics Enterprise on Windows and Linux Operating Systems


Community Admin

• Strategy


SAP HANA 1.0 SP7 is supported with MicroStrategy Analytics Enterprise. This support status currently applies to MicroStrategy Intelligence Server Analytics running on WIndows and Linux operating systems - it does not apply to MicroStrategy Intelligence Server Analytics running on AIX, HP-UX or Sun Solaris operating systems. Also, this support status currently applies to warehouse configuration only - it does not apply to Metadata, Statistics or Narrowcast Server.

Summary:
SAP HANA 1.0 SP7 is supported with Strategy Analytics Enterprise 9.4.1. This support status currently applies to Strategy Intelligence Server Analytics 9.4.1 running on WIndows  and Linux operating systems - it does not apply to Strategy Intelligence Server Analytics 9.4.1 running on  AIX, HP-UX or Sun Solaris operating systems. Also, this support status currently applies to warehouse configuration only - it does not apply to Metadata, Statistics or Narrowcast Server.
This is a post-support status since the testing was performed after the release of Strategy Analytics Enterprise 9.4.1. Therefore, the support information (tabulated below) is not present in the Strategy Enterprise Analytics 9.4.1 General Information Readme file:

 
Subtotal and Aggregate Compatibility7.1 client subtotal behavior7.1 client subtotal behaviorRecommended settings for all 7.2 projectsRecommended settings for all 7.2 projectsSubtotal Dimensionality AwareFalseTrueFalseTrueResultSubtotal value is the sum of all rows in the gridSubtotal value is the sum of all rows in the gridSubtotal value is the sum of all rows in the gridSubtotal value is the same as the level metric value SAP HANA 1.0 SP7 32-bit SAP HANA driver version 1.00.70.58439 Supported

 
Subtotal and Aggregate Compatibility7.1 client subtotal behavior7.1 client subtotal behaviorRecommended settings for all 7.2 projectsRecommended settings for all 7.2 projectsSubtotal Dimensionality AwareFalseTrueFalseTrueResultSubtotal value is the sum of all rows in the gridSubtotal value is the sum of all rows in the gridSubtotal value is the sum of all rows in the gridSubtotal value is the same as the level metric value SAP HANA 1.0 SP7 32-bit SAP HANA driver version 1.00.70.58439 Supported

 
Subtotal and Aggregate Compatibility7.1 client subtotal behavior7.1 client subtotal behaviorRecommended settings for all 7.2 projectsRecommended settings for all 7.2 projectsSubtotal Dimensionality AwareFalseTrueFalseTrueResultSubtotal value is the sum of all rows in the gridSubtotal value is the sum of all rows in the gridSubtotal value is the sum of all rows in the gridSubtotal value is the same as the level metric value SAP HANA 1.0 SP7 32-bit SAP HANA driver version 1.00.70.58439 Supported

 
Users can contact Strategy Technical Support in order to obtain the SAP HANA 1.0 SP7.PDS file. This file will be used to install the 'SAP HANA 1.0 SP7' DBMS object. Follow the procedure in the outlined technical note to install this DBMS object:
KB43537 : How to install DBMS objects provided by Strategy Technical Support
In order to use SAP HANA 1.0 SP7 as a warehouse with Strategy Intelligence Server Analytics 9.4.1, users must now pick the 'SAP HANA 1.0 SP7' DBMS object in the 'Database Connection Type' window (located at Configuration Managers > Database Instance Manager > Database Instance) in Strategy Developer 9.4.1.
Refer to the following Strategy Knowledge Base documents for information on some known issues when operating against SAP HANA 1.0 SP7
KB46408 : In Strategy Analytics Enterprise 9.4.1 running against  SAP HANA 1.0 SP7, ATAN2 function fails when used with the sum function over more than 200000 rows with the error "....Error executing physical plan: exception 6900:......"
KB46410 : In Strategy Analytics Enterprise 9.4.1 running against SAP HANA 1.0 SP7, the "Second" function when used with the "NOW" function does not return an integer value as expected
KB45833 : The error " Gener" is seen when attempting to test Single Sign On Authentication (Kerberos) to a SAP Hana database using the Strategy DBQuery Tool with the SAP Hana 1.00.70.386119 1.00.70.58439 drivers
Third Party Software Installation WARNING
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.


Comment

0 comments

Details

Knowledge Article

Published:

May 16, 2017

Last Updated:

May 16, 2017