It has been very quite at the moment.Because nothing spectecular is happening in the Analysis Office world. SAP released Analysis Office 2.7 SP5. I still hope they get Analysis Office 2.8 back on track and without so much problems as they have today. But back to topic.
Recently I had the opporunity to work with SAP HANA Table Functions. First I had a complex SAP HANA Calculation View with Joins, Aggregations and so on. But I read a blog post on the SCN by Konrad Załęski and thought maybe I can use Table Functions to do the same as I do with my Calculation Views.
I use Eclipse 2018-09 (4.9.0) and the BW Modeling Tools 1.19.35 so maybe the options are not at the same position in another version. As far as I know SAP, the buttons are definitly not at the same position anymore. 🙈
To reduce the complexity I used three calculation views to narrow down my problem step by step.
After I tested my SQL commands to get the same results, I could remove Calculation View 1 with this simple SQL Statement.
FUNCTION "SCHEMA"."test::test_function" ( )
RETURNS TABLE ("POSITION" NVARCHAR(4),
SQL SECURITY INVOKER AS
* Get all Position, Sales Channels for all Products and Currency
* where Process = Allocation and Market Number is empty.
SELECT DISTINCT "POSITION",
sum( "AMOUNT" ) as "AMOUNT",
FROM "SAPABAP1"."/BIC/ATEST2" where "PROCESS" = 'A' and "MANUM" = ''
After that I was thrilled with SQL commands. It's been a while since I used SQL. Maybe the last time before I started as a BW consultant. So I looked into it. You find a lot of help on help.sap.com or on udemy.com. Since then I just think about my existing Calculation Views and how I can make them better with Table Functions.
So here is my question for this post. Do you use Table Functions and how complex do you build them?
These posts might also be interesting: