My Oracle Support Banner

'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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.