Consuming HANA views in Web Intelligence report

Hana Views can be consumed in Web Intelligence reports through a universe created from Universe Design Tool using JDBC/ODBC connectivity.

Once we have View created in HANA Studio in the Content section under project

We can see them under _sys_BIC schema under Catalog part

Remember this is purely a relational component of HANA and HANA Studio and it is a tabular form of View(data foundation).

After this is activated in HANA system and executed we can create a relational connection using Universe Design Tool through odbc/jdbc middleware.

The above figure depicts the tables under _sys_BIC and all the entried are HANA View in relational form.

After this it is a similar procedure like we create a relational universe in UDT.

Always remember Web Intelligence does not support Variables and Input Parameters refer below link

When the universe is created you can create a Web Intelligence report over it.

Hope this blog helps users who wish to consume HANA Views in Web Intelligence 🙂

You must be Logged on to comment or reply to a post.

Matt Hawkins August 21, 2014 at 8:59 pm

Variables and input parameter support was added in BI4.1 SP3.

like (0)
1. Former Member Post authorAugust 22, 2014 at 3:54 pm
  
  Hi Matt,
  
  Thanks for the heads up.
  
  Adding to it for variables and input parameters only JDBC middleware is supported for WebI.
  
  Regards,
  
  Pranay
  
  like (0)