Package org.saiku.olap.query

Examples of org.saiku.olap.query.IQuery

698
699
700
701
702
703
704
705
706
707
708
709
710
    query.setTotalFunction(axisName, functionName);
    return query;
  }

  public boolean includeChildren(String queryName, String dimensionName, String uniqueMemberName) {
    IQuery query = getIQuery(queryName);
    List<IdentifierSegment> memberList = IdentifierNode.parseIdentifier(uniqueMemberName).getSegmentList();
    QueryDimension dimension = query.getDimension(dimensionName);
    try {
      Selection sel = dimension.createSelection(Operator.CHILDREN, memberList);
      dimension.getInclusions().add(sel);
      return true;
    } catch (OlapException e) {
View Full Code Here
713
714
715
716
717
718
719
720
721
722
723
724
725
          + uniqueMemberName + ")", e);
    }
  }

  public boolean removeChildren(String queryName, String dimensionName, String uniqueMemberName) {
    IQuery query = getIQuery(queryName);
    List<IdentifierSegment> memberList = IdentifierNode.parseIdentifier(uniqueMemberName).getSegmentList();
    QueryDimension dimension = query.getDimension(dimensionName);
    try {
      Selection sel = dimension.createSelection(Operator.CHILDREN, memberList);
      if (dimension.getInclusions().contains(sel)) {
        dimension.getInclusions().remove(sel);
      }
View Full Code Here
730
731
732
733
734
735
736
737
738
739
740
741
          + uniqueMemberName + ")", e);
    }
  }

  boolean removeAllChildren(String queryName, String dimensionName) {
    IQuery query = getIQuery(queryName);
    QueryDimension dimension = query.getDimension(dimensionName);
    List<Selection> children = new ArrayList<Selection>();
    try {
      for (Selection sel : dimension.getInclusions()) {
        if (sel.getOperator().equals(Operator.CHILDREN)) {
          children.add(sel);
View Full Code Here
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
        memberposition);
  }

  public boolean includeMember(String queryName, String dimensionName, String uniqueMemberName, String selectionType,
                               String totalsFunction, int memberposition) {
    IQuery query = getIQuery(queryName);


    List<IdentifierSegment> memberList = IdentifierNode.parseIdentifier(uniqueMemberName).getSegmentList();
    QueryDimension dimension = query.getDimension(dimensionName);
    final Selection.Operator selectionMode = Selection.Operator.valueOf(selectionType);
    try {
      removeAllChildren(queryName, dimensionName);
      Selection sel = dimension.createSelection(selectionMode, memberList);
      if (dimension.getInclusions().contains(sel)) {
        dimension.getInclusions().remove(sel);
      }
      if (memberposition < 0) {
        memberposition = dimension.getInclusions().size();
      }
      dimension.getInclusions().add(memberposition, sel);
      query.setTotalFunction(((Member) sel.getRootElement()).getLevel().getUniqueName(), totalsFunction);
      return true;
    } catch (OlapException e) {
      throw new SaikuServiceException(
          "Cannot include member query (" + queryName + ") dimension (" + dimensionName + ") member ("
          + uniqueMemberName + ") operator (" + selectionType + ") position " + memberposition, e);
View Full Code Here
783
784
785
786
787
788
789
790
791
792
793
794
795
796
    }
  }

  public boolean removeMember(String queryName, String dimensionName, String uniqueMemberName, String selectionType)
      throws SaikuServiceException {
    IQuery query = getIQuery(queryName);
    removeAllChildren(queryName, dimensionName);
    List<IdentifierSegment> memberList = IdentifierNode.parseIdentifier(uniqueMemberName).getSegmentList();
    QueryDimension dimension = query.getDimension(dimensionName);
    final Selection.Operator selectionMode = Selection.Operator.valueOf(selectionType);
    try {
      if (LOG.isDebugEnabled()) {
        LOG.debug("query: " + queryName + " remove:" + selectionMode.toString() + " " + memberList.size());
      }
View Full Code Here
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
    return includeLevel(queryName, dimensionName, uniqueHierarchyName, uniqueLevelName, defaultTotalsFunction);
  }

  public boolean includeLevel(String queryName, String dimensionName, String uniqueHierarchyName,
                              String uniqueLevelName, String totalsFunction) {
    IQuery query = getIQuery(queryName);
    removeAllChildren(queryName, dimensionName);

    QueryDimension dimension = query.getDimension(dimensionName);
    for (Hierarchy hierarchy : dimension.getDimension().getHierarchies()) {
      if (hierarchy.getUniqueName().equals(uniqueHierarchyName)) {
        for (Level level : hierarchy.getLevels()) {
          if (level.getUniqueName().equals(uniqueLevelName)) {
            Selection sel = dimension.createSelection(level);
            if (!dimension.getInclusions().contains(sel)) {
              dimension.include(level);
            }
            query.setTotalFunction(uniqueLevelName, totalsFunction);
            return true;
          }
        }
      }
    }
View Full Code Here
832
833
834
835
836
837
838
839
840
841
842
843
844
    return false;
  }

  public boolean removeLevel(String queryName, String dimensionName, String uniqueHierarchyName,
                             String uniqueLevelName) {
    IQuery query = getIQuery(queryName);
    removeAllChildren(queryName, dimensionName);
    QueryDimension dimension = query.getDimension(dimensionName);
    try {
      for (Hierarchy hierarchy : dimension.getDimension().getHierarchies()) {
        if (hierarchy.getUniqueName().equals(uniqueHierarchyName)) {
          for (Level level : hierarchy.getLevels()) {
            if (level.getUniqueName().equals(uniqueLevelName)) {
View Full Code Here
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
    try {
      if (LOG.isDebugEnabled()) {
        LOG.debug("move query: " + queryName + " dimension " + dimensionName + " to axis " + axisName + "  position"
                  + position);
      }
      IQuery query = getIQuery(queryName);
      QueryDimension dimension = query.getDimension(dimensionName);
      Axis newAxis = axisName != null ? "UNUSED".equals(axisName) ? null : Axis.Standard.valueOf(axisName) : null;
      if (position == -1) {
        query.moveDimension(dimension, newAxis);
      } else {
        query.moveDimension(dimension, newAxis, position);
      }
    } catch (Exception e) {
      throw new SaikuServiceException("Cannot move dimension:" + dimensionName + " to axis: " + axisName, e);
    }
  }
View Full Code Here
884
885
886
887
888
889
890
891
892
893
      throw new SaikuServiceException("Cannot move dimension:" + dimensionName + " to axis: " + axisName, e);
    }
  }

  public void removeDimension(String queryName, String axisName, String dimensionName) {
    IQuery query = getIQuery(queryName);
    moveDimension(queryName, "UNUSED", dimensionName, -1);
    query.getDimension(dimensionName).getExclusions().clear();
    query.getDimension(dimensionName).getInclusions().clear();
  }
View Full Code Here
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
    query.getDimension(dimensionName).getInclusions().clear();
  }

  @NotNull
  public List<SaikuDimensionSelection> getAxisSelection(String queryName, String axis) {
    IQuery query = getIQuery(queryName);

    List<SaikuDimensionSelection> dimsel = new ArrayList<SaikuDimensionSelection>();
    try {
      QueryAxis qaxis = query.getAxis(axis);
      if (qaxis != null) {
        for (QueryDimension dim : qaxis.getDimensions()) {
          dimsel.add(ObjectUtil.convertDimensionSelection(dim, query));
        }
      }
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.