Examples of addAggregateColumn()

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

174
175
176
177
178
179
180
181
182
183
184
        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");
     
      // aggregate measures
      List dataMartSelectFields = query.getDataMartSelectFields(true);
      Iterator it = dataMartSelectFields.iterator();
      while (it.hasNext()) {
View Full Code Here

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

185
186
187
188
189
190
191
192
193
194
195
        DataMartSelectField field = (DataMartSelectField) it.next();
        int fieldIndex = query.getSelectFieldIndex(field.getUniqueName());       
        String[] f = (String[])selectFields.get(fieldIndex);
        IAggregationFunction aggregationFunction = field.getFunction();
        if (aggregationFunction != null && aggregationFunction != AggregationFunctions.NONE_FUNCTION) {
          transformer.addAggregateColumn(f[1]!=null? f[1]:f[0], aggregationFunction.getName(), field.getAlias());
        }
      }
     
      sqlQuery = (String)transformer.transformQuery(sqlQuery);
     
View Full Code Here

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

91
92
93
94
95
96
97
98
99
100
101
          aggregationFunction = datamartProvider.getMetaData().getAggregationFunction(measureColumnName);
          if( StringUtilities.isEmpty(aggregationFunction) ) {
            aggregationFunction = "SUM";
          }
         
          queryGroupByTransformer.addAggregateColumn(measureColumnName, aggregationFunction);
        }
       
        queryGroupByTransformer.setPreviousTransformer( this.getPreviousTransformer() );
         
        queryDrillTransformer = queryGroupByTransformer;
View Full Code Here

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

123
124
125
126
127
128
129
130
131
132
133
          aggregationFunction = datamartProvider.getMetaData().getAggregationFunction(measureColumnName);
          if( StringUtilities.isEmpty(aggregationFunction) ) {
            aggregationFunction = "SUM";
          }
         
          normalizationQueryTransformer.addAggregateColumn(measureColumnName, aggregationFunction);
        }
                 
        //normalizedSubQuery = (String)normalizationQueryTransformer.transformStatment(query);
        // ==========================================================
       
View Full Code Here

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

188
189
190
191
192
193
194
195
196
197
198
          aggregationFunction = datamartProvider.getMetaData().getAggregationFunction(measureColumnName);
          if( StringUtilities.isEmpty(aggregationFunction) ) {
            aggregationFunction = "SUM";
          }
         
          normalizeJoinedQueryTransformer.addAggregateColumn(measureColumnName, aggregationFunction);
        }
       
        //aggragateQuery = (String)normalizeJoinedQueryTransformer.transformStatment(joinedQuery);
        // ==========================================================    
       
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.