Examples of addGrouByColumn()

Examples of it.eng.spagobi.tools.dataset.common.query.GroupByQueryTransformer.addGrouByColumn()

170
171
172
173
174
175
176
177
178
179
180
      for(int i = 0; i < groupFields.length(); i++) {
        String groupByField = groupFields.getString(i);
        int fieldIndex = query.getSelectFieldIndex(groupByField);   
        Assert.assertTrue(fieldIndex >= 0 && fieldIndex <selectFields.size(), "Impossible to group on field [" + groupByField + "]");
        String[] f = (String[])selectFields.get(fieldIndex);       
        transformer.addGrouByColumn(f[1]!=null? f[1]:f[0], query.getSelectFieldByIndex(fieldIndex).getAlias());
      }
     
      // count column
      transformer.addAggregateColumn("*"/*f[1]!=null? f[1]:f[0]*/, "COUNT", "Records");
     
View Full Code Here

Examples of it.eng.spagobi.tools.dataset.common.query.GroupByQueryTransformer.addGrouByColumn()

78
79
80
81
82
83
84
85
86
87
88
       
        queryGroupByTransformer = new GroupByQueryTransformer();
       
        // group on the column associated to the selected level into the selected hierarchy
        String aggregationColumnName = datamartProvider.getSelectedLevel().getColumnId();
        queryGroupByTransformer.addGrouByColumn( aggregationColumnName );
       
        // aggregate on the column defined as measure in the metadata configuration block
        it = measureColumnNames.iterator();
        while(it.hasNext()) {
          String measureColumnName= (String)it.next();
View Full Code Here

Examples of it.eng.spagobi.tools.dataset.common.query.GroupByQueryTransformer.addGrouByColumn()

110
111
112
113
114
115
116
117
118
119
120
       
        normalizationQueryTransformer = new GroupByQueryTransformer();
       
        // group on the column in the given query that refers to the geographical dimension table
        String aggregationColumnName = datamartProvider.getMetaData().getGeoIdColumnName( datamartProvider.getSelectedHierarchy().getName() );
        normalizationQueryTransformer.addGrouByColumn( aggregationColumnName );
       
        // aggregate on the column defined as measure in the metadata configuration block
        it = measureColumnNames.iterator();
        while(it.hasNext()) {
          String measureColumnName= (String)it.next();
View Full Code Here

Examples of it.eng.spagobi.tools.dataset.common.query.GroupByQueryTransformer.addGrouByColumn()

175
176
177
178
179
180
181
182
183
184
185
        // --------------------------------------------------------------
        GroupByQueryTransformer normalizeJoinedQueryTransformer;
       
        normalizeJoinedQueryTransformer = new GroupByQueryTransformer();
       
        normalizeJoinedQueryTransformer.addGrouByColumn( datamartProvider.getSelectedLevel().getColumnId() );
       
        // aggregate on the column defined as measure in the metadata configuration block
        it = measureColumnNames.iterator();
        while(it.hasNext()) {
          String measureColumnName= (String)it.next();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.