Skip to Main Content
Forums

Database 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!

Identifier SCHEMA.TABLE_NAME.COLUMN is invalid

842519Mar 10 2011 — edited Mar 11 2011
Hi All,

I am having a very strange issue when mapping a dimension/cube to a base table in the database.
For e.g. when you map a member of a dimension to a column and click Apply in Mappings Editor, AWM throws an Identifier "SCHEMA.TABLE_NAME.COLUMN" invalid error message. e.g. Identifier "OLAP.PRODUCT.ITEM_ID" is invalid, although it's a perfect valid table/column in the database.

I am using AWM 11.2.0.1.0A and Oracle DB is on 11.2.0.1, running on an AIX 64bit machine

Any idea?
Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2011
Added on Mar 10 2011
#data-warehousing, #olap
8 comments
309 views