private void insertLevelHandle(LevelHandle levelHandle, int pos) throws SemanticException {
CrosstabReportItemHandle reportHandle = viewHandle.getCrosstab();
// int viewCount = viewHandle.getLevelCount( );
DataItemHandle dataHandle =
CrosstabAdaptUtil.createColumnBindingAndDataItem(
(ExtendedItemHandle) reportHandle.getModelHandle(), levelHandle);
LevelViewHandle levelViewHandle = viewHandle.insertLevel(levelHandle, pos);
CrosstabCellHandle cellHandle = levelViewHandle.getCell();
cellHandle.addContent(dataHandle);
ActionHandle actionHandle = levelHandle.getActionHandle();
if (actionHandle != null) {
List source = new ArrayList();
source.add(actionHandle.getStructure());
List newAction = ModelUtil.cloneStructList(source);
dataHandle.setAction((Action) newAction.get(0));
}
CrosstabUtil.addLabelToHeader(levelViewHandle);
}
protected List getChildrenList(Object parent) {
if (parent instanceof TabularDimensionHandle) {
List children = new ArrayList();
try {
TabularDimensionHandle handle = (TabularDimensionHandle) parent;
CrosstabReportItemHandle xtabHandle = getCrosstabReportItemHandle();
for (int i = 0; i < xtabHandle.getDimensionCount(ICrosstabConstants.ROW_AXIS_TYPE); i++) {
DimensionViewHandle dimensionHandle =
xtabHandle.getDimension(ICrosstabConstants.ROW_AXIS_TYPE, i);
if (dimensionHandle.getCubeDimension().equals(handle))
children.add(dimensionHandle.getLevel(0).getCubeLevel());
}
for (int i = 0;
i < xtabHandle.getDimensionCount(ICrosstabConstants.COLUMN_AXIS_TYPE);
i++) {
DimensionViewHandle dimensionHandle =
xtabHandle.getDimension(ICrosstabConstants.COLUMN_AXIS_TYPE, i);
if (dimensionHandle.getCubeDimension().equals(handle))
children.add(dimensionHandle.getLevel(0).getCubeLevel());
}
} catch (ExtendedElementException e) {
}
return children;
} else if (parent instanceof LevelHandle) {
List children = new ArrayList();
LevelHandle levelHandle = (LevelHandle) parent;
try {
CrosstabReportItemHandle xtabHandle = getCrosstabReportItemHandle();
for (int i = 0; i < xtabHandle.getDimensionCount(ICrosstabConstants.ROW_AXIS_TYPE); i++) {
DimensionViewHandle dimensionHandle =
xtabHandle.getDimension(ICrosstabConstants.ROW_AXIS_TYPE, i);
LevelViewHandle levelViewHandle =
dimensionHandle.getLevel(levelHandle.getQualifiedName());
if (levelViewHandle != null)
if (dimensionHandle.getLevelCount() > levelViewHandle.getIndex() + 1)
children.add(dimensionHandle.getLevel(levelViewHandle.getIndex() + 1).getCubeLevel());
}
for (int i = 0;
i < xtabHandle.getDimensionCount(ICrosstabConstants.COLUMN_AXIS_TYPE);
i++) {
DimensionViewHandle dimensionHandle =
xtabHandle.getDimension(ICrosstabConstants.COLUMN_AXIS_TYPE, i);
LevelViewHandle levelViewHandle =
dimensionHandle.getLevel(levelHandle.getQualifiedName());
if (levelViewHandle != null)
if (dimensionHandle.getLevelCount() > levelViewHandle.getIndex() + 1)
children.add(dimensionHandle.getLevel(levelViewHandle.getIndex() + 1).getCubeLevel());
}
} catch (ExtendedElementException e) {
}
return children;
}
return super.getChildrenList(parent);
}
/*
* (non-Javadoc)
*
* @see org.eclipse.jface.action.Action#run()
*/
public void run() {
transStar(NAME);
try {
LevelViewDialog dialog = new LevelViewDialog(true);
List showLevels = new ArrayList();
List nullLevelHandle = new ArrayList();
int viewCount = viewHandle.getLevelCount();
for (int i = 0; i < viewCount; i++) {
LevelViewHandle levelHandle = viewHandle.getLevel(i);
if (levelHandle.getCubeLevel() == null) {
nullLevelHandle.add(Integer.valueOf(levelHandle.getIndex()));
} else {
showLevels.add(levelHandle.getCubeLevel());
}
}
ExtendedItemHandle extendedHandle = CrosstabAdaptUtil.getExtendedItemHandle(getHandle());
LevelViewHandle levelViewHandle = CrosstabAdaptUtil.getLevelViewHandle(extendedHandle);
dialog.setInput(findDimension(levelViewHandle.getCubeLevel()), showLevels);
if (dialog.open() == Window.OK) {
CrosstabReportItemHandle reportHandle = viewHandle.getCrosstab();
List result = (List) dialog.getResult();
boolean isLevelRemoved = processor(showLevels, result, nullLevelHandle, false);
if (isLevelRemoved) {
boolean bool = CrosstabAdaptUtil.needRemoveInvaildBindings(reportHandle);
processor(showLevels, result, nullLevelHandle, true);
if (bool) {
CrosstabAdaptUtil.removeInvalidBindings(reportHandle);
}
} else {
processor(showLevels, result, nullLevelHandle, true);
}
AggregationCellProviderWrapper providerWrapper =
new AggregationCellProviderWrapper(reportHandle);
providerWrapper.updateAllAggregationCells(AggregationCellViewAdapter.SWITCH_VIEW_TYPE);
}
} catch (SemanticException e) {
rollBack();
ExceptionUtil.handle(e);
return;
}
transEnd();
}
private void advance() throws OLAPException {
switch (currentState) {
case STATE_INIT:
case STATE_ROW_EDGE:
if (rowGroups.size() > 0) {
// TODO how to skip dummy groups?
// process row dimension header column if available
for (int i = groupIndex; i < rowGroups.size(); i++) {
EdgeGroup group = (EdgeGroup) rowGroups.get(i);
groupIndex++;
dimensionIndex = group.dimensionIndex;
levelIndex = group.levelIndex;
currentState = STATE_ROW_EDGE;
return;
}
}
// process vertical measure header column if available
if (mCount > 0 && isVerticalMeasure && !isHideMeasureHeader) {
for (int i = 0; i < mCount; i++) {
MeasureViewHandle mv = crosstabItem.getMeasure(i);
if (mv.getHeader() != null) {
currentState = STATE_MEASURE_HEADER;
return;
}
}
} else if (rowGroups.size() == 0 && groupIndex == 0 && crosstabItem.getHeader() != null) {
// mark the flag as we only check once.
groupIndex++;
boolean hasHeaderContent = false;
for (int i = 0; i < crosstabItem.getHeaderCount(); i++) {
CrosstabCellHandle cell = crosstabItem.getHeader(i);
if (cell.getContents().size() > 0) {
hasHeaderContent = true;
break;
}
}
if (hasHeaderContent) {
// in case it has no row edge but has non-empty header
// cell, we produce a dummy row edge event to output the
// crosstab header.
dimensionIndex = -1;
levelIndex = -1;
currentState = STATE_ROW_EDGE;
return;
}
}
case STATE_MEASURE_HEADER:
// check if need processing grandtotal_before
inProcessingGrandTotalBefore =
columnGroups.size() > 0
&& columnEdgeCursor != null
&& crosstabItem.getGrandTotal(COLUMN_AXIS_TYPE) != null
&& GRAND_TOTAL_LOCATION_BEFORE.equals(
crosstabItem.getCrosstabView(COLUMN_AXIS_TYPE).getGrandTotalLocation());
case STATE_PENDING_CHECK_COLUMN_EDGE:
if (!inProcessingGrandTotalBefore && columnGroups.size() > 0 && columnEdgeCursor != null) {
columnDimensionCursors = columnEdgeCursor.getDimensionCursor();
columnEdgeCursor.beforeFirst();
hasNext = columnEdgeCursor.next();
columnProcessed = false;
groupIndex = 0;
measureIndex = -1;
tmpStartGroupIndex = 0;
tmpEndGroupIndex = lastColumnGroupIndex;
}
case STATE_COLUMN_TOTAL_BEFORE:
case STATE_COLUMN_TOTAL_AFTER:
case STATE_COLUMN_EDGE:
if (!inProcessingGrandTotalBefore && columnGroups.size() > 0 && columnEdgeCursor != null) {
while (hasNext) {
if (mCount > 0 || !IGNORE_TOTAL_COLUMN_WITHOUT_MEASURE) {
// check header
for (int i = tmpStartGroupIndex; i < columnGroups.size(); i++) {
EdgeGroup group = (EdgeGroup) columnGroups.get(i);
if (!GroupUtil.isLeafOrDummyGroup(columnDimensionCursors, i)) {
DimensionCursor dc = (DimensionCursor) columnDimensionCursors.get(i);
if (dc.getEdgeStart() == columnEdgeCursor.getPosition()) {
// process leading subtoal column if
// available
LevelViewHandle lv =
crosstabItem
.getDimension(COLUMN_AXIS_TYPE, group.dimensionIndex)
.getLevel(group.levelIndex);
if (lv.getAggregationHeader() != null
&& AGGREGATION_HEADER_LOCATION_BEFORE.equals(
lv.getAggregationHeaderLocation())) {
if (mCount > 0 && !isVerticalMeasure) {
for (int m = measureIndex + 1; m < mCount; m++) {
if (GroupUtil.hasTotalContent(
crosstabItem,
COLUMN_AXIS_TYPE,
group.dimensionIndex,
group.levelIndex,
m)) {
tmpStartGroupIndex = i;
dimensionIndex = group.dimensionIndex;
levelIndex = group.levelIndex;
measureIndex = m;
currentState = STATE_COLUMN_TOTAL_BEFORE;
return;
}
}
// reset measure index
measureIndex = -1;
} else if (GroupUtil.hasTotalContent(
crosstabItem,
COLUMN_AXIS_TYPE,
group.dimensionIndex,
group.levelIndex,
-1)) {
tmpStartGroupIndex = i + 1;
dimensionIndex = group.dimensionIndex;
levelIndex = group.levelIndex;
currentState = STATE_COLUMN_TOTAL_BEFORE;
return;
}
}
}
}
}
// set to skip later header check
tmpStartGroupIndex = columnGroups.size();
}
// reset measure index
if (currentState != STATE_COLUMN_EDGE && currentState != STATE_COLUMN_TOTAL_AFTER) {
measureIndex = -1;
}
// check column
if (!columnProcessed) {
// add data columns per edge tuple
if (mCount > 0 && !isVerticalMeasure) {
for (int m = measureIndex + 1; m < mCount; m++) {
measureIndex = m;
currentState = STATE_COLUMN_EDGE;
return;
}
} else if (measureIndex == -1) {
measureIndex--;
currentState = STATE_COLUMN_EDGE;
return;
}
columnProcessed = true;
}
if (mCount > 0 || !IGNORE_TOTAL_COLUMN_WITHOUT_MEASURE) {
// reset measure index
if (currentState != STATE_COLUMN_TOTAL_AFTER) {
measureIndex = -1;
}
// check footer
for (int i = tmpEndGroupIndex; i >= 0; i--) {
EdgeGroup group = (EdgeGroup) columnGroups.get(i);
if (!GroupUtil.isLeafOrDummyGroup(columnDimensionCursors, i)) {
DimensionCursor dc = (DimensionCursor) columnDimensionCursors.get(i);
if (dc.getEdgeEnd() == columnEdgeCursor.getPosition()) {
// process trailing subtoal column
// if
// available
LevelViewHandle lv =
crosstabItem
.getDimension(COLUMN_AXIS_TYPE, group.dimensionIndex)
.getLevel(group.levelIndex);
if (lv.getAggregationHeader() != null
&& AGGREGATION_HEADER_LOCATION_AFTER.equals(
lv.getAggregationHeaderLocation())) {
if (mCount > 0 && !isVerticalMeasure) {
for (int m = measureIndex + 1; m < mCount; m++) {
if (GroupUtil.hasTotalContent(
crosstabItem,
COLUMN_AXIS_TYPE,
group.dimensionIndex,
group.levelIndex,
m)) {
tmpEndGroupIndex = i;
dimensionIndex = group.dimensionIndex;
levelIndex = group.levelIndex;
measureIndex = m;
currentState = STATE_COLUMN_TOTAL_AFTER;
return;
}
}
// reset measure index
measureIndex = -1;
} else if (GroupUtil.hasTotalContent(
crosstabItem,
COLUMN_AXIS_TYPE,
group.dimensionIndex,
group.levelIndex,
-1)) {
tmpEndGroupIndex = i - 1;
dimensionIndex = group.dimensionIndex;
levelIndex = group.levelIndex;
currentState = STATE_COLUMN_TOTAL_AFTER;
return;
}
}
}
}
}
}
hasNext = columnEdgeCursor.next();
// reset temp index
columnProcessed = false;
tmpStartGroupIndex = 0;
tmpEndGroupIndex = lastColumnGroupIndex;
measureIndex = -1;
}
// check if grandtotal already processed, otherwise, this is
// already the end of column edge
if (crosstabItem.getGrandTotal(COLUMN_AXIS_TYPE) != null
&& GRAND_TOTAL_LOCATION_BEFORE.equals(
crosstabItem.getCrosstabView(COLUMN_AXIS_TYPE).getGrandTotalLocation())) {
currentState = STATE_END;
return;
}
}
// reset measure index
measureIndex = -1;
case STATE_GRAND_TOTAL:
if (columnGroups.size() > 0 && columnEdgeCursor != null) {
// process grand total column
if (crosstabItem.getGrandTotal(COLUMN_AXIS_TYPE) != null) {
if (mCount > 0 || !IGNORE_TOTAL_COLUMN_WITHOUT_MEASURE) {
if (mCount > 0 && !isVerticalMeasure) {
for (int i = measureIndex + 1; i < mCount; i++) {
if (GroupUtil.hasTotalContent(crosstabItem, COLUMN_AXIS_TYPE, -1, -1, i)) {
measureIndex = i;
currentState = STATE_GRAND_TOTAL;
return;
}
}
} else if (currentState != STATE_GRAND_TOTAL) {
if (GroupUtil.hasTotalContent(crosstabItem, COLUMN_AXIS_TYPE, -1, -1, -1)) {
currentState = STATE_GRAND_TOTAL;
return;
}
}
}
// check if this is grandtotal_before, then forward the
// processing to column edge
if (inProcessingGrandTotalBefore) {
inProcessingGrandTotalBefore = false;
currentState = STATE_PENDING_CHECK_COLUMN_EDGE;
return;
}
}
currentState = STATE_END;
return;
}
case STATE_MEASURE:
// process measure columns in case no column edge defined
if (!isVerticalMeasure) {
for (int i = measureIndex + 1; i < mCount; i++) {
measureIndex = i;
currentState = STATE_MEASURE;
return;
}
} else if (measureIndex == -1 && mCount > 0) {
measureIndex--;
currentState = STATE_MEASURE;
return;
}
currentState = STATE_END;
return;
}
}
