Stored Procedures on Infoview or Universe?

building reports webintelligence
1

Hi,
I have created a stored procedures and want to use to display a webi report. Should I add this stored procedures in the Universe (but i couldnt find this in the table list) or i can call this from the Infoview? Please asssist. Thanks.

Didy :malaysia: (BOB member since 2009-05-07)

2

Go through this

nitin_gons :india: (BOB member since 2009-05-26)

3

Hi,

Create an object in the universe with the Stored Procedure and the input parameters.

I used this earlier in some of my reports

No need to import Stored Procedures code into the universe.

Gud luck…

Sreenivas Reddy

sreenivas_bo :india: (BOB member since 2009-12-08)

4

sreenivas,
when u said create an object based to the SP in the Universe, does that means i dont have to import any table? Just open a new object & write the SP script inside the select box there?

Didy :malaysia: (BOB member since 2009-05-07)