Webi reporting with Hive as a data source

[atul_kulkarni9]

Dear All,

Recently we have made Hive 0.8.0 connectivity with SAP BO 4.0 Sp5. We are able to get table from Hive to Infromation design tool and able to generate report for testing purpose.

As per my knowledge there is no refrential integrity present in hive. So if we want to generate report like as we are generating report based on oracle ,DB2, or sql server what colud be data model present in Hive so that we can achive the same through Hive?.

Any suggetsion or help on this would be appreciated.

Thanks in advance.

[atul_kulkarni9]

Thanks Naveen and Henry,

Yes i went through attached link.

the problem arises to insurity of Reffrential integrity of data at Hive level.

If any help on this will appreciated.

Best Ragards,

Atm

[Former Member]

Hi Atul,

Check this PDF under Page 9 and 16

http://www.visualbis.com/wp-content/uploads/2013/05/SAP-BO-Hadoop-Integration-Guide.pdf

http://events.asug.com/2012AC/0514_Business_Intelligence_on_Hadoop_Hive.pdf

Regards

NK

[Henry_Banks]

Hi,

there is an introduction on this document here: http://scn.sap.com/docs/DOC-29985

regards,

H