Skip to Content
Author's profile photo Former Member

Bex Query Designer and HANA views


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.




Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member


      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...

      Author's profile photo Andreas Tenholte
      Andreas Tenholte

      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,


      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Loed Despuig
      Loed Despuig


      Maybe you know the reason of my problem?

      No data on queries created using hana calculati... | SCN

      Thank you..


      Author's profile photo Karthik K
      Karthik K


      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,


      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      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.