Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-704

MDSCHEMA_PROPERTIES should not return internal properties

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 3.0.5, 3.1 GA, 3.1.1 GA, 3.1.2 GA, 3.1.4 GA (3.5.0 GA Suite Release), 3.1.5 GA, 3.1.6 GA (3.5.2 GA Suite Release), 3.5.0 Suite Release, 3.1.6 (3.5.2 GA Suite Release), 3.2.0 GA (3.6.0 GA Suite Release), 3.6.0 (5.0.0 GA Suite Release), 4.0.0 (5.1.0 GA Suite Release), Backlog
    • Component/s: None
    • Labels:
      None
    • Environment:
      Any
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      When a nameColumn is defined for a level the XMLA created for Excel is invalid.
      Mondrian uses an internal property to hold the nameColumn but the type of property is not checked when xmla properties are discovered. The RolapLevel.createProperties method defines the properties associated with a Level and you can see in this function how the internal nameColumn is flagged as internal.

      This bug is corrected by adding 1 line to the RowDefinition.populateLevel method:

             private void populateLevel(
                 final SchemaReader schemaReader,
                 final String catalogName,
                 Cube cube,
                 Level level,
                 List<Row> rows)
             {
                 Property[] properties = level.getProperties();
                 for (Property property : properties) {
                     if (propertyNameRT.passes(property.getName()))

      { /* FIX BY ADDING NEXT LINE */                 if(property.isInternal()==false)                 outputProperty(                 schemaReader, property,                 catalogName, cube, level, rows);                }

                 }
             }

        Attachments

          Activity

            People

            Assignee:
            jhyde Julian Hyde (Inactive)
            Reporter:
            cpamiller Calum Miller
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: