Test case for a very experimental expression language support planned for Pivot4J 0.7 release. The purpose of the feature is to provide non-vendor specific alternative to Mondrian's Parameter() and ParamRef() pseudo-functions. The "fm:" prefix means it uses FreeMarker template engine for EL translation. The expression parameters is preserved whe…

gistfile1.java

/*
 * ====================================================================
 * This software is subject to the terms of the Common Public License
 * Agreement, available at the following URL:
 *   http://www.opensource.org/licenses/cpl.html .
 * You must accept the terms of that agreement to use this software.
 * ====================================================================
 */
package com.eyeq.pivot4j.el;

import static org.junit.Assert.assertEquals;

import java.util.List;

import org.junit.Test;
import org.olap4j.Axis;
import org.olap4j.CellSet;
import org.olap4j.OlapException;
import org.olap4j.Position;
import org.olap4j.metadata.Hierarchy;
import org.olap4j.metadata.Member;

import com.eyeq.pivot4j.AbstractIntegrationTestCase;
import com.eyeq.pivot4j.PivotModel;
import com.eyeq.pivot4j.transform.ChangeSlicer;
import com.eyeq.pivot4j.transform.DrillExpandMember;
import com.eyeq.pivot4j.transform.PlaceHierarchiesOnAxes;
import com.eyeq.pivot4j.util.MemberUtils;

public class ExpressionEvaluatorIT extends AbstractIntegrationTestCase {

	@Test
	public void testSimpleExpression() {
		String query = "SELECT {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} ON COLUMNS, "
				+ "{([Promotion Media].[All Media], "
				+ "[Product].[All Products])} ON ROWS FROM [Sales] WHERE $[s:year]";

		PivotModel model = getPivotModel();

		model.setMdx(query);
		model.initialize();

		model.getExpressionContext().put("year", "[Time].[1997]");

		ChangeSlicer transform = model.getTransform(ChangeSlicer.class);

		List<Member> members = transform.getSlicer();

		assertEquals("Slicer axis should contain one member.", 1,
				members.size());
		assertEquals("Wrong member was found on the slicer axis.",
				"[Time].[1997]", members.get(0).getUniqueName());
	}

	@Test
	public void testFreeMarkerExpression() {
		String query = "SELECT {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} ON COLUMNS, "
				+ "{([Promotion Media].[All Media], "
				+ "$[fm:${cube.dimensions.get(\"Product\").defaultHierarchy.defaultMember.uniqueName}]"
				+ ")} ON ROWS FROM [Sales] WHERE [Time].[1997]";

		PivotModel model = getPivotModel();

		model.setMdx(query);
		model.initialize();

		CellSet cellSet = model.getCellSet();

		List<Position> positions = cellSet.getAxes()
				.get(Axis.ROWS.axisOrdinal()).getPositions();
		assertEquals("Row axis should contain one positions.", 1,
				positions.size());

		Position position = positions.get(0);

		assertEquals("Row axis should contain two dimensions.", 2, position
				.getMembers().size());
		assertEquals("Wrong member was found on the row axis.",
				"[Product].[All Products]", position.getMembers().get(1)
						.getUniqueName());
	}

	@Test
	public void testPreserveParameterOnSlicerAfterDrillDown() {
		String query = "SELECT {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} ON COLUMNS, "
				+ "{([Promotion Media].[All Media], "
				+ "[Product].[All Products])} ON ROWS FROM [Sales] WHERE $[s:year]";

		PivotModel model = getPivotModel();

		model.setMdx(query);
		model.initialize();

		model.getExpressionContext().put("year", "[Time].[1997]");

		ChangeSlicer slicerTransform = model.getTransform(ChangeSlicer.class);

		List<Member> members = slicerTransform.getSlicer();

		assertEquals("Slicer axis should contain one member.", 1,
				members.size());

		assertEquals("Wrong member was found on the slicer axis.",
				"[Time].[1997]", members.get(0).getUniqueName());

		Member member = MemberUtils.lookupMember(model.getCube(),
				"[Product].[All Products]");

		DrillExpandMember drillTransform = model
				.getTransform(DrillExpandMember.class);
		drillTransform.expand(member);

		model.getExpressionContext().put("year", "[Time].[1998]");
		model.getCellSet();

		members = slicerTransform.getSlicer();
		assertEquals("Wrong member was found on the slicer axis.",
				"[Time].[1998]", members.get(0).getUniqueName());
	}

	@Test
	public void testPreserveParameterOnSlicerAfterAddingHierarchy() {
		String query = "SELECT {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} ON COLUMNS, "
				+ "[Promotion Media].[All Media] ON ROWS FROM [Sales] WHERE $[s:year]";

		PivotModel model = getPivotModel();

		model.setMdx(query);
		model.initialize();

		model.getExpressionContext().put("year", "[Time].[1997]");

		ChangeSlicer slicerTransform = model.getTransform(ChangeSlicer.class);

		List<Member> members = slicerTransform.getSlicer();

		assertEquals("Slicer axis should contain one member.", 1,
				members.size());

		assertEquals("Wrong member was found on the slicer axis.",
				"[Time].[1997]", members.get(0).getUniqueName());

		PlaceHierarchiesOnAxes hierarchyTransform = model
				.getTransform(PlaceHierarchiesOnAxes.class);

		Hierarchy hierarchy = model.getCube().getHierarchies().get("Product");

		hierarchyTransform.addHierarchy(Axis.ROWS, hierarchy, true, -1);

		model.getExpressionContext().put("year", "[Time].[1998]");
		model.getCellSet();

		members = slicerTransform.getSlicer();
		assertEquals("Wrong member was found on the slicer axis.",
				"[Time].[1998]", members.get(0).getUniqueName());
	}

	@Test
	public void testSimpleValueExpression() throws OlapException {
		String query = "WITH MEMBER [Measures].[Calc Cost] AS '[Measures].[Store Cost] * ${s:ratio}' "
				+ "SELECT {[Measures].[Calc Cost], [Measures].[Store Sales]} ON COLUMNS, "
				+ "{([Promotion Media].[All Media], [Product].[All Products])} ON ROWS FROM [Sales]";

		PivotModel model = getPivotModel();

		model.setMdx(query);
		model.initialize();

		model.getExpressionContext().put("ratio", "1.5");

		CellSet cellSet = model.getCellSet();
		assertEquals("Wrong cell value returned(ratio = 1.5).", "338,440.85",
				cellSet.getCell(0).getFormattedValue());

		model.getExpressionContext().put("ratio", "2.5");
		model.refresh();

		cellSet = model.getCellSet();

		assertEquals("Wrong cell value returned(ratio = 2.5).", "564,068.08",
				cellSet.getCell(0).getFormattedValue());
	}
}