UNable to see Primavera Synonyms via Oracle BI
I am currently unable to view (either in existing data definitions or by building new ones) the P6 prefixed synonyms within Oracle BI Publisher.
We have a number of existing reports that currently will not execute because of this. If I try to edit the data model the SQL will not parse.
As a means of testing this I attempted to created a simple Data Model refrencing one of the Synonyms (e.e P6PROJECT) however this would not parse in SQL query view, nor was the synonym available for selection in QUery builder.
From within SQL Server I can see the View (PROJECT_U) upon which this synonym is based (as well as the underlying tables (PROJECT and PROJECTSECURITY which define the view). These can also be seen and referenced from within Oracle BI.
We have a number of existing reports that currently will not execute because of this. If I try to edit the data model the SQL will not parse.
As a means of testing this I attempted to created a simple Data Model refrencing one of the Synonyms (e.e P6PROJECT) however this would not parse in SQL query view, nor was the synonym available for selection in QUery builder.
From within SQL Server I can see the View (PROJECT_U) upon which this synonym is based (as well as the underlying tables (PROJECT and PROJECTSECURITY which define the view). These can also be seen and referenced from within Oracle BI.
0