Skip to Content
avatar image
Former Member

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

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 .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 09, 2013 at 10:48 AM

    Hi,

    Moved to Semantic Layer forum.

    regards,

    H

    Add comment
    10|10000 characters needed characters exceeded