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!

Tables between OBAW and Oracle Data Warehouse in OBIA rpd are different

user522729Aug 25 2010 — edited Aug 25 2010

Hi,

The tables in the Data Warehouse DB is different as compared to the tables in the physical layer of the Oracle data Warehouse in OracleBIAnalytiscApps.rpd.

When I click update Row Count, it gives me below error message:

There was an error while updating row count for "Oracle Data Warehouse"."Catalog"."DBO"."W_CTRY_REGN_D":
[nQSError :17001] Oracle Error Code: 942, message: ORA-00942:Table or view does not exist at OCICallSTmTEXECUTE

Whereas when I click on some other tables for Row count there is not error.

Also, When I am trying to look for some specific table which exist in Data Warehouse (that has the data), it does not exist in the rpd.

Kindly assit me.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 22 2010

Added on Aug 25 2010

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

2 comments

716 views