Creating a webI report with free hand SQL

building reports webintelligence
1

How can we create a report with free hand SQL data provider in WebI (XIR2)? I didn’t find any option in webI to do this.

I have a BO 6.5 report that was built using stored procedure data providers which I want to recreate using webI. Do I have to build these objects in the universe to create this report in webI? I have heard that Business Objects will not support DeskI in the future. So how can we build these kind of reports with stored procedures ?

Thanks!
Maddy

maddyforums (BOB member since 2006-02-23)

2

Hi you can do two things

  1. Create a view in the Database and pull that in the universe.

or

  1. Create a derived table in the universe.

ay1224 :us: (BOB member since 2007-07-30)

3

Webi does not currently support free hand SQL. I think Business Objects developers are well aware that there are some data sources missing from the options in webi, and are working to bring them back in future versions.

Dave Rathbun :us: (BOB member since 2002-06-06)

4

And now I see that you have posted the exact same question here as well.

Please do not post the same question more than once. It is extremely frustrating to those that want to help with answers, and it leads to fragmented discussions. It is for that very reason that we have a no cross-posting rule.

Dave Rathbun :us: (BOB member since 2002-06-06)