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!

how to use full qualified table names in RPD

kmangamuriAug 23 2012 — edited Aug 23 2012

Hi,

We are implementing the BI Financial Analytics, we have a requirement to use diffrent user accounts for DAC , ETL and OBIEE

DAC, ETL we are using user as XXOBI

For OBIEE RPD we have to use user with read only access such as XXOBI_APP

How can i make the changed to BI server / RPD to use full qualified names.

I have tried to select the Full Qualified table name property in Oracle Datawarehouse connection pool setting.

If i enable that all my sql query is showing tables as catalog.dbo.w_party_d ( my tables in physical layer showing under catalaog -> dbo -> all tables and joins)
Any help in this is appreciated.

Thanks

Kris

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 20 2012

Added on Aug 23 2012

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

2 comments

659 views