on 01-09-2013 4:11 AM
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 .
Hi,
Moved to Semantic Layer forum.
regards,
H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.