BusinessObjects Board

BO Report to view the Data returned from Query Builder??

sdk development
#1

Hi,

Can you suggest any option to build a BO Report, to view the Data returned from QueryBuilder.

Thanks,
Vamsi.

Vamsi99 :india: (BOB member since 2010-11-26)

#2

Query builder talks to the CMS database using the InfoStore SDK DLLs.

No ones written an Infostore driver, ODBC, OLEDB or otherwise to be able to connect a Universe to it. So no, impossible.

ABILtd :uk: (BOB member since 2006-02-08)

#3

I believe I saw a third-party product mentioned here that would do what you ask. Search around and you might find it.

joepeters :us: (BOB member since 2002-08-29)

#4

Option 1: Commercial BI Platform Analysis tool:

Option 2: Querybuild > Export to Excel > Macros to massage cells and flatten data > create webi xls dataprovider report

Option 3: BOB Downloads section > create csv from output of free tools (BI Repository Documenter) > create webi xls dataprovider report

Hope this helps

Atul Chowdhury (BOB member since 2003-07-07)

#5

Thanks for the Responses.

@Atul

I want to run the query in Querybuilder for Every hour, and the Data Exported to Excel.

Do you know any option to automate this?

Thanks,
Vamsi.

Vamsi99 :india: (BOB member since 2010-11-26)