Cause: A column was used in the definition of a level after it had already

ORA-30371: column cannot define a level in more than one
dimension

Question Posted / guest

1 Answers
5406 Views
I also Faced
E-Mail Answers

Answer Posted / guest

Cause: A column was used in the definition of a level after
it had already been used to define a level in a different
dimension.

Action: Reorganize dimension levels and hierarchies into a
single dimension such that no column is used to define
levels in different dimensions. There is no limit on the
number of levels or hierarchies you can place in a
dimension. A column can be used to define any number of
levels provided all such levels are in the same dimension
and provided no two levels contain identical sets of columns.

Please add more information about this Error

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

NZE-28868: Peer certificate chain check failed.

2864

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2298

NZE-28890: Entrust Login Failed

1924

ORA-26030: index string.string had string partitions made unusable due to:

1988

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2753

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2860

ORA-26027: unique index string.string partition string initially in unusable state

6790

ORA-26095: unprocessed stream data exists

3638

ORA-16627: No standby databases support the overall protection mode.

4037

ORA-26029: index string.string partition string initially in unusable state

2229

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3438

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3224

ORA-16626: failed to enable specified object

2272

RMAN-05017: no copy of datafile number found to recover

2465

ORA-26028: index string.string initially in unusable state

3914