While creating a universe off an Informix database, I discovered a bug that SAP never took care of or provided any documentation on fixing, which was quite of surprising. Basically using a date object in the filter will generate an incorrect WHERE clause. In the following example, we create a simple universe off an Informix ..read more

Welcome to Part 3 of the HANA Live Connection Series. In this article we will walk through creating a HANA Live Direct Connection to SAP Analytics Cloud. Step 1: Ensure pre-requisites have been met Ensure that HTTPS (SSL) for Client Application Access has been configured http://davidlai101.com/blog/2020/08/27/connecting-hana-live-to-sap-analytics-cloud-and-sap-businessobjects-part-1#https Ensure HANA Info Access Service (INA) has been configured ..read more

In this article we will go through creating different HANA Connections in SAP BusinessObjects and then using them in different applications. We’ll also talk about the differences between the different types of HANA connections. CONNECTION #1: Create SAP HANA http OLAP Connection First, we need to create the HANA http connection to SAP HANA. 1 ..read more

Being able to connect to a live HANA connection via SAP Analytics Cloud or SAP BusinessObjects is important, as query processing is all done on the HANA engine rather than SAC or SAP BOBJ. To accomplish this, you will need to setup SSL capabilities on the HANA side, setup correct user authorization, and then setup ..read more