Can we use Stored Procedure as Data Source?

building reports webintelligence
1

HI,
I am kind of new with BO/WebI XI, and was wondering if we can use Stored Procedure or Free Hand SQL as a data source and build report from WebI Xi? If yes, how?
All my reports are based on Stored Procedures and designed in Crystal Reports XI.

One more questions, Do we use normalized tables/data in Data Warehouse or we need to de-normalized it in Data Warehouse/Data Mart?

Thanks in advance for your time.

sudkool :us: (BOB member since 2005-05-23)

2

You cannot use Stored Procedures as Data providers in WebI Xir2, also you cannot create a free hand SQL report in WebI. Both are possible in Deski Though.

Thanks,
Kon

konquistador :us: (BOB member since 2006-01-04)

3

Hi,

You can use freehand sql in WebI. But it is not direct as like in Full client we can create a Data provider based on freehand sql.
But here in WebI.
1.You need to drag the correct no.of objects equal to your columns which are there in your select statement and
2. Click on View Sql
3. And click on Use custom SQL and paste your SQL which you want the report to be build.

Hope it works for you.

Sathish

santhano :india: (BOB member since 2004-10-12)

4

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)

5

check out this solution
https://bobj-board.org/t/94285
you can use stored procedures in WebI report with prompts, temp tables, etc…

Dmitry Biryukov :switzerland: (BOB member since 2006-10-15)