stored procedures in webi

building reports webintelligence
1

Im trying to build webi reports that are dependent on stored procedures.
I thought of two methods

method 1:
Universe Level
Create a derived table and paste the sql query of stored procedure.

method2 :
report level:
drag the objects on to reprot and click on custom query and paste sql query of stored procedure .
Am i heading in correct direction :?: Is there any other method. :?:
Please suggest me.

Thanks in advance.

kumar23 (BOB member since 2007-05-25)

2

You should go with method 1
Creating reports off an universe is a best practice to follow compared to custom SQL or stored procedure.
There are lot of plus points while using a universe than a free hand SQL or SP.

Cheers

haider :es: (BOB member since 2005-07-18)

3

thanks a lot haider for your suggestion.

kumar23 (BOB member since 2007-05-25)

4

Please suggest me if there is any other method.

thanks in advance.

kumar23 (BOB member since 2007-05-25)

5

As aforementioned, universe is the way to go.
If you say any other method, then as they are WebI reports designed either from a universe or a custom SQL which again involves a universe.
Stored procedure based DP in WebI is not possible.

haider :es: (BOB member since 2005-07-18)

6

Can you elaborate: What is ‘DP’ ? I have a similar issue and need to explain the limitation to non-technical persons.

bienvenusj (BOB member since 2007-08-01)

7

Hi welcome to BOB or bienvenue -:wink:

DP is data provider or fournisseur de données.

Regards

8

Merci pour la réponse rapide ! Merci pour "bienvenue’. Mon français est tout à fait mauvais, mais mon espagnol est meilleur :slight_smile:

Thank you for the fast reply! Thank you for the welcome.
My French is quite bad, but my Spanish is better :slight_smile:

bienvenusj (BOB member since 2007-08-01)

9

thank you haider for your valuable suggestion…
but how does custom SQL involve universe…
i think custom sql is involved only at report level right …?

kumar23 (BOB member since 2007-05-25)

10

Check out this solution -
https://bobj-board.org/t/94285

you can use stored procedures in WebI report with prompts, temporary tables, etc…

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