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