Package org.saiku.olap.query

Examples of org.saiku.olap.query.IQuery

1004
1005
1006
1007
1008
1009
1010
1011
    }
  }


  public void resetQuery(String queryName) {
    IQuery query = getIQuery(queryName);
    query.resetQuery();
  }
View Full Code Here
1009
1010
1011
1012
1013
1014
1015
1016
1017
    IQuery query = getIQuery(queryName);
    query.resetQuery();
  }

  public void setNonEmpty(String queryName, String axisName, boolean bool) {
    IQuery query = getIQuery(queryName);
    QueryAxis newAxis = query.getAxis(Axis.Standard.valueOf(axisName));
    newAxis.setNonEmpty(bool);
  }
View Full Code Here
1015
1016
1017
1018
1019
1020
1021
1022
1023
    QueryAxis newAxis = query.getAxis(Axis.Standard.valueOf(axisName));
    newAxis.setNonEmpty(bool);
  }

  public Properties setProperties(String queryName, Properties props) {
    IQuery query = getIQuery(queryName);
    query.setProperties(props);
    return getProperties(queryName);
  }
View Full Code Here
1022
1023
1024
1025
1026
1027
1028
1029
1030
    return getProperties(queryName);
  }


  public Properties getProperties(String queryName) {
    IQuery query = getIQuery(queryName);
    Properties props = query.getProperties();
    return props;
  }
View Full Code Here
1032
1033
1034
1035
1036
1037
1038
1039
  public String getMDXQuery(String queryName) {
    return getIQuery(queryName).getMdx();
  }

  public String getQueryXml(String queryName) {
    IQuery query = getIQuery(queryName);
    return query.toXml();
  }
View Full Code Here
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
    return getExport(queryName, type, new FlattenedCellSetFormatter());
  }

  byte[] getExport(String queryName, @Nullable String type, ICellSetFormatter formatter) {
    if (type != null) {
      IQuery query = getIQuery(queryName);
      CellSet rs = query.getCellset();
      List<SaikuDimensionSelection> filters = new ArrayList<SaikuDimensionSelection>();

      if (query.getType().equals(QueryType.QM)) {
        filters = getAxisSelection(queryName, "FILTER");
      }
      if (type.toLowerCase().equals("xls")) {
        // TODO - added null parameter for filters - not used anymore
        return ExcelExporter.exportExcel(rs, formatter, null);
View Full Code Here
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
    }
    return new byte[0];
  }

  public void qm2mdx(String queryName) {
    IQuery query = getIQuery(queryName);
    OlapConnection con = olapDiscoverService.getNativeConnection(query.getSaikuCube().getConnection());
    MdxQuery mdx = new MdxQuery(con, query.getSaikuCube(), query.getName(), getMDXQuery(queryName));
    putIQuery(queryName, mdx);
    query = null;
  }
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
    try {
      Cube cub = olapDiscoverService.getNativeCube(cube);
      OlapConnection con = olapDiscoverService.getNativeConnection(cube.getConnection());

      if (cub != null) {
        IQuery query = new OlapQuery(new Query(queryName, cub), con, cube);
        putIQuery(queryName, query);
        return ObjectUtil.convert(query);
      }
    } catch (Exception e) {
      LOG.error("Cannot create new query for cube :" + cube, e);
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
  public SaikuQuery createNewOlapQuery(@Nullable String name, @NotNull String xml) {
    try {
      QueryDeserializer qd = new QueryDeserializer();
      SaikuCube scube = qd.getFakeCube(xml);
      OlapConnection con = olapDiscoverService.getNativeConnection(scube.getConnection());
      IQuery query = qd.unparse(xml, con);
      // TODO - this is not good! could lead to duplicate queries
      if (name == null) {
        name = UUID.randomUUID().toString();
        putIQuery(name, query);
      } else {
View Full Code Here
143
144
145
146
147
148
149
150
151
152
153
154
  }


  void closeQuery(String queryName) {
    try {
      IQuery q = getIQuery(queryName);
      q.cancel();
      removeIQuery(queryName);
    } catch (Exception e) {
      throw new SaikuServiceException("Error closing query: " + queryName, e);
    }
  }
View Full Code Here
TOP

Related Classes of org.saiku.olap.query.IQuery

  • org.saiku.service.olap.OlapQueryService
  • org.saiku.service.olap.ThinQueryService
  • org.saiku.service.util.ObjectHolder
  • org.saiku.web.rest.resources.QueryResource
    • 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.