Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 09, 2013 at 10:48 AM

    Hi,

    Moved to Semantic Layer forum.

    regards,

    H

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.