Examples of org.olap4j.Position

org.olap4j.Position

Position on one of the {@link CellSetAxis} objects in a {@link CellSet}.

An axis has a particular dimensionality, that is, a set of one or more dimensions which will appear on that axis, and every position on that axis will have a member of each of those dimensions. For example, in the MDX query

SELECT {[Measures].[Unit Sales], [Measures].[Store Sales]} ON COLUMNS, CrossJoin( {[Gender].Members}, {[Product].[Food], [Product].[Drink]}) ON ROWS FROM [Sales]

the COLUMNS axis has dimensionality {[Measures]} and the ROWS axis has dimensionality {[Gender], [Product]}. In the result,

*Gender*	*Product*	Unit Sales	Store Sales
All Gender	Food	191,940	409,035.59
All Gender	Drink	24,597	48,836.21
F	Food	94,814	203,094.17
F	Drink	12,202	24,457.37
M	Food	97,126	205,941.42
M	Drink	12,395	24,378.84

each of the six positions on the ROWS axis has two members, consistent with its dimensionality of 2. The COLUMNS axis has two positions, each with one member.

@author jhyde @version $Id: Position.java 315 2010-05-29 00:56:11Z jhyde $ @since Aug 22, 2006

    final int rowCount = positions.size();
    final GenericObjectTable result = new GenericObjectTable(Math.max(1, rowCount), 5);


    for (int r = 0; r < rowCount; r++)
    {
      final Position position = positions.get(r);
      final List<Member> members = position.getMembers();
      Member member = null;
      final int colCount = members.size();
      for (int c = 0; c < colCount; c++)
      {
        member = members.get(c);

View Full Code Here

        yOffset + (rowsAxis == null ? 1 : rowsAxis.getPositions().size()));


    // Populate corner
    List<Level> levels = new ArrayList<Level>();
    if (rowsAxis != null && rowsAxis.getPositions().size() > 0) {
      Position p = rowsAxis.getPositions().get(0);
      for (int m = 0; m < p.getMembers().size(); m++) {
        AxisOrdinalInfo a = rowsAxisInfo.ordinalInfos.get(m);
        for (Integer depth : a.getDepths()) {
          levels.add(a.getLevel(depth));
        }
      }

View Full Code Here

    final MemberCell[] prevMemberInfo = new MemberCell[axisInfo.getWidth()];
    final Member[] members = new Member[axisInfo.getWidth()];


    for (int i = 0; i < axis.getPositions().size(); i++) {
      final int x = offset + i;
      final Position position = axis.getPositions().get(i);
      int yOffset = 0;
      final List<Member> memberList = position.getMembers();
      boolean stop = false;
      for (int j = 0; j < memberList.size(); j++) {
        Member member = memberList.get(j);
        final AxisOrdinalInfo ordinalInfo = axisInfo.ordinalInfos.get(j);
        List<Integer> depths = ordinalInfo.depths;

View Full Code Here

        yOffset + (rowsAxis == null ? 1 : rowsAxis.getPositions().size()));


    // Populate corner
    List<Level> levels = new ArrayList<Level>();
    if (rowsAxis != null && rowsAxis.getPositions().size() > 0) {
      Position p = rowsAxis.getPositions().get(0);
      for (int m = 0; m < p.getMembers().size(); m++) {
        AxisOrdinalInfo a = rowsAxisInfo.ordinalInfos.get(m);
        for (Integer depth : a.getDepths()) {
          levels.add(a.getLevel(depth));
        }
      }

View Full Code Here

    final MemberCell[] prevMemberInfo = new MemberCell[axisInfo.getWidth()];
    final Member[] members = new Member[axisInfo.getWidth()];


    for (int i = 0; i < axis.getPositions().size(); i++) {
      final int x = offset + i;
      final Position position = axis.getPositions().get(i);
      int yOffset = 0;
      final List<Member> memberList = position.getMembers();
      final Map<Hierarchy, List<Integer>> lvls = new HashMap<Hierarchy, List<Integer>>();
      for (int j = 0; j < memberList.size(); j++) {
        Member member = memberList.get(j);
        final AxisOrdinalInfo ordinalInfo = axisInfo.ordinalInfos.get(j);
        List<Integer> depths = ordinalInfo.depths;

View Full Code Here

        yOffset + (rowsAxis == null ? 1 : rowsAxis.getPositions().size()));


    // Populate corner
    List<Level> levels = new ArrayList<Level>();
    if (rowsAxis != null && rowsAxis.getPositions().size() > 0) {
      Position p = rowsAxis.getPositions().get(0);
      for (int m = 0; m < p.getMembers().size(); m++) {
        AxisOrdinalInfo a = rowsAxisInfo.ordinalInfos.get(m);
        for (Integer depth : a.getDepths()) {
          levels.add(a.getLevel(depth));
        }
      }

View Full Code Here

    final MemberCell[] prevMemberInfo = new MemberCell[axisInfo.getWidth()];
    final Member[] members = new Member[axisInfo.getWidth()];


    for (int i = 0; i < axis.getPositions().size(); i++) {
      final int x = offset + i;
      final Position position = axis.getPositions().get(i);
      int yOffset = 0;
      final List<Member> memberList = position.getMembers();
      final Map<Hierarchy, List<Integer>> lvls = new HashMap<Hierarchy, List<Integer>>();
      for (int j = 0; j < memberList.size(); j++) {
        Member member = memberList.get(j);
        final AxisOrdinalInfo ordinalInfo = axisInfo.ordinalInfos.get(j);
        List<Integer> depths = ordinalInfo.depths;

View Full Code Here

0 1 2

TOP

Related Classes of org.olap4j.Position

org.olap4j.transform.TransformUtil

org.pentaho.reporting.engine.classic.extensions.datasources.olap4j.AbstractMDXDataFactory

org.pentaho.reporting.engine.classic.extensions.datasources.olap4j.BandedMDXTableModel

org.pentaho.reporting.engine.classic.extensions.datasources.olap4j.DenormalizedMDXTableModel

org.pentaho.reporting.engine.classic.extensions.datasources.olap4j.LegacyBandedMDXTableModel

org.saiku.olap.util.formatter.CellSetFormatter

org.saiku.olap.util.formatter.FlattenedCellSetFormatter

org.saiku.olap.util.formatter.HierarchicalCellSetFormatter

org.teiid.translator.olap.OlapQueryExecution

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.