Package mondrian.olap

Examples of mondrian.olap.Axis

5229
5230
5231
5232
5233
5234
5235
5236
            + "      {[Store Type].[Store Type].members},\n"
            + "      {[Promotions].[Promotion Name].members})\n"
            + "   on rows\n"
            + "from Sales\n"
            + "where ([Customers].[All Customers].[USA].[WA].[Anacortes])\n");
        Axis a = result.getAxes()[1];
        assertEquals(1, a.getPositions().size());
    }
View Full Code Here
5243
5244
5245
5246
5247
5248
5249
5250
            + "      {[Store Type].[Store Type].members},\n"
            + "      {[Promotions].[Promotion Name].members})\n"
            + "   on rows\n"
            + "from Sales\n"
            + "where ([Customers].[All Customers].[USA].[WA].[Anacortes])\n");
        Axis a = result.getAxes()[1];
        assertEquals(1, a.getPositions().size());
    }
View Full Code Here
5264
5265
5266
5267
5268
5269
5270
5271
            + "select {[Measures].[Unit Sales], [Measures].[Store Cost],\n"
            + "[Measures].[Store Sales]} ON columns,\n"
            + "Hierarchize(Union(Union({[Time].[1997], [Time].[1998],\n"
            + "[Time].[1997].[Q1].[xxx]}, [Time].[1997].Children),\n"
            + "[Time].[1997].[Q1].Children)) ON rows from [Sales]");
        Axis a = result.getAxes()[1];
        assertEquals(10, a.getPositions().size());
    }
View Full Code Here
5322
5323
5324
5325
5326
5327
5328
5329
5330
5331
5332
5333
5334
5335
5336
        // Store". Attach it to the "unit_sales" column (which has values [1,
        // 6] whereas store has values [1, 24].
        TestContext testContext = TestContext.instance().createSubstitutingCube(
            "Sales",
            "<DimensionUsage name=\"Other Store\" source=\"Store\" foreignKey=\"unit_sales\" />");
        Axis axis = testContext.executeAxis("[Other Store].members");
        assertEquals(63, axis.getPositions().size());

        axis = testContext.executeAxis("[Store].members");
        assertEquals(63, axis.getPositions().size());

        final String q1 =
            "select {[Measures].[Unit Sales]} on columns,\n"
            + " NON EMPTY {[Other Store].members} on rows\n"
            + "from [Sales]";
View Full Code Here
5503
5504
5505
5506
5507
5508
5509
5510
5511
5512
5513
            + "    <Level name=\"Gender\" column=\"gender\" uniqueMembers=\"true\"/>\n"
            + "  </Hierarchy>\n"
            + "</Dimension>");
        String mdx = "select {[Gender3].[All Gender]} on columns from Sales";
        Result result = testContext.executeQuery(mdx);
        Axis axis0 = result.getAxes()[0];
        Position pos0 = axis0.getPositions().get(0);
        Member allGender = pos0.get(0);
        String caption = allGender.getCaption();
        Assert.assertEquals(caption, "Frauen und Maenner");
    }
View Full Code Here
5523
5524
5525
5526
5527
5528
5529
5530
5531
5532
5533
            + "    <Level name=\"Gender\" column=\"gender\" uniqueMembers=\"true\"/>\n"
            + "  </Hierarchy>\n"
            + "</Dimension>");
        String mdx = "select {[Gender4].[All Gender]} on columns from Sales";
        Result result = testContext.executeQuery(mdx);
        Axis axis0 = result.getAxes()[0];
        Position pos0 = axis0.getPositions().get(0);
        Member allGender = pos0.get(0);
        String caption = allGender.getLevel().getName();
        Assert.assertEquals(caption, "GenderLevel");
    }
View Full Code Here
TOP

Related Classes of mondrian.olap.Axis

  • mondrian.olap4j.MondrianOlap4jCellSet
  • mondrian.test.BasicQueryTest
  • mondrian.test.TestContext
  • mondrian.test.UdfTest
  • org.pentaho.platform.plugin.services.connections.mondrian.MDXMetaDataTest
  • org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXTableModel
  • org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DenormalizedMDXTableModel
  • org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.LegacyBandedMDXTableModel
  • org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.util.ResultSetProcessingLib
    • 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.