David Lai's Business Intelligence Blog
730 FOLLOWERS
Tips, Tricks, and Best practices to get the most out of your BI implementation
David Lai's Business Intelligence Blog
2y ago
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
David Lai's Business Intelligence Blog
3y ago
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
David Lai's Business Intelligence Blog
3y ago
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
David Lai's Business Intelligence Blog
3y ago
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