'UNIQUE DIMENSION' Clause Not Recognized by OEMM 12.2.1.4
(Doc ID 2999675.1)
Last updated on JANUARY 23, 2024
Applies to:
Oracle Enterprise Metadata Management - Version 12.2.1.4 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.1.4 version, OEMM
When importing a view with 'MODEL' clause
the following error occurs.
ERROR
-----------------------
EXPLIB_D0002 Message: 'syntax error, unexpected UNIQUE_TOKEN'
Context: '
MODEL
UNIQUE'
Location: '(6,4,6,10)'
Expression tool type: 'Generic'
Expression database type: 'Oracle'
Expression text: 'CREATE VIEW V_MODEL AS select
ROW_,COL_1, COLL_1,COL_2,COL_3,COL_4,COL_5
from
tq84_model_clause
MODEL
UNIQUE DIMENSION
RETURN /UPDATED/ALL ROWS
PARTITION BY(col_1)
dimension by ( row_ )
measures ( col_1 AS coll_1, col_2, col_3, col_4, col_5 )
/* rules go here */
RULES UPSERT ALL AUTOMATIC ORDER
(
)',
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |