Last updated on SEPTEMBER 03, 2015
Applies to:Primavera P6 Analytics - Version R2 and later
Primavera P6 Reporting Database - Version R3.0 and later
Information in this document applies to any platform.
When running the following query against the database as the star schema user (staruser):
select count(*) from table;
where table =
The total count returned differs from the total count when using the OBIEE Administration Tool, opening the repository file in 'Online Mode' and logging into the tool with an OBIEE user account. (Example, when right-clicking a table and selecting 'Update Row Count' or selecting 'View Data' the row counts display a total count of 0 or does not display any data when if viewing the table, even though there are rows in the table)
For the total count or data returned when logging into the OBIEE Administration Tool with an OBIEE user to return the same total count of records when running a count against the table as the schema owner (star user).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms