コード例 #1
0
  @Test
  public void testFieldAggregations() throws ModelerException {

    ModelerWorkspaceHelper helper = new ModelerWorkspaceHelper(LOCALE);
    helper.autoModelFlat(workspace);
    helper.autoModelRelationalFlat(workspace);

    FieldMetaData firstField = workspace.getRelationalModel().get(0).get(0).get(0);
    assertEquals(firstField.getTextAggregationTypes(), firstField.getSelectedAggregations());
    assertEquals(AggregationType.NONE, firstField.getDefaultAggregation());
    firstField.setDefaultAggregation(AggregationType.COUNT);
    assertEquals(AggregationType.COUNT, firstField.getDefaultAggregation());
    firstField.setSelectedAggregations(Arrays.asList(AggregationType.COUNT));

    // Test Olap side
    assertEquals(
        workspace.getModel().getMeasures().get(0).getDefaultAggregation(), AggregationType.SUM);

    helper.populateDomain(workspace);

    // Now verify with the generated models
    LogicalModel logicalModel = workspace.getLogicalModel(ModelerPerspective.REPORTING);
    LogicalColumn lCol = logicalModel.getCategories().get(0).getLogicalColumns().get(0);
    assertEquals(firstField.getDefaultAggregation(), lCol.getAggregationType());
    assertEquals(firstField.getSelectedAggregations(), lCol.getAggregationList());

    List<OlapCube> cubes =
        (List<OlapCube>)
            workspace.getLogicalModel(ModelerPerspective.ANALYSIS).getProperty("olap_cubes");
    OlapMeasure measure = cubes.get(0).getOlapMeasures().get(0);
    assertEquals(AggregationType.SUM, measure.getLogicalColumn().getAggregationType());
  }
コード例 #2
0
  @SuppressWarnings("deprecation")
  public void addColumn(final LogicalColumn column, final Element tableNode, final String locale) {
    Element columnNode = tableNode.addElement("column"); // $NON-NLS-1$

    if (column.getId() != null) {
      columnNode.addElement("column_id").setText(column.getId()); // $NON-NLS-1$
    }
    if (column.getName(locale) != null) {
      columnNode.addElement("column_name").setText(column.getName(locale)); // $NON-NLS-1$
    }
    if (column.getDescription(locale) != null) {
      columnNode
          .addElement("column_description")
          .setText(column.getDescription(locale)); // $NON-NLS-1$
    }
    if (column.getFieldType() != null) {
      // TODO this should take a locale
      String desc = column.getFieldType().getDescription();
      desc = org.pentaho.pms.messages.Messages.getString(desc);
      columnNode.addElement("column_field_type").setText(desc); // $NON-NLS-1$
    }
    DataType dataType = column.getDataType();
    if (dataType != null) {
      columnNode.addElement("column_type").setText(dataType.getName()); // $NON-NLS-1$
    }
    if (column.getProperty("lookup") != null) { // $NON-NLS-1$
      columnNode.addElement("column_lookup").setText("true"); // $NON-NLS-1$ //$NON-NLS-2$
    }
  }
コード例 #3
0
  public LogicalColumn findLogicalColumn(IPhysicalColumn column, ModelerPerspective perspective) {
    LogicalColumn col = null;
    IPhysicalTable physicalTable = column.getPhysicalTable();
    LogicalModel logicalModel = this.getLogicalModel(perspective);
    if (logicalModel == null) {
      return col;
    }
    for (LogicalTable table : logicalModel.getLogicalTables()) {
      if (table.getPhysicalTable().getId().equals(physicalTable.getId())) {
        if ((perspective == ModelerPerspective.ANALYSIS
                && table.getId().endsWith(BaseModelerWorkspaceHelper.OLAP_SUFFIX))
            || (perspective == ModelerPerspective.REPORTING
                && !table.getId().endsWith(BaseModelerWorkspaceHelper.OLAP_SUFFIX))) {

          for (LogicalColumn lCol : table.getLogicalColumns()) {
            if (lCol.getPhysicalColumn().getId().equals(column.getId())) {
              return lCol;
            }
          }
        }
      }
    }

    return col;
  }
コード例 #4
0
 public LogicalColumn findLogicalColumn(String id) {
   LogicalColumn col = null;
   for (LogicalColumn c :
       getLogicalModel(currentModelerPerspective).getLogicalTables().get(0).getLogicalColumns()) {
     if (c.getName(workspaceHelper.getLocale()).equals(id)) {
       col = c;
       break;
     }
   }
   return col;
 }
コード例 #5
0
  /**
   * In this test we try to test :<br>
   * - if the formula engine picks the 2 specified columns from 2 different business tables<br>
   * - if we calculate the multiplication of the sums <br>
   */
  @Test
  public void testMultiTableColumnFormulasAggregate2() throws Exception {
    LogicalColumn quantityOrdered =
        getOrdersModel().findLogicalColumn("BC_ORDER_DETAILS_QUANTITYORDERED");
    Assert.assertNotNull(
        "Expected to find the business column 'quantity ordered'", quantityOrdered);
    LogicalColumn buyPrice = getOrdersModel().findLogicalColumn("BC_PRODUCTS_BUYPRICE");
    Assert.assertNotNull("Expected to find the business column 'buy price'", buyPrice);

    // let's enable the aggregations of the quantity ordered...
    //
    AggregationType qaBackup = quantityOrdered.getAggregationType();
    AggregationType paBackup = buyPrice.getAggregationType();
    quantityOrdered.setAggregationType(AggregationType.SUM);
    buyPrice.setAggregationType(AggregationType.SUM);

    // This changes the expected result...
    //
    String formula =
        "[BT_ORDER_DETAILS.BC_ORDER_DETAILS_QUANTITYORDERED] * [BT_PRODUCTS.BC_PRODUCTS_BUYPRICE]";
    String sql = "SUM(BT_ORDER_DETAILS.QUANTITYORDERED)  *  SUM(BT_PRODUCTS.BUYPRICE)";

    handleFormula(getOrdersModel(), "Hypersonic", formula, sql);

    // Set it back to the way it was for further testing.
    quantityOrdered.setAggregationType(qaBackup);
    buyPrice.setAggregationType(paBackup);
  }
コード例 #6
0
 /**
  * this method adds the order by statements to the query model
  *
  * @param query sql query model
  * @param model business model
  * @param orderBy list of order bys
  * @param databaseMeta database info
  * @param locale locale string
  */
 protected void generateOrderBy(
     SQLQueryModel query,
     LogicalModel model,
     List<Order> orderBy,
     DatabaseMeta databaseMeta,
     String locale,
     Map<LogicalTable, String> tableAliases,
     Map<String, String> columnsMap,
     Map<String, Object> parameters,
     boolean genAsPreparedStatement) {
   if (orderBy != null) {
     for (Order orderItem : orderBy) {
       LogicalColumn businessColumn = orderItem.getSelection().getLogicalColumn();
       String alias = null;
       if (columnsMap != null) {
         // The column map is a unique mapping of Column alias to the column ID
         // Here we have the column ID and we need the alias.
         // We need to do the order by on the alias, not the column name itself.
         // For most databases, it can be both, but the alias is more standard.
         //
         // Using the column name and not the alias caused an issue on Apache Derby.
         //
         for (String key : columnsMap.keySet()) {
           String value = columnsMap.get(key);
           if (value.equals(businessColumn.getId())) {
             // Found it: the alias is the key
             alias = key;
             break;
           }
         }
       }
       SqlAndTables sqlAndTables =
           getBusinessColumnSQL(
               model,
               orderItem.getSelection(),
               tableAliases,
               parameters,
               genAsPreparedStatement,
               databaseMeta,
               locale);
       query.addOrderBy(
           sqlAndTables.getSql(),
           databaseMeta.quoteField(alias),
           orderItem.getType() != Type.ASC ? OrderType.DESCENDING : null);
     }
   }
 }
コード例 #7
0
ファイル: CreateMeasure.java プロジェクト: pentaho/modeler
 @Override
 protected void removeAutoMeasure(final ModelerWorkspace workspace, final String column) {
   LogicalColumn logicalColumn = locateLogicalColumn(workspace, column);
   String locale = workspace.getWorkspaceHelper().getLocale();
   for (MeasureMetaData measure : workspace.getModel().getMeasures()) {
     if (measureNameEquals(column, measure)
         && measure
             .getLogicalColumn()
             .getPhysicalColumn()
             .getName(locale)
             .equals(logicalColumn.getPhysicalColumn().getName(locale))
         && measure.getDefaultAggregation().equals(AggregationType.SUM)
         && !measure
             .getMemberAnnotations()
             .containsKey(GeneratedbyMemberAnnotation.GEBERATED_BY_STRING)) {
       workspace.getModel().getMeasures().remove(measure);
       break;
     }
   }
 }
コード例 #8
0
  public ColumnBackedNode createColumnBackedNode(
      AvailableField field, ModelerPerspective perspective) {
    String locale = workspaceHelper.getLocale();
    ColumnBackedNode node = new BaseColumnBackedMetaData(field.getName());
    LogicalTable lTab = findLogicalTable(field.getPhysicalColumn().getPhysicalTable(), perspective);
    LogicalColumn lCol = null;

    if (lCol == null) {
      lCol = new LogicalColumn();
      lCol.setLogicalTable(lTab);
      // lCol.setParentConcept(lTab);
      lCol.setPhysicalColumn(field.getPhysicalColumn());
      lCol.setDataType(field.getPhysicalColumn().getDataType());
      if (field.getPhysicalColumn().getAggregationList() != null) {
        lCol.setAggregationList(field.getPhysicalColumn().getAggregationList());
      }
      if (field.getPhysicalColumn().getAggregationType() != null) {
        lCol.setAggregationType(field.getPhysicalColumn().getAggregationType());
      }
      lCol.setName(new LocalizedString(locale, field.getPhysicalColumn().getName(locale)));
      String colId =
          "LC_"
              + toId(lTab.getPhysicalTable().getName(locale))
              + "_"
              + toId(field.getPhysicalColumn().getId());

      // lCol.setDescription(new LocalizedString(locale,
      // field.getPhysicalColumn().getName(locale)));

      if (perspective == ModelerPerspective.ANALYSIS) {
        colId += BaseModelerWorkspaceHelper.OLAP_SUFFIX;
      }

      colId = BaseModelerWorkspaceHelper.uniquify(colId, lTab.getLogicalColumns());
      lCol.setId(colId);

      lTab.addLogicalColumn(lCol);
    }

    node.setLogicalColumn(lCol);
    return node;
  }
コード例 #9
0
ファイル: CreateMeasure.java プロジェクト: pentaho/modeler
  @Override
  public boolean apply(final ModelerWorkspace workspace, final IMetaStore metaStore)
      throws ModelerException {
    List<LogicalTable> logicalTables =
        workspace.getLogicalModel(ModelerPerspective.ANALYSIS).getLogicalTables();
    for (LogicalTable logicalTable : logicalTables) {
      List<LogicalColumn> logicalColumns = logicalTable.getLogicalColumns();
      for (LogicalColumn logicalColumn : logicalColumns) {
        if (columnMatches(workspace, resolveField(workspace), logicalColumn)
            || columnMatches(
                workspace,
                PhysicalTableImporter.beautifyName(resolveField(workspace)),
                logicalColumn)) {
          String targetColumn =
              (String)
                  logicalColumn.getPhysicalColumn().getProperty(SqlPhysicalColumn.TARGET_COLUMN);
          MeasureMetaData measureMetaData =
              new MeasureMetaData(
                  targetColumn,
                  getFormatString(),
                  getName(),
                  workspace.getWorkspaceHelper().getLocale());

          LogicalColumn columnClone = (LogicalColumn) logicalColumn.clone();
          columnClone.setId(
              BaseModelerWorkspaceHelper.uniquify(columnClone.getId(), logicalColumns));
          measureMetaData.setLogicalColumn(columnClone);
          measureMetaData.setName(getName());
          measureMetaData.setDefaultAggregation(getAggregateType());
          measureMetaData.setHidden(isHidden());
          measureMetaData
              .getMemberAnnotations()
              .put(
                  GeneratedbyMemberAnnotation.GEBERATED_BY_STRING,
                  new GeneratedbyMemberAnnotation(this.getName()));
          if (getDescription() != null) {
            measureMetaData.setDescription(getDescription());
          }
          removeAutoMeasure(workspace, resolveField(workspace));
          removeMeasure(workspace, getName());
          workspace.getModel().getMeasures().add(measureMetaData);
          removeAutoLevel(workspace, locateLevel(workspace, resolveField(workspace)));
          workspace.getWorkspaceHelper().populateDomain(workspace);
          return true;
        }
      }
    }
    return false;
  }
 private void assertColumns(LogicalColumn lcolumn, Element column, String categoryId) {
   assertEquals(lcolumn.getId(), column.getId());
   assertEquals(lcolumn.getName(DEFAULT_LOCALE), column.getName());
   assertEquals(lcolumn.getDescription(DEFAULT_LOCALE), column.getDescription());
   assertEquals(categoryId, column.getParentId());
   assertEquals(lcolumn.getDataType().getName().toUpperCase(), column.getDataType());
   assertEquals(lcolumn.getFieldType().name(), column.getElementType());
   Assert.assertArrayEquals(
       new String[] {"SUM", "COUNT", "AVERAGE"}, column.getAvailableAggregations());
   assertEquals(lcolumn.getAggregationType().name(), column.getDefaultAggregation());
   assertEquals(lcolumn.getAggregationType().name(), column.getSelectedAggregation());
   assertEquals("LEFT", column.getHorizontalAlignment());
   assertEquals("test_mask", column.getFormatMask());
   Assert.assertFalse(column.isHiddenForUser());
 }
コード例 #11
0
  @Test
  public void testPopulateCategories_MultipleCategoriesAggregationTypesAndFormatMasks()
      throws ModelerException {
    ModelerWorkspaceHelper helper = new ModelerWorkspaceHelper(LOCALE);
    LogicalModel logicalModel = workspace.getLogicalModel(ModelerPerspective.REPORTING);
    helper.autoModelFlat(workspace);
    helper.autoModelRelationalFlat(workspace);
    spiceUpRelationalModel(workspace.getRelationalModel());
    helper.populateCategories(workspace);

    List<AvailableTable> tablesList = workspace.getAvailableTables().getAsAvailableTablesList();

    List<Category> categories = logicalModel.getCategories();
    assertEquals(2, categories.size());
    assertEquals(
        tablesList.get(0).getAvailableFields().size(),
        categories.get(0).getLogicalColumns().size());
    System.out.println(logicalModel.getLogicalTables().get(0).getLogicalColumns().size());

    assertEquals(1, categories.get(1).getLogicalColumns().size());

    for (int i = 0; i < categories.size(); i++) {

      for (LogicalColumn lCol : categories.get(i).getLogicalColumns()) {
        FieldMetaData orig = null;
        for (FieldMetaData fieldMetaData : workspace.getRelationalModel().getCategories().get(i)) {
          if (lCol.getId().equals(fieldMetaData.getLogicalColumn().getId())) {
            orig = fieldMetaData;
            break;
          }
        }
        assertNotNull(orig);
        assertEquals(orig.getDefaultAggregation(), lCol.getAggregationType());
        if (orig.getFormat().equals("NONE")) {
          if (orig.getLogicalColumn().getDataType() == DataType.NUMERIC) {
            assertTrue(((String) lCol.getProperty("mask")).indexOf("#") > -1);
          } else {
            assertTrue(lCol.getProperty("mask") == null);
          }
        } else {
          assertEquals(orig.getFormat(), lCol.getProperty("mask"));
        }
      }
    }
  }
コード例 #12
0
  @Test
  public void testPopulateCategories() throws ModelerException {
    ModelerWorkspaceHelper helper = new ModelerWorkspaceHelper(LOCALE);
    LogicalModel logicalModel = workspace.getDomain().getLogicalModels().get(0);
    List<AvailableTable> tablesList = workspace.getAvailableTables().getAsAvailableTablesList();

    int fields = tablesList.get(0).getAvailableFields().size();
    helper.autoModelFlat(workspace);
    helper.autoModelRelationalFlat(workspace);
    helper.populateCategories(workspace);

    List<Category> categories = logicalModel.getCategories();

    assertEquals(1, categories.size());
    assertEquals(fields, tablesList.get(0).getAvailableFields().size());
    System.out.println(logicalModel.getLogicalTables().get(0).getLogicalColumns().size());
    assertEquals(
        tablesList.get(0).getAvailableFields().size(),
        categories.get(0).getLogicalColumns().size());

    for (LogicalColumn lCol : categories.get(0).getLogicalColumns()) {
      FieldMetaData orig = null;
      for (FieldMetaData fieldMetaData : workspace.getRelationalModel().getCategories().get(0)) {
        if (lCol.getId().equals(fieldMetaData.getLogicalColumn().getId())) {
          orig = fieldMetaData;
          break;
        }
      }
      assertNotNull(orig);
      assertEquals(orig.getDefaultAggregation(), lCol.getAggregationType());
      if (orig.getFormat().equals("NONE")) {
        if (orig.getLogicalColumn().getDataType() == DataType.NUMERIC) {
          assertTrue("#".equals(lCol.getProperty("mask")));
        } else {
          assertTrue(lCol.getProperty("mask") == null);
        }
      } else {
        assertEquals(orig.getFormat(), lCol.getProperty("mask"));
      }
    }
  }
コード例 #13
0
  // this method signature is intended to provide a simpler path for unit testing the upConvert
  // method on its own
  protected void setDomain(Domain d, boolean upConvertDesired) {
    this.domain = d;
    this.setModelIsChanging(true);
    this.setRelationalModelIsChanging(true);
    this.model.getDimensions().clear();
    this.model.getMeasures().clear();
    this.relationalModel.getCategories().clear();
    this.availableTables.clear();

    if (upConvertDesired) {
      upConvertLegacyModel();
    }
    List<IAvailableItem> items = new ArrayList<IAvailableItem>();
    for (IPhysicalTable table : domain.getPhysicalModels().get(0).getPhysicalTables()) {
      Boolean isFact = (Boolean) table.getProperty("FACT_TABLE");
      items.add(new AvailableTable(table, isFact == null ? false : isFact.booleanValue()));
    }

    availableTables.setChildren(items);

    fireTablesChanged();

    LogicalModel lModel = domain.getLogicalModels().get(0);

    setModelName(lModel.getName(workspaceHelper.getLocale()));
    setRelationalModelName(lModel.getName(workspaceHelper.getLocale()));

    // Set the type of modeling session. This will propagate to the UI
    if (supportsOlap(domain)) {
      this.setModellingMode(ModelerMode.ANALYSIS_AND_REPORTING);
    } else {
      this.setModellingMode(ModelerMode.REPORTING_ONLY);
    }

    lModel = getLogicalModel(ModelerPerspective.ANALYSIS);
    List<OlapDimension> theDimensions = null;
    if (lModel != null) {
      theDimensions = (List) lModel.getProperty(LogicalModel.PROPERTY_OLAP_DIMS); // $NON-NLS-1$
    }
    if (theDimensions != null) {
      Iterator<OlapDimension> theDimensionItr = theDimensions.iterator();
      while (theDimensionItr.hasNext()) {
        OlapDimension theDimension = theDimensionItr.next();

        DimensionMetaData theDimensionMD =
            new DimensionMetaData(theDimension.getName(), theDimension.getType());
        theDimensionMD.setTimeDimension(theDimension.isTimeDimension());
        List<OlapHierarchy> theHierarchies = (List) theDimension.getHierarchies();
        Iterator<OlapHierarchy> theHierarchiesItr = theHierarchies.iterator();
        while (theHierarchiesItr.hasNext()) {
          OlapHierarchy theHierarchy = theHierarchiesItr.next();
          HierarchyMetaData theHierarchyMD = new HierarchyMetaData(theHierarchy.getName());

          List<OlapHierarchyLevel> theLevels = theHierarchy.getHierarchyLevels();
          Iterator<OlapHierarchyLevel> theLevelsItr = theLevels.iterator();
          while (theLevelsItr.hasNext()) {
            OlapHierarchyLevel theLevel = theLevelsItr.next();
            LevelMetaData theLevelMD = new LevelMetaData(theHierarchyMD, theLevel.getName());

            theLevelMD.setParent(theHierarchyMD);

            theLevelMD.setUniqueMembers(theLevel.isHavingUniqueMembers());
            if (theDimensionMD.isTimeDimension()) {
              TimeRole role = TimeRole.fromMondrianAttributeValue(theLevel.getLevelType());
              if (role != null) {
                theLevelMD.setDataRole(role);
              }
            }

            // Make sure we're dealing with the OLAP copy. Note that duplicated columns will have an
            // OLAP_[0-9]+ at the
            // end
            String refID;
            LogicalColumn olapCol;

            olapCol = theLevel.getReferenceColumn();
            if (olapCol != null) {
              refID = olapCol.getId();
              if (!refID.endsWith(BaseModelerWorkspaceHelper.OLAP_SUFFIX)
                  && !refID.contains(BaseModelerWorkspaceHelper.OLAP_SUFFIX + "_")) {
                olapCol = ModelerConversionUtil.findCorrespondingOlapColumn(olapCol, lModel);
                theLevel.setReferenceColumn(olapCol);
              }
              theLevelMD.setLogicalColumn(olapCol);
            }

            olapCol = theLevel.getReferenceOrdinalColumn();
            if (olapCol != null) {
              refID = olapCol.getId();
              if (!refID.endsWith(BaseModelerWorkspaceHelper.OLAP_SUFFIX)
                  && !refID.contains(BaseModelerWorkspaceHelper.OLAP_SUFFIX + "_")) {
                olapCol = ModelerConversionUtil.findCorrespondingOlapColumn(olapCol, lModel);
                theLevel.setReferenceOrdinalColumn(olapCol);
              }
              theLevelMD.setLogicalOrdinalColumn(olapCol);
            }

            olapCol = theLevel.getReferenceCaptionColumn();
            if (olapCol != null) {
              refID = olapCol.getId();
              if (!refID.endsWith(BaseModelerWorkspaceHelper.OLAP_SUFFIX)
                  && !refID.contains(BaseModelerWorkspaceHelper.OLAP_SUFFIX + "_")) {
                olapCol = ModelerConversionUtil.findCorrespondingOlapColumn(olapCol, lModel);
                theLevel.setReferenceCaptionColumn(olapCol);
              }
              theLevelMD.setLogicalCaptionColumn(olapCol);
            }
            // get any logicalColumns and turn them into member properties
            if (theLevel.getLogicalColumns() != null && theLevel.getLogicalColumns().size() > 0) {
              for (LogicalColumn lc : theLevel.getLogicalColumns()) {
                // BISERVER-11578 - Protect against null lc's in the collection. We still need to
                // investigate why this can happen in the model.
                if (lc == null) {
                  continue;
                }

                if (!lc.getId().endsWith(BaseModelerWorkspaceHelper.OLAP_SUFFIX)
                    && !lc.getId().contains(BaseModelerWorkspaceHelper.OLAP_SUFFIX + "_")) {
                  // not pointing to the olap col
                  lc = ModelerConversionUtil.findCorrespondingOlapColumn(lc, lModel);
                }
                MemberPropertyMetaData memberProp =
                    new MemberPropertyMetaData(theLevelMD, lc.getName(workspaceHelper.getLocale()));
                memberProp.setLogicalColumn(lc);
                memberProp.setDescription(lc.getDescription(workspaceHelper.getLocale()));
                theLevelMD.add(memberProp);
              }
            }
            List<OlapAnnotation> annotations = theLevel.getAnnotations();
            if (annotations != null) {
              for (OlapAnnotation anno : annotations) {
                IMemberAnnotation annoMeta = MemberAnnotationFactory.create(anno);
                theLevelMD.getMemberAnnotations().put(anno.getName(), annoMeta);
              }
            }
            theHierarchyMD.add(theLevelMD);
          }

          theHierarchyMD.setParent(theDimensionMD);
          theDimensionMD.add(theHierarchyMD);
        }
        this.model.getDimensions().add(theDimensionMD);
      }
    }
    List<OlapCube> theCubes = null;
    if (lModel != null) {
      theCubes = (List) lModel.getProperty(LogicalModel.PROPERTY_OLAP_CUBES); // $NON-NLS-1$
    }
    if (theCubes != null) {
      Iterator<OlapCube> theCubeItr = theCubes.iterator();
      while (theCubeItr.hasNext()) {
        OlapCube theCube = theCubeItr.next();

        List<OlapMeasure> theMeasures = theCube.getOlapMeasures();
        Iterator<OlapMeasure> theMeasuresItr = theMeasures.iterator();
        while (theMeasuresItr.hasNext()) {
          OlapMeasure theMeasure = theMeasuresItr.next();

          MeasureMetaData theMeasureMD = new MeasureMetaData(workspaceHelper.getLocale());

          if (theMeasure.getName() == null || theMeasure.getName().length() == 0) {
            theMeasureMD.setName(
                theMeasure.getLogicalColumn().getName(workspaceHelper.getLocale()));
          } else {
            theMeasureMD.setName(theMeasure.getName());
          }
          theMeasureMD.setFormat(
              (String) theMeasure.getLogicalColumn().getProperty("mask")); // $NON-NLS-1$
          theMeasureMD.setDefaultAggregation(theMeasure.getLogicalColumn().getAggregationType());
          String possibleMeasureName = theMeasure.getLogicalColumn().getId();
          if (!theMeasure
                  .getLogicalColumn()
                  .getId()
                  .endsWith(BaseModelerWorkspaceHelper.OLAP_SUFFIX)
              && !theMeasure
                  .getLogicalColumn()
                  .getId()
                  .contains(BaseModelerWorkspaceHelper.OLAP_SUFFIX + "_")) {
            // change the backing column to the olap version
            LogicalColumn olapCol =
                ModelerConversionUtil.findCorrespondingOlapColumn(
                    theMeasure.getLogicalColumn(), lModel);
            theMeasure.setLogicalColumn(olapCol);
          }

          // BISERVER-6077 - Mondrian exporter uses logical column names as measure names, make sure
          // they get set
          // properly
          LogicalColumn lCol = theMeasure.getLogicalColumn();
          Set<String> locales = lCol.getName().getLocales();
          String[] stringLocals = locales.toArray(new String[] {});
          if (stringLocals != null && stringLocals.length > 0) {
            if (theMeasure.getName() == null || theMeasure.getName().trim().length() == 0) {
              theMeasure.setName(possibleMeasureName);
            }
            lCol.setName(new LocalizedString(stringLocals[0], theMeasure.getName()));
          }

          theMeasureMD.setLogicalColumn(lCol);
          this.model.getMeasures().add(theMeasureMD);
        }
      }
    }

    lModel = this.getLogicalModel(ModelerPerspective.REPORTING);
    int i = 1;
    for (Category cat : lModel.getCategories()) {
      String catName =
          BaseModelerWorkspaceHelper.getCleanCategoryName(
              cat.getName(workspaceHelper.getLocale()), this, i++);
      CategoryMetaData catMeta = new CategoryMetaData(catName);
      for (LogicalColumn col : cat.getLogicalColumns()) {
        LogicalTable table = col.getLogicalTable();

        if (!table.getLogicalColumns().contains(col)) {
          table.addLogicalColumn(col);
        }

        Object formatMask = col.getProperty("mask");
        String colName = col.getName(workspaceHelper.getLocale());
        AggregationType aggType = col.getAggregationType();

        FieldMetaData field =
            new FieldMetaData(
                catMeta,
                colName,
                formatMask == null ? null : formatMask.toString(),
                colName,
                workspaceHelper.getLocale());
        if (aggType != null) {
          field.setDefaultAggregation(aggType);
        } else {
          field.setDefaultAggregation(AggregationType.NONE);
        }
        field.setLogicalColumn(col);

        catMeta.add(field);
      }
      this.getRelationalModel().getCategories().add(catMeta);
    }

    this.setModelIsChanging(false, true);
    this.setRelationalModelIsChanging(false, true);
  }
コード例 #14
0
ファイル: CreateMeasure.java プロジェクト: pentaho/modeler
 private boolean columnMatches(
     final ModelerWorkspace workspace, final String column, final LogicalColumn logicalColumn) {
   return column.equalsIgnoreCase(
       logicalColumn.getName(workspace.getWorkspaceHelper().getLocale()));
 }
コード例 #15
0
  public Document getLookup() {
    // Create a document that describes the result
    Document doc = DocumentHelper.createDocument();

    Element root = doc.addElement("metadata"); // $NON-NLS-1$

    if (domainName == null) {
      // we can't do this without a model
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_NO_DOMAIN_SPECIFIED")); //$NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    if (modelId == null) {
      // we can't do this without a view
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_NO_MODEL_SPECIFIED")); //$NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    if (columnId == null) {
      // we can't do this without a view
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_NO_COLUMN_SPECIFIED")); //$NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    Domain domain = getMetadataRepository().getDomain(domainName);
    String locale =
        LocaleHelper.getClosestLocale(LocaleHelper.getLocale().toString(), domain.getLocaleCodes());
    LogicalModel model =
        domain.findLogicalModel(modelId); // This is the business view that was selected.
    if (model == null) {
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_MODEL_LOADING_ERROR",
                      modelId)); //$NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    LogicalColumn column = model.findLogicalColumn(columnId);
    if (column == null) {
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString("PMDUIComponent.USER_COLUMN_NOT_FOUND")); // $NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    // Temporary hack to get the BusinessCategory. When fixed properly, you should be able to
    // interrogate the
    // business column thingie for it's containing BusinessCategory.
    Category view = null;
    for (Category category : model.getCategories()) {
      for (LogicalColumn col : category.getLogicalColumns()) {
        if (col.getId().equals(column.getId())) {
          view = category;
          break;
        }
      }
    }

    if (view == null) {
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString("PMDUIComponent.USER_VIEW_NOT_FOUND")); // $NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    String mql =
        "<mql><domain_type>relational</domain_type><domain_id>"
            + domainName
            + "</domain_id><model_id>"
            + modelId
            + "</model_id>"; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    if (column.getProperty("lookup") == null) { // $NON-NLS-1$
      mql +=
          "<selection><view>"
              + view.getId()
              + "</view><column>"
              + column.getId()
              + "</column></selection>"; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
      mql +=
          "<orders><order><direction>asc</direction><view_id>"
              + view.getId()
              + "</view_id><column_id>"
              + column.getId()
              + "</column_id></order></orders>"; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$

    } else {

      String lookup = (String) column.getProperty("lookup"); // $NON-NLS-1$
      // assume model and view are the same...
      StringTokenizer tokenizer1 = new StringTokenizer(lookup, ";"); // $NON-NLS-1$
      while (tokenizer1.hasMoreTokens()) {
        StringTokenizer tokenizer2 =
            new StringTokenizer(tokenizer1.nextToken(), "."); // $NON-NLS-1$
        if (tokenizer2.countTokens() == 2) {
          String lookupViewId = tokenizer2.nextToken();
          String lookupColumnId = tokenizer2.nextToken();
          mql +=
              "<selection><view>"
                  + lookupViewId
                  + "</view><column>"
                  + lookupColumnId
                  + "</column></selection>"; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
        }
      }
    }
    mql += "</mql>"; // $NON-NLS-1$
    ArrayList messages = new ArrayList();
    SimpleParameterProvider lookupParameters = new SimpleParameterProvider();
    lookupParameters.setParameter("mql", mql); // $NON-NLS-1$

    IRuntimeContext runtime =
        SolutionHelper.doAction(
            "/system/metadata/PickList.xaction",
            "lookup-list",
            lookupParameters,
            getSession(),
            messages,
            this); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
    IPentahoResultSet results = null;
    if (runtime != null) {
      if (runtime.getStatus() == IRuntimeContext.RUNTIME_STATUS_SUCCESS) {
        if (runtime.getOutputNames().contains("data")) { // $NON-NLS-1$
          results = runtime.getOutputParameter("data").getValueAsResultSet(); // $NON-NLS-1$
          Object[][] columnHeaders = results.getMetaData().getColumnHeaders();
          boolean hasColumnHeaders = columnHeaders != null;

          Element rowElement;
          Element dataElement = root.addElement("data"); // $NON-NLS-1$
          if (hasColumnHeaders) {
            for (int rowNo = 0; rowNo < columnHeaders.length; rowNo++) {
              rowElement = dataElement.addElement("COLUMN-HDR-ROW"); // $NON-NLS-1$
              for (int columnNo = 0; columnNo < columnHeaders[rowNo].length; columnNo++) {
                Object nameAttr =
                    results.getMetaData().getAttribute(rowNo, columnNo, "name"); // $NON-NLS-1$
                if ((nameAttr != null) && (nameAttr instanceof LocalizedString)) {
                  LocalizedString str = (LocalizedString) nameAttr;
                  String name = str.getLocalizedString(locale);
                  if (name != null) {
                    rowElement.addElement("COLUMN-HDR-ITEM").setText(name); // $NON-NLS-1$
                  } else {
                    rowElement
                        .addElement("COLUMN-HDR-ITEM")
                        .setText(columnHeaders[rowNo][columnNo].toString()); // $NON-NLS-1$
                  }
                } else {
                  rowElement
                      .addElement("COLUMN-HDR-ITEM")
                      .setText(columnHeaders[rowNo][columnNo].toString()); // $NON-NLS-1$
                }
              }
            }
          }
          Object[] row = results.next();
          while (row != null) {
            rowElement = dataElement.addElement("DATA-ROW"); // $NON-NLS-1$
            for (Object element : row) {
              if (element == null) {
                rowElement.addElement("DATA-ITEM").setText(""); // $NON-NLS-1$ //$NON-NLS-2$
              } else {
                rowElement.addElement("DATA-ITEM").setText(element.toString()); // $NON-NLS-1$
              }
            }
            row = results.next();
          }
        }
      }
    }

    return doc;
  }
コード例 #16
0
  private Document loadModel() {
    // Create a document that describes the result
    Document doc = DocumentHelper.createDocument();

    Element root = doc.addElement("metadata"); // $NON-NLS-1$

    if (domainName == null) {
      // we can't do this without a model
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_NO_DOMAIN_SPECIFIED")); //$NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    if (modelId == null) {
      // we can't do this without a model
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_NO_MODEL_SPECIFIED")); //$NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }

    Element modelNode = root.addElement("model"); // $NON-NLS-1$

    // because it's lighter weight, check the thin model
    Domain domain = getMetadataRepository().getDomain(domainName);
    if (domain == null) {
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_DOMAIN_LOADING_ERROR",
                      domainName)); //$NON-NLS-1$ //$NON-NLS-2$
      return doc;
    }
    String locale =
        LocaleHelper.getClosestLocale(LocaleHelper.getLocale().toString(), domain.getLocaleCodes());
    LogicalModel model = domain.findLogicalModel(modelId);

    if (model == null) {
      root.addElement("message")
          .setText(
              Messages.getInstance()
                  .getString(
                      "PMDUIComponent.USER_MODEL_LOADING_ERROR",
                      modelId)); //$NON-NLS-1$ //$NON-NLS-2$
      error(
          Messages.getInstance()
              .getString("PMDUIComponent.USER_MODEL_LOADING_ERROR", modelId)); // $NON-NLS-1$
      return doc;
    }
    modelNode.addElement("domain_id").setText(domainName); // $NON-NLS-1$
    if (model.getId() != null) {
      modelNode.addElement("model_id").setText(model.getId()); // $NON-NLS-1$
    }
    if (model.getName(locale) != null) {
      modelNode.addElement("model_name").setText(model.getName(locale)); // $NON-NLS-1$
    }
    if (model.getDescription(locale) != null) {
      modelNode
          .addElement("model_description")
          .setText(model.getDescription(locale)); // $NON-NLS-1$
    }

    Element tableNode;

    for (Category category : model.getCategories()) {
      tableNode = modelNode.addElement("view"); // $NON-NLS-1$
      if (category.getId() != null) {
        tableNode.addElement("view_id").setText(category.getId()); // $NON-NLS-1$
      }
      if (category.getName(locale) != null) {
        tableNode.addElement("view_name").setText(category.getName(locale)); // $NON-NLS-1$
      }
      if (category.getDescription(locale) != null) {
        tableNode
            .addElement("view_description")
            .setText(category.getDescription(locale)); // $NON-NLS-1$
      }
      for (LogicalColumn column : category.getLogicalColumns()) {
        Boolean hidden = (Boolean) column.getProperty("hidden"); // $NON-NLS-1$
        if (hidden != null && hidden) {
          continue;
        }
        addColumn(column, tableNode, locale);
      }
    }

    return doc;
  }