Package org.saiku.olap.query2

Examples of org.saiku.olap.query2.Parameter

600
601
602
603
604
605
606
607
608
609
610
      }
      ObjectMapper mapper = new ObjectMapper();
      Map<String, List<String>> levels = mapper.readValue(returns, TypeFactory
          .mapType(Map.class, TypeFactory.fromClass(String.class),
              TypeFactory.collectionType(ArrayList.class, String.class)));
      ThinQuery q = thinQueryService.drillacross(queryName, cellPosition, levels);
      return q;

    } catch (Exception e) {
      LOG.error("Cannot execute query (" + queryName + ")", e);
      String error = ExceptionUtils.getRootCauseMessage(e);
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
87
88
      String queryName = UUID.randomUUID().toString();
      //fileContent = ServletUtil.replaceParameters(servletRequest, fileContent);
//queryResource.createQuery(queryName,  null,  null, null, fileContent, queryName, null);
//queryResource.execute(queryName, formatter, 0);
      Map<String, String> parameters = ServletUtil.getParameters(servletRequest);
      ThinQuery tq = query2Resource.createQuery(queryName, fileContent, null, null);
      if (parameters != null) {
        tq.getParameters().putAll(parameters);
      }
      query2Resource.execute(tq);
      return query2Resource.getQueryExcelExport(queryName, formatter);
    } catch (Exception e) {
      LOG.error("Error exporting XLS for file: " + file, e);
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
113
114
      //fileContent = ServletUtil.replaceParameters(servletRequest, fileContent);
      String queryName = UUID.randomUUID().toString();
//query2Resource.createQuery(null,  null,  null, null, fileContent, queryName, null);
//query2Resource.execute(queryName,formatter, 0);
      Map<String, String> parameters = ServletUtil.getParameters(servletRequest);
      ThinQuery tq = query2Resource.createQuery(queryName, fileContent, null, null);
      if (parameters != null) {
        tq.getParameters().putAll(parameters);
      }
      query2Resource.execute(tq);
      return query2Resource.getQueryCsvExport(queryName);
    } catch (Exception e) {
      LOG.error("Error exporting CSV for file: " + file, e);
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
139
140
      fileContent = ServletUtil.replaceParameters(servletRequest, fileContent);
      String queryName = UUID.randomUUID().toString();
//query2Resource.createQuery(null,  null,  null, null, fileContent, queryName, null);
//QueryResult qr = query2Resource.execute(queryName, formatter, 0);
      Map<String, String> parameters = ServletUtil.getParameters(servletRequest);
      ThinQuery tq = query2Resource.createQuery(queryName, fileContent, null, null);
      if (parameters != null) {
        tq.getParameters().putAll(parameters);
      }
      QueryResult qr = query2Resource.execute(tq);
      return Response.ok().entity(qr).build();
    } catch (Exception e) {
      LOG.error("Error exporting JSON for file: " + file, e);
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
  @Deprecated
  public ThinQuery createEmpty(String name, SaikuCube cube) {
    try {
      Cube cub = olapDiscoverService.getNativeCube(cube);
      Query query = new Query(name, cub);
      ThinQuery tq = Thin.convert(query, cube);
      return tq;

    } catch (Exception e) {
      LOG.error("Cannot create new query for cube :" + cube, e);
    }
View Full Code Here
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
  }

  @NotNull
  public CellDataSet getFormattedResult(String query, @NotNull String format) throws Exception {
    QueryContext qc = getContext(query);
    ThinQuery tq = qc.getOlapQuery();
    CellSet cs = qc.getOlapResult();
    String formatterName = StringUtils.isBlank(format) ? "" : format.toLowerCase();
    ICellSetFormatter cf = cff.forName(formatterName);
    CellDataSet result = OlapResultSetUtil.cellSet2Matrix(cs, cf);

    if (ThinQuery.Type.QUERYMODEL.equals(tq.getType()) && cf instanceof FlattenedCellSetFormatter && tq
        .hasAggregators()) {
      calculateTotals(tq, result, cs, cf);
    }
    return result;
  }
View Full Code Here
261
262
263
264
265
266
267
268
269
270
271
272
273
  @NotNull
  public ThinQuery updateQuery(@NotNull ThinQuery old) throws Exception {
    if (ThinQuery.Type.QUERYMODEL.equals(old.getType())) {
      Cube cub = olapDiscoverService.getNativeCube(old.getCube());
      Query q = Fat.convert(old, cub);
      ThinQuery tqAfter = Thin.convert(q, old.getCube());
      old.setQueryModel(tqAfter.getQueryModel());
      old.setMdx(tqAfter.getMdx());
    }
    if (context.containsKey(old.getName())) {
      QueryContext qc = context.get(old.getName());
      qc.store(ObjectKey.QUERY, old);
    }
View Full Code Here
303
304
305
306
307
308
309
310
311
312
313
314
315
316
  }

  byte[] getExport(String queryName, @NotNull String type, ICellSetFormatter formatter) {
    if (StringUtils.isNotBlank(type) && context.containsKey(queryName)) {
      CellSet rs = context.get(queryName).getOlapResult();
      ThinQuery tq = context.get(queryName).getOlapQuery();
      List<ThinHierarchy> filterHierarchies = null;
      if (ThinQuery.Type.QUERYMODEL.equals(tq.getType())) {
        filterHierarchies = tq.getQueryModel().getAxes().get(AxisLocation.FILTER).getHierarchies();
      }
      if (type.toLowerCase().equals("xls")) {
        return ExcelExporter.exportExcel(rs, formatter, filterHierarchies);
      }
      if (type.toLowerCase().equals("csv")) {
View Full Code Here
323
324
325
326
327
328
329
330
331
332
333
334
335
336
  public ResultSet drillthrough(String queryName, int maxrows, String returns) {
    OlapStatement stmt = null;
    try {

      ThinQuery query = context.get(queryName).getOlapQuery();
      final OlapConnection con = olapDiscoverService.getNativeConnection(query.getCube().getConnection());
      stmt = con.createStatement();
      String mdx = query.getMdx();
      if (maxrows > 0) {
        mdx = "DRILLTHROUGH MAXROWS " + maxrows + " " + mdx;
      } else {
        mdx = "DRILLTHROUGH " + mdx;
      }
View Full Code Here
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
  public ResultSet drillthrough(String queryName, @NotNull List<Integer> cellPosition, Integer maxrows,
                                String returns) {
    OlapStatement stmt = null;
    try {
      QueryContext queryContext = context.get(queryName);
      ThinQuery query = queryContext.getOlapQuery();
      CellSet cs = queryContext.getOlapResult();
      SaikuCube cube = query.getCube();
      final OlapConnection con = olapDiscoverService.getNativeConnection(cube.getConnection());
      stmt = con.createStatement();

      SelectNode sn = new DefaultMdxParserImpl().parseSelect(query.getMdx());
      String select = null;
      StringBuilder buf = new StringBuilder();
      if (sn.getWithList() != null && sn.getWithList().size() > 0) {
        buf.append("WITH \n");
        StringWriter sw = new StringWriter();
View Full Code Here
TOP

Related Classes of org.saiku.olap.query2.Parameter

  • com.alibaba.citrus.util.internal.ToStringBuilder
  • com.alibaba.citrus.util.ToStringBuilder
  • it.eng.spagobi.tools.dataset.common.datastore.IField
  • net.oauth.v2.example.provider.servlets.AuthorizationServlet2
  • org.andromda.metafacades.emf.uml2.OperationFacadeLogicImpl
  • org.andromda.metafacades.emf.uml2.UmlUtilities
  • org.apache.commons.lang.builder.HashCodeBuilder
  • org.olap4j.Axis
  • org.olap4j.metadata.Hierarchy
  • org.olap4j.metadata.Measure
    • Copyright © 2018 www.massapicom. 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.