Nested Composites Are No Longer Supported

In earlier releases of the OLAP DML, when you defined a composite using a DEFINE COMPOSITE command, you could specify a composite as a base object of another composite. This functionality was rarely, if ever, used. Beginning, in Oracle 11g, the base object of a composite can only be a dimension. If you have any nested composites in an existing analytic workspace, when you convert that analytic workspace into When you import nested composites from earlier versions into an Oracle11g analytic workspace, IMPORT (EIF) automatically unnests the composites.