calling a stored procedure from BOXI?

building semantic layer
1

Hi,

My Sr. manager wants to know whether from BOXI Unv. we can call stored procedure or not for some different project requirements. he didnt describe.

I told him yes. But he wants to know about the details.

Can anybody explain or share any material?

Thanks,

Ranjan

ranjan.sahoo :india: (BOB member since 2007-06-11)

2

Even i am browsing in this site. if any very usefull link… please provide.

Thanks,

Ranjan

ranjan.sahoo :india: (BOB member since 2007-06-11)

3

you can use desktop intelligence to create query based on stored procedure and refresh them in webi. But if you want an advice, the stored proc based reports are not the best businessobjects stuff. you should rather use an universe

Regards
Bernard

bernard timbal :fr: (BOB member since 2003-05-26)

4

But in BOXI deski is not there. here how to call a stored procedure?

Thanks,

Ranjan

ranjan.sahoo :india: (BOB member since 2007-06-11)

5

you can’t call stored procedure in webi. webi only allow univers based queries…

bernard timbal :fr: (BOB member since 2003-05-26)

6

Thanks Bernand. Do you have any documents supporting BOXIR2 can call stored procedure.

As manager wants some kind of proof prior to commit.

Thanks,

Ranjan

ranjan.sahoo :india: (BOB member since 2007-06-11)

7

Hi Ranjan

Refer the xir2_deski_access_analyze_data_en.pdf guide under page no.80. This has given the details about using SP.

The guide avilable under http://help.sap.com/businessobject/product_guides/

Regards
Siva.M

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

8

Thank you Siva. Hope i will get the required documents.

Thanks,

Ranjan

ranjan.sahoo :india: (BOB member since 2007-06-11)

9

check this link:

https://bobj-board.org/t/94285

BO_Chief :us: (BOB member since 2004-06-06)

10

yes, but it appears to be a tricky and unsuported way to use Stored proc on Webi. maybe it could work on some webi release but if I was you I should’nt run the risk to use this unsupported solution on which BusinessObjects will not provide any support and help in case of troubles…

bernard timbal :fr: (BOB member since 2003-05-26)

11

Thank you very much Bernanrd. My manager finally clarified me its BOXIR2. I am fine now.

Thank you all for your support.

Thanks,

Ranjan

ranjan.sahoo :india: (BOB member since 2007-06-11)