topic Regarding Business Objects universe & Qv in QlikView

Regarding Business Objects universe & Qv

spsrk_84 — Mon, 09 May 2011 18:31:23 GMT

Hi Guys,

I have few query related to Business Objects and QlikView.

1) Can QlikView fetch data from Business Objects Universe?

2) Can any one share the pricing difference between these ?

Please share your thoughts and the valuable information.

Thanks In Advance.

Regards,

Ajay

Regarding Business Objects universe & Qv

Tue, 10 May 2011 12:27:01 GMT

Hey Ajay,

I'm also looking for the same thing, to see whether there's a certain kind of connector that allows QV to connect directly to BO universe.

For the moment, we are doing it all manually. User gives us the BO query, we take the SQL code, modify it, and create a view in Oracle out of it for QV to connect. Quite time consuming when you have complicated requirement.

So, it'd be nice if there's some connector to BO universe.

Regarding Business Objects universe & Qv

suniljain — Sun, 22 May 2011 11:00:37 GMT

I think you can not connect directly to SAP Busness Object but you can make view of Business object Universe and connect to Qlikview.

Comimng to comparison between Qlikview and BO

1) Qlikview compresses data up to 90% wheres BO Can't

2) Qlikview can handle more than 50 crore of record in data modelling whereas it is tough job for Busoiness Object.

3) Qlikview Business Intelligence impelementation is cheaper compare to BO.

Regarding Business Objects universe & Qv

Mon, 23 May 2011 08:28:16 GMT

Hi,

I do this often: take some SQL from other reporting tools, analyse it, and reimplement it in QlikView

Sometimes there are huge joins done in BO universe. The copy/pasted SQL does not always work from the first run, or is unacceptably slow, or you need to do separate fact from dimension tables as save as QVD, or do delta loads.

You need to understand the SQL before working with it.

I wrote a tool to ease analysing huge select statements. Just paste the SQL into www.snowflakejoins.com . Since there is no connection to the database, you need to always use alias.column . Unless there is some complictated formula in SQL, a diagram will be generated. The joins are simplified == formulas are discarded in order to see the structure. I found no better way to analyse a select over 70 tables.

-Alex