Pre-requisites to establish Lumira Designer Connection with HANA as source
When you own a HANA system and have many important prebuilt HANA Views, which incorporate important business logic, it makes sense to use this wealth of information as sources to design your dashboards rather than redesigning the same logic in the Universe layer and then using this as a source.
The ability to connect to HANA Views directly from the Designer will let the organization use these pre-built HANA views with business logic embedded in them as source and build informational and impressive dashboards that can be used for critical decision-making purposes.
Also, by connecting Live to HANA, we take the advantage of HANA’s in-memory processing. When HANA is used as a Data Source, the queries are delegated to HANA when any changes occur in the query’s initial view, meaning, when you use Drill Down functionality or use dimension swaps, Instead of loading data for ALL of the components in the View, HANA does Query Pruning, which will only fetch the data that is in use. Thus, improving the performance of Lumira Designer Dashboard by avoiding the storage of large data sets in its memory.
In this blog, we will walk through the necessary steps needed to establish a connection to the HANA system in SAP’s BI Platform, and then use this connection in the Lumira Designer to connect to HANA. Once the connection is made, it is pretty straightforward to use this data source and create a dashboard on data from HANA.