Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

User_INLWQNov 15 2019 — edited Nov 16 2019

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

Comments

User_INLWQ

Hi Gurus,

Please share any inputs on this..

Thanks

Christian Berg-0racle 
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?

1 - 2

Post Details

Added on Nov 15 2019
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
2 comments
276 views