MdmDimensionLevel mdmDimLevel = dimension.findOrCreateDimensionLevel(((OracleLevel)level).getUniqueID());
dimLevelList.add(mdmDimLevel);
// Create a MemberListMap for the dimension level.
MemberListMap mdmDimLevelMemListMap = mdmDimLevel.findOrCreateMemberListMap();
ColumnExpression keyColExp = (ColumnExpression)SyntaxObject.fromSyntax(level.getTableColumnId(), metadataProvider);
mdmDimLevelMemListMap.setKeyExpression(keyColExp);
mdmDimLevelMemListMap.setQuery(keyColExp.getQuery());
// Create the long description attribute and set the data type for it.
MdmBaseAttribute chanLongDescAttr = null;
chanLongDescAttr = dimension.findOrCreateBaseAttribute(level.getTableColumnId());
SQLDataType sdtVC2 = new SQLDataType(connection.getDatabaseType(level.getType()));
chanLongDescAttr.setSQLDataType(sdtVC2);
// Make the attribute visible on the dimension.
dimension.setValueDescriptionAttribute(chanLongDescAttr);
// Create an attribute map for the Long Description attribute.
AttributeMap attrMapLong = mdmDimLevelMemListMap.findOrCreateAttributeMap(chanLongDescAttr);
// Create an expression for the attribute map.
Expression lDescColExp = (Expression)SyntaxObject.fromSyntax(level.getTableColumnId(),metadataProvider);
attrMapLong.setExpression(lDescColExp);
i++;