protected Document parseDocument(RequestContext context, String xmlUri)
throws MalformedURLException, MissingResourceException {
Locale loc = Resources.instance().getLocaleContextHolderLocale();
if (loc == null) {
loc = context.getLocale(); // Default: browser setting
}
URL url = ResourceLocator.getResource(context.getServletContext(), loc, xmlUri);
Document document = XmlUtils.parse(url);
// In replaceI18n(...) it is examined whether "bundle" - attribute available
I18nReplacer replacer = I18nReplacer.instance(Resources.instance(getClass()));
if (replacer != null) {
replacer.replaceAll(document);
} else {
FormDocument.replaceI18n(context, document, getBundle());
}
return document;
}
/**
* Misc helpers
*
* @author av
*/
public class OlapUtils {
static final Set infix = new HashSet();
static final Set prefix = new HashSet();
static {
String[] s =
new String[] {"and", "or", "xor", "*", "/", "+", "-", "%", "<", ">", "<=", ">=", "<>", "="};
for (int i = 0; i < s.length; i++) infix.add(s[i]);
prefix.add("-");
prefix.add("not");
};
static Resources resources = Resources.instance(OlapUtils.class);
static final Set singleRecordLevelNames = new HashSet();
static {
String s = resources.getString("single.record.level");
StringTokenizer st = new StringTokenizer(s);
while (st.hasMoreTokens()) singleRecordLevelNames.add(st.nextToken());
}
private OlapUtils() {}
/**
* returns a matrix[rows][columns] of cells
*
* @param result - a 0, 1, or 2 dimensional Result
* @return a matrix containing the result cells
* @see #getCellList
*/
public static Cell[][] getCellMatrix(Result result) {
int rows, cols;
switch (result.getAxes().length) {
case 0:
cols = 1;
rows = 1;
break;
case 1:
cols = result.getAxes()[0].getPositions().size();
rows = 1;
break;
case 2:
cols = result.getAxes()[0].getPositions().size();
rows = result.getAxes()[1].getPositions().size();
break;
default:
throw new IllegalArgumentException("result must be 0,1 or 2 dimensional");
}
Iterator it = result.getCells().iterator();
Cell[][] matrix = new Cell[rows][cols];
for (int row = 0; row < rows; row++)
for (int col = 0; col < cols; col++) matrix[row][col] = (Cell) it.next();
return matrix;
}
/**
* creates a list of cells out of a matrix
*
* @see #getCellMatrix
*/
public static List getCellList(Cell[][] matrix) {
if (matrix.length == 0) return Collections.EMPTY_LIST;
int rows = matrix.length;
int cols = matrix[0].length;
List list = new ArrayList(rows * cols);
for (int row = 0; row < rows; row++) {
for (int col = 0; col < cols; col++) {
list.add(matrix[row][col]);
}
}
return list;
}
public static Cell[][] transposeCellMatrix(Cell[][] oldCells) {
int rows = oldCells.length;
int cols = oldCells[0].length;
Cell[][] newCells = new Cell[cols][rows];
for (int row = 0; row < rows; row++) {
for (int col = 0; col < cols; col++) {
newCells[col][row] = oldCells[row][col];
}
}
return newCells;
}
/** returns the number of members on each position */
public static int countHierarchies(Axis axis) {
List positions = axis.getPositions();
if (positions.size() == 0) return 0;
return ((Position) positions.get(0)).getMembers().length;
}
public static Level getParentLevel(Level level) {
Hierarchy hier = level.getHierarchy();
Level[] levels = hier.getLevels();
for (int i = 1; i < levels.length; i++) if (level.equals(levels[i])) return levels[i - 1];
return null;
}
public static Level getChildLevel(Level level) {
Hierarchy hier = level.getHierarchy();
Level[] levels = hier.getLevels();
for (int i = 0; i < levels.length - 1; i++) if (level.equals(levels[i])) return levels[i + 1];
return null;
}
/**
* compare member array
*
* @param aMem1
* @param aMem2
* @return true if member arrays compare
*/
public static boolean compareMembers(Member[] aMem1, Member[] aMem2) {
if (aMem1.length != aMem2.length) return false;
for (int i = 0; i < aMem1.length; i++) {
// any null does not compare
if (aMem1[i] == null) return false;
if (!aMem1[i].equals(aMem2[i])) return false;
}
return true;
}
/** return the dimensions that are displayed on a visible axis */
public static Set getVisibleDimensions(OlapModel model) throws OlapException {
Set visible = new HashSet();
Axis[] axes = model.getResult().getAxes();
for (int i = 0; i < axes.length; i++) {
Hierarchy[] hiers = axes[i].getHierarchies();
for (int j = 0; j < hiers.length; j++) visible.add(hiers[j].getDimension());
}
return visible;
}
/** return the dimensions that are on the slicer axis (all that are not visible) */
public static Set getSlicerDimensions(OlapModel model) throws OlapException {
Set visible = getVisibleDimensions(model);
Set slicer = new HashSet();
Dimension[] dims = model.getDimensions();
for (int i = 0; i < dims.length; i++) {
if (!visible.contains(dims[i])) slicer.add(dims[i]);
}
return slicer;
}
/**
* check, whether a function name matches an infis function like "+" or "-"
*
* @param fuName
* @return
*/
public static boolean isInfixFunction(String fuName) {
return infix.contains(fuName);
}
/**
* check, whether a function name matches an prefix function like "not" or "unary -"
*
* @param fuName
* @return
*/
public static boolean isPrefixFunction(String fuName) {
return prefix.contains(fuName);
}
/**
* true if for every member of the lowest level of <code>hier</code> there is a corresponding row
* in the fact table. If so, the Hierarchy is handled differently in the GUI.
*/
public static boolean isSingleRecord(Hierarchy hier) {
Level lowest = getLowestLevel(hier);
return singleRecordLevelNames.contains(lowest.getLabel());
}
/**
* true if for every member of the lowest level of any hierarchy in <code>dim</code> there is a
* corresponding row in the fact table. If so, the Hierarchy is handled differently in the GUI.
*/
public static boolean isSingleRecord(Dimension dim) {
Hierarchy[] hiers = dim.getHierarchies();
for (int i = 0; i < hiers.length; i++) if (isSingleRecord(hiers[i])) return true;
return false;
}
public static Level getLowestLevel(Hierarchy hier) {
Level[] levels = hier.getLevels();
return levels[levels.length - 1];
}
/** Return a list of active dimensions on the slicer */
public static Set getActiveSlicerDimensions(OlapModel model) throws OlapException {
Set active = new HashSet();
Axis slicer = model.getResult().getSlicer();
Hierarchy[] hiers = slicer.getHierarchies();
for (int j = 0; j < hiers.length; j++) {
active.add(hiers[j].getDimension());
}
return active;
}
/** Return a list of active dimensions on the slicer */
public static Set getActiveSlicerHierarchies(OlapModel model) throws OlapException {
Set active = new HashSet();
Axis slicer = model.getResult().getSlicer();
Hierarchy[] hiers = slicer.getHierarchies();
for (int j = 0; j < hiers.length; j++) active.add(hiers[j]);
return active;
}
/** return the hierarchies that are on the slicer axis (all that are not visible) */
public static Set getSlicerHierarchies(OlapModel model) throws OlapException {
Set visible = getVisibleDimensions(model);
/* Get dimensions and hierarchies on the slicer */
Axis slicer = model.getResult().getSlicer();
Set selectedSlicerDims = new HashSet();
Set selectedSlicerHiers = new HashSet();
List positions = slicer.getPositions();
for (Iterator iter = positions.iterator(); iter.hasNext(); ) {
Position pos = (Position) iter.next();
Member[] posMembers = pos.getMembers();
for (int i = 0; i < posMembers.length; i++) {
Hierarchy hier = posMembers[i].getLevel().getHierarchy();
Dimension dim = hier.getDimension();
if (!selectedSlicerHiers.contains(hier)) selectedSlicerHiers.add(hier);
if (!selectedSlicerDims.contains(dim)) selectedSlicerDims.add(dim);
}
}
/* Return hierarchies that are not on the rows or columns and for the selected
* members, return the selected hierarchy
*/
Set slicerHiers = new HashSet();
Dimension[] dims = model.getDimensions();
for (int i = 0; i < dims.length; i++) {
if (!visible.contains(dims[i])) {
if (!selectedSlicerDims.contains(dims[i])) {
slicerHiers.add(dims[i].getHierarchies()[0]);
} else {
for (Iterator it = selectedSlicerHiers.iterator(); it.hasNext(); ) {
Hierarchy hier = (Hierarchy) it.next();
Dimension dim = hier.getDimension();
if (dim.equals(dims[i])) {
slicerHiers.add(hier);
break;
}
}
}
}
}
return slicerHiers;
}
}