Oracle OLAP

OlapCriteria<String> oc = new OracleOlapCriteria("SALES");
oc.addCriteria("CHANNEL", new String[] { "PRIMARY::TOTAL_CHANNEL::1", "PRIMARY::CHANNEL::2"});
oc.addCriteria("CUSTOMER", new String[] { "SHIPMENTS::TOTAL_CUSTOMER::1", "SHIPMENTS::REGION::8"});
oc.addCriteria("TIME", new String[] { "CALENDAR_YEAR::QUARTER::10", "CALENDAR_YEAR::MONTH::34", "CALENDAR_YEAR::MONTH::35"});
oc.addCriteria("PRODUCT", new String[] { product });
oc.addOrder("CHANNEL").addOrder("CUSTOMER").addOrder("TIME");
OlapBean<String,Double> ob = (OlapBean<String,Double>)os.query(oc);

<!-- Dimensions
  0 - channel
  1 - cust
  2 - time
  3 - product
-->
#foreach($chan in $olap.getDim(0))
 chan: $chan.desc
 <table border="1">
   <tr>
    <td></td>
    #foreach ($time in $olap.getDim(2))
     <td>time: $time.desc </td>
    #end
   </tr>
   #foreach ($cust in $olap.getDim(1))
    <tr>
     <td>cust: $cust.desc </td>
     #foreach ($time in $olap.getDim(2))
      <td>
       #foreach ($prod in $olap.getDim(3))
       #set($key1 = [$chan.name, $cust.name, $time.name, $prod.name])
       $olap.getData($key1)
       #end
      </td>
     #end
    </tr>
   #end
 </table>
<br/>
#end

public abstract class OlapBean<K,T> {
 
	public OlapBean() {
		olapData = new HashMap<MultiDimensionalKey<K>, T>();
		dimensionData = new HashMap<MdmObject, List<OlapTableObject>>(); 
	}
 
	protected Map<MultiDimensionalKey<K>, T> olapData;
	protected List<MdmObject> dimension;
	protected Map<MdmObject, List<OlapTableObject>> dimensionData;
 
	public T getData(ArrayList<K> axis) {
		MultiDimensionalKey<K> key = new MultiDimensionalKey<K>(axis);	
		if (olapData.get(key) == null)
			return null;
		return olapData.get(key);
	}
 
	public void add(MultiDimensionalKey<K> k, T value) {
		olapData.put(k, value);
	}
	public List<OlapTableObject> getDim(Integer i) {
		if (i >= dimension.size() || dimensionData.get(dimension.get(i)) == null)
			return new ArrayList<OlapTableObject>();
		return dimensionData.get(dimension.get(i));
	}
	public void setDimensionMetadata(List<MdmObject> dim,  List<List<OlapTableObject> > data) {
		this.dimension = dim;
		for (int i = 0; i < dimension.size(); i++)
			dimensionData.put(dimension.get(i), data.get(i));
	}
}

public class MultiDimensionalKey<T> implements Comparator<MultiDimensionalKey<T>>, Comparable<MultiDimensionalKey<T> > {
	private List<T> keys = null;
	public MultiDimensionalKey(List<T> keys) {
		this.keys = keys;
	}
 
	@SuppressWarnings("unchecked")
	public boolean equals(Object obj) {
		MultiDimensionalKey<T> ol = (MultiDimensionalKey<T>)obj;
		if (keys.size() != ol.keys.size())
			return false;
		for (int i = 0; i < keys.size(); i++) 
			if (!keys.get(i).equals(ol.keys.get(i)))
				return false;
		return true;
	}
 
	public int compare(MultiDimensionalKey<T> o1,MultiDimensionalKey<T> o2) {
		MultiDimensionalKey<T> key1 = (MultiDimensionalKey<T>)o1;
		MultiDimensionalKey<T> key2 = (MultiDimensionalKey<T>)o2;
		if (key1.keys.size() != key2.keys.size())
			if (key1.keys.size() < key2.keys.size())
				return -1;
			else
				return 1;
		for (int i = 0; i < key1.keys.size(); i++)
			if (key1.keys.get(i).equals(key2.keys.get(i)))
				return 0;
		return -1;
	}
 
