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?