Skip to Content
0
Former Member
Aug 08, 2011 at 02:04 PM

Cannot Merge Dimensions Bex Query BO 4.0

37 Views

Hello

I have created a WEBI report based upon 2 BEx queries.The queries are based upon the same FIAR cube they are just reporting at different levels of data. The report

Query 1

Company

Debtor

Month/Year

Key Figure (Structure showing ageing of debts)

Query 2

Company

Debtor

Month/Year

Document

Key Figure

I am wanting to merge the Debtor dimension so I can navigate both queries via one field Debtors. The problem is that as soon as I try to Filter on the Merged Dimension I get the following error

Rebean Exception

com.businessobjects.rebean.wi.exception.DrillExceptions$InvalidDrillActionException: Unable to perfom drill action, wrong drill action command. (Error: RWI 00625)

at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:144)

at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:115)

at com.businessobjects.rebean.wi.impl.services.ReportEngineDrillServiceImpl.getDrillFilters(ReportEngineDrillServiceImpl.java:268)

at com.sap.webi.ui.drill.DrillBar.BuildDrillBar(DrillBar.java:303)

at com.sap.webi.ui.drill.DrillBar.UpdateComponents(DrillBar.java:468)

at com.sap.webi.ui.drill.DrillBar.executeDrop(DrillBar.java:517)

at com.sap.webi.ui.drill.DrillBar.acceptDrop(DrillBar.java:222)

at com.sap.webi.toolkit.ui.dnd.DNDManager.importData(DNDManager.java:545)

at javax.swing.TransferHandler$DropHandler.drop(Unknown Source)

at java.awt.dnd.DropTarget.drop(Unknown Source)

at javax.swing.TransferHandler$SwingDropTarget.drop(Unknown Source)

at sun.awt.dnd.SunDropTargetContextPeer.processDropMessage(Unknown Source)

at sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchDropEvent(Unknown Source)

at sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchEvent(Unknown Source)

at sun.awt.dnd.SunDropTargetEvent.dispatch(Unknown Source)

at java.awt.Component.dispatchEventImpl(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.processDropTargetEvent(Unknown Source)

at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.EventQueue.dispatchEvent(Unknown Source)

at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.run(Unknown Source)

The dimension debtor is showing as a Hierachy but only has 1 level.

Any ideas on how I could filter both queries based upon debtor without getting errors.

Thanks

Phillip