Bex Query Designer and HANA views
Hello,
This morning I’ve opened the good old Bex Query Designer after a long time of not opening it and surprise!! All the HANA modeling objects that we developed – Analytical views, Calculation views, Attribute views are available for Bex use as Transient providers.
The Packages names starts with [2H-]
The Parameters in the CV are placed in the Data Part in the Query Designer. In case of mandatory parameters the characteristic must be restricted.
Enjoy!
Amir
Hi,
These are Hana Live Views, right? In addition, can we use our custom Hana analytic or calculation views as an infoprovider for Bex Designer?
Thank you...
Hi Ceyhun,
yes you can. All HANA Calculation Views and Analytic views are exposed in the query designer info provider view.
Just look for the "2H-" InfoAreas that expose your HANA repository package structure in the InfoProvider tree with all HANA Information Models as shown in the screen shot above - not only for HANA Live.
Best regards,
Andreas
Thank you for the input... but I am facing problem that I am not able to locate “2H-” InfoAreas" in Query Designer.
When I launch the query designer, the logon is in SAP GUI. Is there any other connection to be given to connect HANA calculation view to the query designer??
Thanking you in advance.
-Arjun Ajit
Hi,
Maybe you know the reason of my problem?
No data on queries created using hana calculati... | SCN
Thank you..
Loed
Hi,
I am able to create Bex queries on top of Hana analytical Views.the created bex query is corrupted when i try add any attributeview to that analytical view and the error message is like Infoprovider doesnt exist.After this message if i tried to create a new query on top of the same analytical view but the analytical view didnt appear which it was appeared before adding attribute view. I didnt find the reason why it happen.
Environment : BW7.4 sp12 on HanaDB
Can someone please help.
Thanks in advance,
KK
HI Karthik,
Please raise your questions under Q&A tagged with BW. This blog is from 3yrs ago and I don't think, you might not get an answer unless the OP is actively tracking this comment section.