cancel
Showing results for 
Search instead for 
Did you mean: 

How to Call a Procedure in BI LAunchPad of SAPBI4.0?Need Exact Syntax for Customizing

Former Member
0 Kudos

Hi to ALL,
we are here using Service pack 4 of SAP BI4.0 and generally we bulit Universe with Dummy Tables to call a Procedure in following way

SET NOCOUNT ON
/*SELECT NULL*/
EXEC PROCEDURE_NAME PARAMETER1,PARAMAETER2

before that we select dummy columns from univerese with respective Datatypes based on resultset /output of procedure and then we customize the query in above way to call Procedure in WEBI INfoview of SAPBO XIR3.1 version which is working fine but not working in BI LAUNCHPAD of SAP BI4.0.
after than i have tried in following way

SELECT * FROM OPENROWSET('SQLNCLI' ,'Server(local);Trusted_Connection=Yes;Database=Master','Procedure_name Parameter1,Parameter2')

but here database is hard coded it should not be like that.so please kindly suggest us any exact syntax that which support BI LAUNCH PAD of SAP BI4.0 to call a procedure .

Accepted Solutions (0)

Answers (1)

Answers (1)

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Moved to Semantic Layer forum.

regards,

H