2 Replies Latest reply on Nov 16, 2019 12:06 PM by Christian Berg

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


      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.