Showing posts with label sps11. Show all posts
Showing posts with label sps11. Show all posts

Sunday, 11 September 2016

Table Functions in SAP HANA - Demo

Post SPS 11 there are changes and restructuring in the way of HANA modeling. In this document I am trying to discuss about Table Functions (User Defined Functions).
The recommendation is to make use of Graphical Calculation views as the end product, so that the complexity of the information views are hidden inside Table Functions.
SAP recommends to Migrate Script-based Calculation Views to Table Functions and then into the Graphical Calculation Views. In the future, SAP recommends using graphical calculation views for modeling any analytic use cases. A migration tool within the SAP HANA modeler allows you to convert existing script-based calculation views available in your system to table functions and graphical calculation views.

Tuesday, 31 May 2016

Modelling Learning Double Action or two things I just learned about modelling in SAP HANA SPS 11

The scenario in mind here was a SAP BW on HANA system reading data from a Suite on HANA system and using the SAP HANA live content installed there.
The Open ODS feature of SAP BW on HANA was to be used here as it allows reading from tables and views exposed via SDA in the local SAP HANA instance.

Now this idea sounds splendid.
Instead of having to manually build an extractor or an data export database view (both of which can be extensive development efforts), why not simply reuse the ready made content of SAP HANA live for this?
As usual the proof of the pudding is in the eating and as soon as it was tried out a severe shortcoming was identified:

Wednesday, 16 December 2015