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

    2711084

      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