	public int compareTo(MultiDimensionalKey<T> k) {
		for (int i = 0; i < keys.size(); i++) 
			if (!keys.get(i).equals(k.keys.get(i)))
				return -1;
		return 0;
	}	
 
    public int hashCode() {
    	String s = new String();
    	for (int i = 0; i < keys.size(); i++) 
    		s+= keys.get(i);
    	return s.hashCode();
    }
}

	public OlapBean<String, ?> query(OlapCriteria<String> oc) {
		MdmMeasure m = cxt.getMdmMeasureByName(oc.measures.get(0));
		//Source sm = m.getSource();
		List<MdmDimension> dl = m.getDimensions();
		List<String> fullOrder = new ArrayList<String>();
		for  (String o : oc.getOrder()) {
			fullOrder.add(o);
		}
		for (MdmDimension d : dl) {
			if (!fullOrder.contains(d.getName()))
				fullOrder.add(d.getName());
		}
		List<MdmObject> dimension = new ArrayList<MdmObject>();
		List<Source> dimDataSourceList = new ArrayList<Source>();
		List<Source> ls = new ArrayList<Source>();
 		for (String name : fullOrder) {
			MdmPrimaryDimension mdmPd = cxt.getMdmPrimaryDimensionByName(name);
			MdmHierarchy mdmH =  mdmPd.getDefaultHierarchy();
			//MdmLevelHierarchy mdmLh = (MdmLevelHierarchy) mdmPd.getDefaultHierarchy();
			dimension.add(mdmPd);
			Source shortValueDesc = mdmPd.getShortValueDescriptionAttribute().getSource();
			//Source valueDesc = mdmPd.getValueDescriptionAttribute().getSource();
			List<String> selectCriteria = oc.getCriteria().get(name);
			Source s = null;
			if (selectCriteria != null && selectCriteria.size() > 0) {
				String[] stringCriteria = (String[])selectCriteria.toArray(new String[selectCriteria.size()]);
				s = ((StringSource)mdmH.getSource()).selectValues( stringCriteria );
			}
			else
				s = mdmPd.getSource();
			dimDataSourceList.add(shortValueDesc.join(s));
			ls.add(s);
 		}
 		//prepareAndCommit();
 		Source ms = m.getSource();
 		for (Source s : ls) {
 			ms = ms.join(s);
 		}
 		return createBean(ms, dimension, getDimensionDataElements(dimDataSourceList));
	}
 
	public OlapBean<String,?> createBean(Source s, List<MdmObject> dimension, List<List<OlapTableObject> > dimensionData) {
		prepareAndCommit();
		CursorManagerSpecification cursorMngrSpec = cxt.getDataProvider().createCursorManagerSpecification(s);
		SpecifiedCursorManager cursorMngr = cxt.getDataProvider().createCursorManager(cursorMngrSpec);
		CompoundCursor unitsForSelCursor = (CompoundCursor)cursorMngr.createCursor();
	    ValueCursor specifiedUnitsVals = unitsForSelCursor.getValueCursor();
	    List<ValueCursor> outputs = unitsForSelCursor.getOutputs();
	    int size = outputs.size();
 
	    OlapBean<String,Object> bean = new OracleOlapBean<Object>();
	    do {
	        List<String> keys = new ArrayList<String>();
	        for (int j = size-1; j >= 0; j--) 
	        	keys.add( outputs.get(j).getCurrentString() );
	        MultiDimensionalKey<String> key = new MultiDimensionalKey<String>(keys);
	        bean.add(key, specifiedUnitsVals.getCurrentValue());
	    } while(unitsForSelCursor.next());
	    cursorMngr.close();
	    bean.setDimensionMetadata(dimension, dimensionData);
	    return bean;
	}