obiee 12c how to use (import) SQL Server 2014 stored procedure as data source in RPD physical layer

User_INLWQ

Hi Gurus,

We are on OBIEE 12c, data source being a sql server 2014 stored procedure.

How do we model this in the physical layer of RPD ?        Creating a new table, selecting type as "Stored proc" and then leave the default button "default initialization string" checked and then giving the "EXEC [database_name].[schema_name].[procedure_name] ???

can't we instead select table type as "SELECT" and then give the entire "select from ........"  statement of stored procedure in the dialogue box ???

Please share inputs.

Thanks

User_INLWQ

Hi Gurus,

Please share any inputs on this..

Thanks

[Deleted User]

2711084 wrote:can't we instead select table type as "SELECT" and then give the entire "select from ........" statement of stored procedure in the dialogue box ???

Well....how about you just *DO* it and let us know with an exact and detailed post if there is any issue?