Search in sources :

Example 61 with Result

use of mondrian.olap.Result in project pentaho-platform by pentaho.

the class MDXMetaDataTest method testMetadataExtendedColumnNames.

@Test
@SuppressWarnings({ "rawtypes", "unchecked" })
public void testMetadataExtendedColumnNames() {
    List positions = mockPositions(COLUMN_SIZE, ROW_SIZE);
    Axis axColumn = mockAxis(positions);
    Axis axRow = mockAxis(positions);
    Axis[] axes = new Axis[] { axColumn, axRow };
    Result nativeResultSet = mock(Result.class);
    when(nativeResultSet.getAxes()).thenReturn(axes);
    MDXMetaData metadata = new MDXMetaData(nativeResultSet, true);
    checkColumnHeaders(positions, metadata.getColumnHeaders());
    checkRowHeaders(positions, metadata.getRowHeaders());
    checkRowHeaderNames(positions, metadata.getRowHeaderNames());
}
Also used : ArrayList(java.util.ArrayList) List(java.util.List) Axis(mondrian.olap.Axis) Result(mondrian.olap.Result) Test(org.junit.Test)

Example 62 with Result

use of mondrian.olap.Result in project pentaho-platform by pentaho.

the class MDXMetaDataTest method testMetadataFromEmptyAxis.

@Test
public void testMetadataFromEmptyAxis() {
    Result nativeResultSet = mock(Result.class);
    when(nativeResultSet.getAxes()).thenReturn(new Axis[0]);
    MDXMetaData metadata = new MDXMetaData(nativeResultSet);
    checkEmptyResult(metadata);
}
Also used : Result(mondrian.olap.Result) Test(org.junit.Test)

Example 63 with Result

use of mondrian.olap.Result in project pentaho-platform by pentaho.

the class MDXMetaDataTest method testMetadataWithoutExtendedColumnNames.

@Test
@SuppressWarnings({ "rawtypes", "unchecked" })
public void testMetadataWithoutExtendedColumnNames() {
    List positions = mockPositions(COLUMN_SIZE, ROW_SIZE);
    Axis axColumn = mockAxis(positions);
    Axis axRow = mockAxis(positions);
    Axis[] axes = new Axis[] { axColumn, axRow };
    Result nativeResultSet = mock(Result.class);
    when(nativeResultSet.getAxes()).thenReturn(axes);
    MDXMetaData metadata = new MDXMetaData(nativeResultSet);
    Object[][] columnHeaders = metadata.getColumnHeaders();
    checkExtendedColumnHeaders(positions, columnHeaders);
    checkExtendedRowHeaders(positions, metadata.getRowHeaders());
    checkExtendedRowHeaderNames(positions, metadata.getRowHeaderNames());
}
Also used : ArrayList(java.util.ArrayList) List(java.util.List) Axis(mondrian.olap.Axis) Result(mondrian.olap.Result) Test(org.junit.Test)

Example 64 with Result

use of mondrian.olap.Result in project pentaho-platform by pentaho.

the class MDXMetaDataTest method testMetadataForNullPositions.

@Test
public void testMetadataForNullPositions() {
    Axis axColumn = mockAxis(null);
    Axis axRow = mockAxis(null);
    Axis[] axes = new Axis[] { axColumn, axRow };
    Result nativeResultSet = mock(Result.class);
    when(nativeResultSet.getAxes()).thenReturn(axes);
    MDXMetaData metadata = new MDXMetaData(nativeResultSet);
    checkEmptyResult(metadata);
}
Also used : Axis(mondrian.olap.Axis) Result(mondrian.olap.Result) Test(org.junit.Test)

Example 65 with Result

use of mondrian.olap.Result in project mondrian by pentaho.

the class FunctionTest method checkRankHuge.

private void checkRankHuge(String query, boolean rank3) {
    final Result result = getTestContext().executeQuery(query);
    final Axis[] axes = result.getAxes();
    final Axis rowsAxis = axes[1];
    final int rowCount = rowsAxis.getPositions().size();
    assertEquals(2256, rowCount);
    // [All Products], [All Gender], [Rank]
    Cell cell = result.getCell(new int[] { 1, 0 });
    assertEquals("1", cell.getFormattedValue());
    // [Robust Monthly Sports Magazine]
    Member member = rowsAxis.getPositions().get(rowCount - 1).get(0);
    assertEquals("Robust Monthly Sports Magazine", member.getName());
    // [Robust Monthly Sports Magazine], [All Gender], [Rank]
    cell = result.getCell(new int[] { 0, rowCount - 1 });
    assertEquals("152", cell.getFormattedValue());
    cell = result.getCell(new int[] { 1, rowCount - 1 });
    assertEquals(rank3 ? "1,854" : "1,871", cell.getFormattedValue());
    // [Robust Monthly Sports Magazine], [Gender].[F], [Rank]
    cell = result.getCell(new int[] { 2, rowCount - 1 });
    assertEquals("90", cell.getFormattedValue());
    cell = result.getCell(new int[] { 3, rowCount - 1 });
    assertEquals(rank3 ? "1,119" : "1,150", cell.getFormattedValue());
    // [Robust Monthly Sports Magazine], [Gender].[M], [Rank]
    cell = result.getCell(new int[] { 4, rowCount - 1 });
    assertEquals("62", cell.getFormattedValue());
    cell = result.getCell(new int[] { 5, rowCount - 1 });
    assertEquals(rank3 ? "2,131" : "2,147", cell.getFormattedValue());
}
Also used : Cell(mondrian.olap.Cell) Member(mondrian.olap.Member) Axis(mondrian.olap.Axis) Result(mondrian.olap.Result)

Aggregations

Result (mondrian.olap.Result)113 Axis (mondrian.olap.Axis)24 Member (mondrian.olap.Member)10 Test (org.junit.Test)10 Cell (mondrian.olap.Cell)9 Connection (mondrian.olap.Connection)9 Query (mondrian.olap.Query)9 Position (mondrian.olap.Position)8 TestContext (mondrian.test.TestContext)7 ArrayList (java.util.ArrayList)5 MondrianProperties (mondrian.olap.MondrianProperties)5 OlapElement (mondrian.olap.OlapElement)5 RolapCell (mondrian.rolap.RolapCell)5 NonEmptyResult (mondrian.rolap.RolapConnection.NonEmptyResult)5 Execution (mondrian.server.Execution)5 Dialect (mondrian.spi.Dialect)5 OlapConnection (org.olap4j.OlapConnection)5 List (java.util.List)4 ResultBase (mondrian.olap.ResultBase)4 Evaluator (mondrian.olap.Evaluator)3