Unable to create server cursor - BI Beans(Archived)

Hello all
I have a cube with 5 dimensions.
One dimension have about 12000 values and 2 levels. Top level include all dimension values.
I open query builder in crosstab, select top level of this dimension.
When i try open all values in "Selected:" window i get error:
oracle.express.ExpressServerExceptionError class: OLAPI
Server error descriptions:
DPR: Unable to create server cursor, Generic at TxsOqDefinitionManager::createCursorManager
OES: ORA-00920: invalid relational operator
, Generic at TxsRdbOCIConnection::execStmt
     oracle.express.olapi.data.full.ExpressSpecifiedCursorManager oracle.express.olapi.data.full.DefinitionManager.createCursorManager(oracle.olapi.data.source.CursorManagerSpecification)
     oracle.olapi.data.source.SpecifiedCursorManager oracle.express.olapi.data.full.ExpressDataProvider.createCursorManager(oracle.olapi.data.source.CursorManagerSpecification, oracle.olapi.data.source.Source[])
     oracle.olapi.data.source.SpecifiedCursorManager oracle.olapi.data.source.DataProvider.createCursorManager(oracle.olapi.data.source.CursorManagerSpecification)
     oracle.express.olapi.data.full.ExpressSpecifiedCursorManager[] oracle.dss.dataSource.QueryUtilities.setUpCursors(oracle.dss.dataSource.SourceTemplate[], oracle.dss.dataSource.common.CubeCursor[], oracle.olapi.data.source.Source[], oracle.express.olapi.data.full.ExpressSpecifiedCursorManager[], boolean, boolean, boolean, boolean)
     oracle.express.olapi.data.full.ExpressSpecifiedCursorManager[] oracle.dss.dataSource.QueryServer._setUpCursorsForMainQuery(oracle.dss.dataSource.SourceTemplate[], oracle.dss.dataSource.common.CubeCursor[], boolean, boolean, boolean, boolean)
     void oracle.dss.dataSource.QueryServer._getCursorForCube(oracle.dss.dataSource.common.DimTree, boolean, boolean, boolean, boolean, boolean)
     void oracle.dss.dataSource.QueryServer._createCubeAndCursor(boolean, boolean, boolean)
     void oracle.dss.dataSource.QueryServer._createCommonQuery(java.lang.String[][], java.lang.String[], oracle.dss.util.Operation, oracle.dss.dataSource.common.QueryState)
     void oracle.dss.dataSource.QueryServer._initQuery(java.lang.String[][], java.lang.String[], oracle.dss.util.Operation, oracle.dss.dataSource.common.QueryState)
     java.lang.Object java.lang.reflect.Method.invoke(java.lang.Object, java.lang.Object[])
     java.lang.Object oracle.dss.util.Operation.execute(java.lang.Object)
     java.lang.Object oracle.dss.dataSource.OperationQueue.update()
     java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOperation(oracle.dss.util.Operation, int)
     java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOperation(oracle.dss.util.Operation)
     java.lang.Object oracle.dss.dataSource.QueryServer.queueOperation(java.lang.String, oracle.dss.util.Parameter[], boolean, oracle.dss.dataSource.common.QueryEvent, java.lang.String, oracle.dss.util.Parameter[], oracle.dss.dataSource.common.QueryState)
     void oracle.dss.dataSource.QueryServer.initQuery(java.lang.String[][], java.lang.String[])
     java.lang.Object java.lang.reflect.Method.invoke(java.lang.Object, java.lang.Object[])
     java.lang.Object oracle.dss.util.Operation.execute(java.lang.Object)
     java.lang.Object oracle.dss.dataSource.QueryManagerServer.sendQueue(oracle.dss.dataSource.common.BaseOperationQueue)
     java.lang.Object oracle.dss.dataSource.common.OperationQueue.update()
     java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOperation(oracle.dss.util.Operation, int)
     java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOperation(oracle.dss.util.Operation)
     void oracle.dss.dataSource.client.QueryClient.initQuery(java.lang.String[][], java.lang.String[])
     oracle.dss.dataSource.common.QueryUtil$DAQuery oracle.dss.dataSource.common.QueryUtil._getDataForSelection(oracle.dss.dataSource.common.QueryManager, oracle.dss.selection.Selection, oracle.dss.util.MetadataMap)
     oracle.dss.dataSource.common.QueryUtil$DAQuery oracle.dss.dataSource.common.QueryQueryAccess._getDataForSelection(oracle.dss.selection.Selection, oracle.dss.util.MetadataMap)
     oracle.dss.util.DataAccess oracle.dss.dataSource.common.QueryQueryAccess.getDataAccess(oracle.dss.selection.Selection, oracle.dss.util.MetadataMap)
     oracle.dss.util.DataAccess oracle.dss.dataSource.common.QueryQueryAccess.getDataAccess(oracle.dss.selection.Selection)
     void oracle.dss.queryBuilder.QueryBuilderMultiSourceDimensionModel.setSelection(oracle.dss.selection.Selection)
     void oracle.dss.queryBuilder.StepsPanel.loadSteps()
     void oracle.dss.queryBuilder.StepsPanel.selectionChanged(oracle.dss.datautil.SelectionChangedEvent)
     void oracle.dss.dataSource.common.QueryQueryAccess.fireSelectionChanged(oracle.dss.datautil.SelectionChangedEvent)
     void oracle.dss.dataSource.common.QueryQueryAccess$SelCursor._fireSelectionChanged()
     void oracle.dss.dataSource.common.QueryQueryAccess$SelCursor.setSelection(oracle.dss.selection.Selection)
     oracle.dss.dataSource.common.QueryQueryAccess$SelCursor oracle.dss.dataSource.common.QueryQueryAccess._setSelection(oracle.dss.selection.Selection)
     void oracle.dss.dataSource.common.QueryQueryAccess.setSelection(oracle.dss.selection.Selection)
     boolean oracle.dss.queryBuilder.QueryBuilderMultiSourceDimensionModel.drill(int, int)
     boolean oracle.dss.util.dimensionList.DimensionList.doDrill(int)
     void oracle.dss.util.dimensionList.DimensionList.handleMouseClicked(java.awt.event.MouseEvent)
     void oracle.dss.util.dimensionList.DimensionList.processMouseEvent(java.awt.event.MouseEvent)
     void java.awt.Component.processEvent(java.awt.AWTEvent)
     void java.awt.Container.processEvent(java.awt.AWTEvent)
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
     void java.awt.Dialog.show()
     void java.awt.Component.show(boolean)
     void java.awt.Component.setVisible(boolean)
     boolean oracle.bali.ewt.wizard.WizardDialog.runDialog()
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.runDialog()
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.run()
     boolean oracle.dss.queryBuilder.QueryBuilder.run()
     boolean oracle.dss.addins.editor.presentation.QueryBuilderTool.runTool(oracle.dss.addins.designer.BIDesigner, oracle.dss.dataView.Dataview, java.awt.Frame)
     void oracle.dss.addins.editor.presentation.PresentationToolbarButton.actionPerformed(java.awt.event.ActionEvent)
     void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)
     void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)
     void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)
     void javax.swing.DefaultButtonModel.setPressed(boolean)
     void javax.swing.plaf.basic.BasicButtonListener.mouseReleased(java.awt.event.MouseEvent)
     void java.awt.AWTEventMulticaster.mouseReleased(java.awt.event.MouseEvent)
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
     void java.awt.Component.processEvent(java.awt.AWTEvent)
     void java.awt.Container.processEvent(java.awt.AWTEvent)
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
     void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)
     void java.awt.EventDispatchThread.run()
When i try open all values in "Available:" window, everything is O.K.
But when i select "Condition" tab, i get same error.
All works if values < 1000.
What can i do to avoid this error ? 

Hi Vasily,
Can you give us details of the database version and list of patches of applied, JDev version and version of BIBeans, operating system of database and JDev client OS.
I have checked with the OLAPI team we are not aware of any limits within the OLAPI API which might cause an ORA-902 error. But if we can get some more information from you we can progress this.
Thanks
Keith Laker
BI Beans PM 

Hi Keith
The software I have installed is:
1. Oracle Database 9.0.1.1.1 on Windows 2000 Advanced Server SP2
2. Oracle Database Patch 9.0.1.3.1
3. Oracle OLAP Patch 9.0.1.2.1
4. JDeveloper 9.0.2.829 on the same computer
5. BI Beans 9.0.2.7.0
I also can't select more than 1000 elements of dimension in Cube Viewer too.
Simply nothing happen.
I have installed this software on 3 different computers and the problems are remained.
Thanks in advance. 

Hi,
Have you checked to ensure you have sufficient temp tablespace for this as I think this query will require a lot of space. Can you provide details of your TEMP tablespace associated with BIBDEMO, OLAPSYS and OLAPDBA accounts.
I will also try and create a test case to see if I can reproduce this.
Keith Laker
BI Beans PM 

Hi Keith
I created datatabse on template "General Purpose"
size of tablespaces:
TEMP 40 MB
BIBTEMP 40 MB
I extended them up to 512 MB
but when i work with cubes the space used is about 39 MB
I added about 1200 rows in table BIBDEMO_DIVISION and in cubes
BIBDEMO_ACTUAL_CUBE, BIBDEMO_BUDGET_CUBE i have same problems.
Thanks 

Hi Vasily,
I have tested this using the next release of BIBeans (which should be available late Sept with the next release of JDeveleper) and database versions 9.0.2. I have added 11,000 dimension values to one parent using our demo database and reproduced the problems you described. I have logged a bug for this (Ref 2518164 but I am not sure if this is an internal bug so you may not be able to see this via Metalink). I will keep this thread updated with details of the bug so you can monitor progress.
Will you be able to upgrade to JDev/BIBeans 9.0.3 and Database 9.0.2 when these products are available?
Keith Laker
BI Beans PM 

Hi Keith
When new JDeveloper, BIBeans and Database will be available i'll upgrade them.
Will be looking for news on this thread.
Thanks for help.

Hi Vasily,
We are hoping this will be available in the next couple of weeks, but it will be tied to the latest release of JDeveloper. I will try to keep you posted regarding the exact release dates.
Keith Laker
BI Beans PM

Related

bibeans error

hi
i have created a cube with one multi level dimension
and 3 one level dimension using owb 9.2
and i checked the metadata using bi_checkconfig and the out put is ok
when i try to build a presentation in the Bibeans i get the following error in the multi-level dimension page
java.lang.NullPointerException
     boolean oracle.dss.dataSource.common.CubeCursor._compareStrings(java.lang.String, java.lang.String, int)
          CubeCursor.java:1943
     int oracle.dss.dataSource.common.CubeCursor.findMember(int, int[], int, java.lang.String, java.lang.String, int)
          CubeCursor.java:1924
     int oracle.dss.dataSource.common.QueryDataAccess.findMember(int, int[], int, java.lang.String, java.lang.String, int)
          QueryDataAccess.java:1152
     int oracle.dss.datautil.QueryAccessUtilities.getDimMemberPosition(java.lang.String, java.lang.String)
          QueryAccessUtilities.java:528
     oracle.dss.util.RangeCollection oracle.dss.queryBuilder.DimensionListShuttlePanel.getAbsoluteRangeCollection(oracle.dss.util.RangeCollection, int)
          DimensionListShuttlePanel.java:460
     void oracle.dss.queryBuilder.DimensionListShuttlePanel.updateRangeCollection(oracle.dss.selection.step.MemberStep)
          DimensionListShuttlePanel.java:576
     oracle.dss.selection.step.MemberStep oracle.dss.queryBuilder.DimensionListShuttlePanel.createMemberStep(int[], java.lang.String, java.lang.String, int)
          DimensionListShuttlePanel.java:599
     java.lang.Object[] oracle.dss.queryBuilder.DimensionListShuttlePanel.getItems(int[], java.lang.String, java.lang.String, int)
          DimensionListShuttlePanel.java:480
     java.lang.Object[] oracle.dss.queryBuilder.DimensionListShuttlePanel.getSelectedItems(int)
          DimensionListShuttlePanel.java:499
     java.lang.Object[] oracle.dss.queryBuilder.DimensionListShuttlePanel.getSelectedItems()
          DimensionListShuttlePanel.java:531
     void oracle.dss.datautil.gui.Shuttle.updateEnabled()
          Shuttle.java:445
     void oracle.dss.datautil.gui.Shuttle.focusGained(java.awt.event.FocusEvent)
          Shuttle.java:687
     void oracle.dss.queryBuilder.ShuttlePanel.fireFocusEvent(java.awt.event.FocusEvent)
          ShuttlePanel.java:191
     void oracle.dss.queryBuilder.ShuttlePanel.fireFocusEvent()
          ShuttlePanel.java:276
     void oracle.dss.queryBuilder.DimensionListShuttlePanel$MyDimensionListAdapter.dimensionSelecting(oracle.dss.util.dimensionList.DimensionListEvent)
          DimensionListShuttlePanel.java:937
     void oracle.dss.util.dimensionList.DimensionList.notifyDimensionListListener(oracle.dss.util.dimensionList.DimensionListEvent)
          DimensionList.java:2067
     void oracle.dss.util.dimensionList.DimensionList.valueChanged(javax.swing.event.ListSelectionEvent)
          DimensionList.java:1775
     void javax.swing.JList.fireSelectionValueChanged(int, int, boolean)
          JList.java:946
     void javax.swing.JList$ListSelectionHandler.valueChanged(javax.swing.event.ListSelectionEvent)
          JList.java:960
     void javax.swing.DefaultListSelectionModel.fireValueChanged(int, int, boolean)
          DefaultListSelectionModel.java:170
     void javax.swing.DefaultListSelectionModel.fireValueChanged(int, int)
          DefaultListSelectionModel.java:150
     void javax.swing.DefaultListSelectionModel.fireValueChanged()
          DefaultListSelectionModel.java:197
     void javax.swing.DefaultListSelectionModel.changeSelection(int, int, int, int, boolean)
          DefaultListSelectionModel.java:359
     void javax.swing.DefaultListSelectionModel.changeSelection(int, int, int, int)
          DefaultListSelectionModel.java:368
     void javax.swing.DefaultListSelectionModel.setSelectionInterval(int, int)
          DefaultListSelectionModel.java:392
     void javax.swing.JList.setSelectionInterval(int, int)
          JList.java:1209
     void javax.swing.plaf.basic.BasicListUI$MouseInputHandler.mousePressed(java.awt.event.MouseEvent)
          BasicListUI.java:795
     void java.awt.AWTEventMulticaster.mousePressed(java.awt.event.MouseEvent)
          AWTEventMulticaster.java:221
     void java.awt.AWTEventMulticaster.mousePressed(java.awt.event.MouseEvent)
          AWTEventMulticaster.java:220
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
          Component.java:3712
     void oracle.dss.util.dimensionList.DragList.processMouseEvent(java.awt.event.MouseEvent)
          DragList.java:202
     void oracle.dss.util.dimensionList.DimensionList.processMouseEvent(java.awt.event.MouseEvent)
          DimensionList.java:2167
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2210
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.Dialog.show()
          Dialog.java:380
     void java.awt.Component.show(boolean)
          Component.java:946
     void java.awt.Component.setVisible(boolean)
          Component.java:903
     void oracle.dss.addins.common.wizard.AbstractBuilderDialog.setVisible(boolean)
          AbstractBuilderDialog.java:286
     void oracle.dss.addins.wizard.presentation.PresentationWizardDialog.setVisible(boolean)
          PresentationWizardDialog.java:397
     boolean oracle.bali.ewt.wizard.WizardDialog.runDialog()
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.runDialog()
          DefaultBuilderDialog.java:481
     boolean oracle.dss.addins.common.wizard.AbstractBuilderDialog.runDialog()
          AbstractBuilderDialog.java:266
     boolean oracle.ide.dialogs.WizardLauncher.runDialog(javax.swing.JDialog)
          WizardLauncher.java:51
     boolean oracle.dss.addins.common.BIWizardImpl.invoke(oracle.ide.addin.Context, java.lang.String[])
          BIWizardImpl.java:147
     boolean oracle.dss.addins.wizard.presentation.PresentationWizardAddin.invoke(oracle.ide.addin.Context, java.lang.String[])
          PresentationWizardAddin.java:54
     boolean oracle.dss.addins.wizard.presentation.PresentationWizardAddin.invokeFromMenu(oracle.ide.addin.Context, java.lang.String[], oracle.dss.addins.designer.BIFolder, oracle.dss.addins.designer.BIDesigner, boolean)
          PresentationWizardAddin.java:73
     void oracle.dss.addins.designer.BIDesignerAddin.actionPerformed(java.awt.event.ActionEvent)
          BIDesignerAddin.java:572
     void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1450
     void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1504
     void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)
          DefaultButtonModel.java:378
     void javax.swing.DefaultButtonModel.setPressed(boolean)
          DefaultButtonModel.java:250
     void javax.swing.AbstractButton.doClick(int)
          AbstractButton.java:279
     void javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(java.awt.event.MouseEvent)
          BasicMenuItemUI.java:886
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
          Component.java:3715
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2216
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)
          EventDispatchThread.java:93
     void java.awt.EventDispatchThread.run()
          EventDispatchThread.java:85
when i edit the cube and remove the multi level dimension from it every thing is ok.
So what is the problem?
thanks
Which version of the database are you using
Which version of the JDeveloper are you using
Which version of the BIBeans are you using
What type of OLAP schema are you trying to create relational or AW?
Did you try running BICheckConfig with '-q' option which will force a query to be run against each measure and each dimension in your catalog.
Also have you ensured all your dimension values are unique across all levels. The OLAPI interface creates a union of all dimension members from all the key columns identified in the metadata. Hence, your dimension keys across all levels need to be unique.
Hope this helps
Business Intelligence Beans Product Management Team
Oracle Corporation 
thanks for your reply
JDeveloper version = 9.0.3.1.1107
BI Beans version = 9.0.3.6.0A
BI Beans internal version = 2.7.0.13.1
Database version = 9.2.0.4.0
OLAP Catalog version = 9.2.0.4.1
when i use the -q option it shows that the problem is with the cube, but when i remove the multi level dimension from the cube it works correctly
so what do you think what can i do?
OLAP and BI Beans does support multi-level dimensions, see the BIBDEMO schema shipped with BI Beans in the JDEV_HOME/bibeans/bibdemo_schema.
There are certain requirements for creating a multi-level dimension. Please refer the OLAP user guides, which are available on the OLAP documentation section of OTN. There are additional validators you can run against your schema to provide very low level information on dimensions, levels and hierarchies:
set serveroutput on size 1000000
exec cwm2_olap_manager.Set_Echo_On;
exec cwm2_olap_manager.Begin_Log('insert utl_file_dir' ,'Instance_Validate.log');
exec cwm2_olap_validate.Validate_ALL_Dimensions('OLAP API');
exec cwm2_olap_validate.Validate_ALL_Cubes('OLAP API');
exec cwm2_olap_validate.Validate_Olap_Catalog('OLAP API');
exec cwm2_olap_manager.End_Log;
You need to have UTIL_FILE_DIR set in your init.ora to allow a report to be created and the output displayed within SQLPlus
Business Intelligence Beans Product Management Team
Oracle Corporation

errror BI-9527

I need help,
after creating a report, i can't drill down into dimensions.
either in JDev or threw JSP page, the following error occurs:
oracle.dss.util.DataDirectorException: BIB-9527
Unable to prepare the OLAP transaction.
oracle.express.idl.util.OlapiException
oracle.dss.dataSource.common.OLAPTransactionException: BIB-9527 Unable to prepare the OLAP transaction.
oracle.express.idl.util.OlapiException
oracle.express.idl.util.OlapiException
     boolean oracle.dss.dataSource.common.QueryDataDirector.drill(int, int, int, int)
          QueryDataDirector.java:318
     boolean oracle.dss.dataView.ModelAdapter.drillGestureHappened(java.lang.Object, int, int, int, int)
          ModelAdapter.java:416
     void oracle.dss.crosstab.CrosstabControllerAdapter.headerCellDrill(oracle.bali.ewt.pivot.DrillEvent)
          CrosstabControllerAdapter.java:594
     void oracle.bali.ewt.pivot.PivotTable.processDrillEvent(oracle.bali.ewt.pivot.DrillEvent)
     void oracle.bali.ewt.pivot.PivotTable.processEventImpl(java.awt.AWTEvent)
     void oracle.bali.ewt.LWComponent.processEvent(java.awt.AWTEvent)
     void oracle.bali.ewt.pivot.PivotTable.postEvent(java.awt.AWTEvent)
     void oracle.bali.ewt.pivot.PivotTable.fireDrillEvent(int, int, int, java.lang.Object)
     void oracle.dss.crosstab.CrosstabControllerAdapter.headerCellDrillRequest(oracle.bali.ewt.pivot.DrillEvent)
          CrosstabControllerAdapter.java:378
     void oracle.bali.ewt.pivot.PivotTable.processDrillEvent(oracle.bali.ewt.pivot.DrillEvent)
     void oracle.bali.ewt.pivot.PivotTable.processEventImpl(java.awt.AWTEvent)
     void oracle.bali.ewt.LWComponent.processEvent(java.awt.AWTEvent)
     void oracle.bali.ewt.pivot.PivotTable.postEvent(java.awt.AWTEvent)
     void oracle.bali.ewt.pivot.PivotHeaderTabAdapt.headerCellDrillRequest(oracle.bali.ewt.pivot.DrillEvent)
     void oracle.bali.ewt.pivot.PivotHeader.fireHeaderCellDrillRequest(int, int)
     void oracle.bali.ewt.pivot.PivotHeaderInputHandler.mousePressed(java.awt.event.MouseEvent, oracle.bali.ewt.grid.Grid, int, int)
     void oracle.dss.crosstab.CrosstabHeaderInputHandler.mousePressed(java.awt.event.MouseEvent, oracle.bali.ewt.grid.Grid, int, int)
          CrosstabHeaderInputHandler.java:112
     void oracle.bali.ewt.grid.Grid._handleMousePressed(java.awt.event.MouseEvent, oracle.bali.ewt.selection.Cell, oracle.bali.ewt.grid.CellInputHandler)
     void oracle.bali.ewt.grid.Grid.processMouseEvent(java.awt.event.MouseEvent)
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void oracle.bali.ewt.LWComponent.processEventImpl(java.awt.AWTEvent)
     void oracle.bali.ewt.grid.Grid.processEventImpl(java.awt.AWTEvent)
     void oracle.bali.ewt.LWComponent.processEvent(java.awt.AWTEvent)
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2210
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)
          EventDispatchThread.java:93
     void java.awt.EventDispatchThread.run()
          EventDispatchThread.java:85
thanks for your help !!!
Hi,
I assume that your drilling problem only affects one dimension? Or do you get an error on all your dimensions?
Can you please try running the BICheckConfig utility. This will check your OLAP catalog to ensure it is correctly populated and each dimension and measure can be queried successfully. You can get this utility from the BI Beans section of OTN
Follow the readme/documentation included in the zip file and this should highlight where the problem is.
If this does not help then we need to know
1) versions of JDeveloper BI Beans
2) Database version
3) Operating system (database and JDev/BI Beans)
Keith Laker
Product Manager
Oracle Business Intelligence Beans

Internal errors during Query Builder

Please help me to correct a problem. Database user has a very simple cube: a measure with two dimensions. User (named "warehouse") owns it, the fact table, the dimension tables etc.; client application connects using warehouse account too.
While QueryBuilder makes a data source, one dimension (providers) fails at the some selections; for example, selections "top 10" and "last 3" works, but selection "measure value > 10000" fails; the other dimension (services) works great with all selections tried.
"Fails" means that selection step can be selected (moved from "available" to "selected" box), but cannot be configured (edited) at any manner, both in the left and right boxes - for example, I cannot edit value "10000". This selection cannot be applied too. Visually query builder does nothing, but prints exception trace (see below).
My configuration:
BI Beans Diagnostics(v1.0.0.0) 04.03.04
===============================================================================
JDEV_ORACLE_HOME ............................. = C:\JDeveloper
JAVA_HOME .................................... = C:\JDeveloper\jdk
JDeveloper version ........................... = 9.0.3.1.1107
BI Beans version ............................. = 9.0.3.6.0
BI Beans internal version .................... = 2.7.0.14
Connect to database .......................... = Successful
JDBC driver version .......................... = 9.2.0.3.0
JDBC JAR file location ....................... = C:\JDeveloper\jdbc\lib
Database version ............................. = 9.2.0.4.0
OLAP Catalog version ......................... = 9.2.0.4.1
OLAP AW Engine version ....................... = 9.2.0.4.1
OLAP API Server version ...................... = 9.2.0.4.1
BI Beans Catalog version ..................... = N/A; not installed in warehouse
OLAP API JAR file version .................... = 9.2
OLAP API JAR file location ................... = C:\JDeveloper\jdev\lib\ext
Load OLAP API metadata ....................... = Successful
Number of metadata folders ................... = 3
Number of metadata measures .................. = 1
Number of metadata dimensions ................ = 2
Metadata output location ..................... = C:\JDeveloper\bibeans\bin\bi_metadata.txt
Exception:
Thu Mar 04 11:08:21 MSK 2004 In oracle.dss.queryBuilder.QueryBuilderQueryAccessUtils::getDimMembers
Sorry, these lines are re-translated from localized version
oracle.express.ExpressServerException Error class: OLAPI
Server errors description:
DPR: Unable to create server cursor, Universal at TxsOqDefinitionManagerSince9202::crtCurMgrWthInputTypes
OES: ORA-01722: invalid number
, Universal at TxsRdbSelectStatement:execute()
     oracle.express.idl.ExpressOlapiDataCursorModule.CursorManagerInterface oracle.express.olapi.data.full.DefinitionManagerSince9202.createCursorManagerInterface(oracle.olapi.data.source.CursorManagerSpecification, oracle.olapi.data.source.SourceDefinition, oracle.olapi.data.source.Source[], long)
          DefinitionManagerSince9202.java:260
     oracle.express.olapi.data.full.ExpressSpecifiedCursorManager oracle.express.olapi.data.full.DefinitionManager.createCursorManager(oracle.olapi.data.source.CursorManagerSpecification, oracle.olapi.data.source.Source[], long)
          DefinitionManager.java:132
     oracle.olapi.data.source.SpecifiedCursorManager oracle.express.olapi.data.full.ExpressDataProvider.createCursorManagerSince9202(oracle.olapi.data.source.CursorManagerSpecification, oracle.olapi.data.source.Source[], long)
          ExpressDataProvider.java:729
     oracle.olapi.data.source.SpecifiedCursorManager oracle.express.olapi.data.full.ExpressDataProvider.internalCreateCursorManager(oracle.olapi.data.source.CursorManagerSpecification, oracle.olapi.data.source.Source[], long)
          ExpressDataProvider.java:624
     oracle.olapi.data.source.SpecifiedCursorManager oracle.express.olapi.data.full.ExpressDataProvider.createCursorManager(oracle.olapi.data.source.CursorManagerSpecification, oracle.olapi.data.source.Source[])
          ExpressDataProvider.java:555
     oracle.olapi.data.source.SpecifiedCursorManager oracle.olapi.data.source.DataProvider.createCursorManager(oracle.olapi.data.source.CursorManagerSpecification)
          DataProvider.java:269
     oracle.express.olapi.data.full.ExpressSpecifiedCursorManager[] oracle.dss.dataSource.QueryUtilities.setUpCursors(oracle.dss.dataSource.SourceTemplate[], oracle.dss.dataSource.common.CubeCursor[], oracle.olapi.data.source.Source[], oracle.express.olapi.data.full.ExpressSpecifiedCursorManager[], boolean, boolean, boolean, boolean)
          QueryUtilities.java:558
     oracle.express.olapi.data.full.ExpressSpecifiedCursorManager[] oracle.dss.dataSource.QueryServer._setUpCursorsForMainQuery(oracle.dss.dataSource.SourceTemplate[], oracle.dss.dataSource.common.CubeCursor[], boolean, boolean, boolean, boolean)
          QueryServer.java:7036
     void oracle.dss.dataSource.QueryServer._getCursorForCube(oracle.dss.dataSource.common.DimTree, boolean, boolean, boolean, boolean, boolean)
          QueryServer.java:4096
     void oracle.dss.dataSource.QueryServer._createCubeAndCursor(boolean, boolean, boolean)
          QueryServer.java:4251
     void oracle.dss.dataSource.QueryServer._createCommonQuery(java.lang.String[][], java.lang.String[], oracle.dss.util.Operation, oracle.dss.dataSource.common.QueryState)
          QueryServer.java:3894
     void oracle.dss.dataSource.QueryServer._initQuery(java.lang.String[][], java.lang.String[], oracle.dss.util.Operation, oracle.dss.dataSource.common.QueryState)
          QueryServer.java:3841
     java.lang.Object java.lang.reflect.Method.invoke(java.lang.Object, java.lang.Object[])
          native code
     java.lang.Object oracle.dss.util.Operation.execute(java.lang.Object)
          Operation.java:69
     java.lang.Object oracle.dss.dataSource.OperationQueue.update()
          OperationQueue.java:68
     java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOperation(oracle.dss.util.Operation, int)
          BaseOperationQueue.java:176
     java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOperation(oracle.dss.util.Operation)
          BaseOperationQueue.java:146
     java.lang.Object oracle.dss.dataSource.QueryServer.queueOperation(java.lang.String, oracle.dss.util.Parameter[], boolean, oracle.dss.dataSource.common.QueryEvent, java.lang.String, oracle.dss.util.Parameter[], oracle.dss.dataSource.common.QueryState)
          QueryServer.java:7073
     void oracle.dss.dataSource.QueryServer.initQuery(java.lang.String[][], java.lang.String[])
          QueryServer.java:3803
     java.lang.Object java.lang.reflect.Method.invoke(java.lang.Object, java.lang.Object[])
          native code
     java.lang.Object oracle.dss.util.Operation.execute(java.lang.Object)
          Operation.java:69
     java.lang.Object oracle.dss.dataSource.QueryManagerServer.sendQueue(oracle.dss.dataSource.common.BaseOperationQueue)
          QueryManagerServer.java:1548
     java.lang.Object oracle.dss.dataSource.common.OperationQueue.update()
          OperationQueue.java:198
     java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOperation(oracle.dss.util.Operation, int)
          BaseOperationQueue.java:176
     java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOperation(oracle.dss.util.Operation)
          BaseOperationQueue.java:146
     void oracle.dss.dataSource.client.QueryClient.initQuery(java.lang.String[][], java.lang.String[])
          QueryClient.java:1581
     oracle.dss.util.DataAccess oracle.dss.dataSource.common.QueryQueryAccess$SelCursor.getDataAccess(boolean)
          QueryQueryAccess.java:1099
     oracle.dss.util.DataAccess oracle.dss.dataSource.common.QueryQueryAccess.getDataAccess(java.lang.String)
          QueryQueryAccess.java:278
     java.util.Vector oracle.dss.queryBuilder.QueryBuilderQueryAccessUtils.getDimMembers(oracle.dss.datautil.QueryAccessUtilities, java.lang.String, java.lang.String, java.util.Vector, java.lang.String)
          QueryBuilderQueryAccessUtils.java:220
     oracle.dss.datautil.DimensionMember oracle.dss.queryBuilder.QueryBuilderQueryAccessUtils.getDimMember(oracle.dss.datautil.QueryAccessUtilities, java.lang.String, java.lang.String, java.lang.String, java.lang.String)
          QueryBuilderQueryAccessUtils.java:156
     java.util.Vector oracle.dss.queryBuilder.stepView.ConditionStepView.getQDRMemberNames(java.lang.String, oracle.dss.selection.OlapQDR)
          ConditionStepView.java:230
     void oracle.dss.queryBuilder.stepView.ConditionStepView.updateQDRControls()
          ConditionStepView.java:606
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateQDR()
          MeasConditionStepView.java:451
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateMeasureEditorSelection()
          MeasConditionStepView.java:208
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateMeasureEditorContents()
          MeasConditionStepView.java:271
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateMeasureEditorSelection()
          MeasConditionStepView.java:161
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateControls()
          MeasConditionStepView.java:148
     void oracle.dss.queryBuilder.stepView.StepView.updateStepEditor(oracle.dss.selection.step.Step, boolean, boolean, int)
          StepView.java:562
     javax.swing.JPanel oracle.dss.queryBuilder.stepView.StepView.getStepEditor(oracle.dss.selection.step.Step, boolean, boolean, int, int)
          StepView.java:522
     void oracle.dss.queryBuilder.StepsPanelEditor.startEdit(java.awt.Component, java.lang.String, int, java.awt.Rectangle)
          StepsPanelEditor.java:93
     boolean oracle.dss.util.dimensionList.DimensionList.doEdit(int)
          DimensionList.java:525
     void oracle.dss.queryBuilder.StepsPanel$MyDimensionListAdapter.startEditingNewSelection()
          StepsPanel.java:404
     void oracle.dss.queryBuilder.StepsPanel$MyDimensionListAdapter.dimensionSelected(oracle.dss.util.dimensionList.DimensionListEvent)
          StepsPanel.java:374
     void oracle.dss.util.dimensionList.DimensionList.notifyDimensionListListener(oracle.dss.util.dimensionList.DimensionListEvent)
          DimensionList.java:2074
     void oracle.dss.util.dimensionList.DimensionList.valueChanged(javax.swing.event.ListSelectionEvent)
          DimensionList.java:1772
     void javax.swing.JList.fireSelectionValueChanged(int, int, boolean)
          JList.java:946
     void javax.swing.JList$ListSelectionHandler.valueChanged(javax.swing.event.ListSelectionEvent)
          JList.java:960
     void javax.swing.DefaultListSelectionModel.fireValueChanged(int, int, boolean)
          DefaultListSelectionModel.java:170
     void javax.swing.DefaultListSelectionModel.fireValueChanged(boolean)
          DefaultListSelectionModel.java:140
     void javax.swing.DefaultListSelectionModel.setValueIsAdjusting(boolean)
          DefaultListSelectionModel.java:507
     void javax.swing.JList.setValueIsAdjusting(boolean)
          JList.java:1261
     void javax.swing.plaf.basic.BasicListUI$MouseInputHandler.mouseReleased(java.awt.event.MouseEvent)
          BasicListUI.java:831
     void java.awt.AWTEventMulticaster.mouseReleased(java.awt.event.MouseEvent)
          AWTEventMulticaster.java:231
     void java.awt.AWTEventMulticaster.mouseReleased(java.awt.event.MouseEvent)
          AWTEventMulticaster.java:230
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
          Component.java:3715
     void oracle.dss.util.dimensionList.DragList.processMouseEvent(java.awt.event.MouseEvent)
          DragList.java:202
     void oracle.dss.util.dimensionList.DimensionList.processMouseEvent(java.awt.event.MouseEvent)
          DimensionList.java:2167
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2216
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.Dialog.show()
          Dialog.java:380
     void java.awt.Component.show(boolean)
          Component.java:946
     void java.awt.Component.setVisible(boolean)
          Component.java:903
     boolean oracle.bali.ewt.wizard.WizardDialog.runDialog()
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.runDialog()
          DefaultBuilderDialog.java:481
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.run()
          DefaultBuilderDialog.java:466
     boolean oracle.dss.queryBuilder.QueryBuilder.run()
          QueryBuilder.java:2401
     void borlas.oa.Actions.actionEditQuery.doAction()
          actionEditQuery.java:44
     boolean borlas.oa.Actions.Action.fire()
          Action.java:88
     void borlas.oa.Forms.FormModule.editQuery()
          FormModule.java:132
     void borlas.oa.Forms.FormModule.access$6000071(borlas.oa.Forms.FormModule)
          FormModule.java:42
     void borlas.oa.Forms.FormModule$1.actionPerformed(java.awt.event.ActionEvent)
          FormModule.java:113
     void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1450
     void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1504
     void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)
          DefaultButtonModel.java:378
     void javax.swing.DefaultButtonModel.setPressed(boolean)
          DefaultButtonModel.java:250
     void javax.swing.AbstractButton.doClick(int)
          AbstractButton.java:279
     void javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(java.awt.event.MouseEvent)
          BasicMenuItemUI.java:886
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
          Component.java:3715
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2216
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)
          EventDispatchThread.java:93
     void java.awt.EventDispatchThread.run()
          EventDispatchThread.java:85
Exception occurred during event dispatching:
java.lang.NullPointerException
     java.util.Vector oracle.dss.queryBuilder.stepView.ConditionStepView.getQDRMemberNames(java.lang.String, oracle.dss.selection.OlapQDR)
          ConditionStepView.java:230
     void oracle.dss.queryBuilder.stepView.ConditionStepView.updateQDRControls()
          ConditionStepView.java:606
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateQDR()
          MeasConditionStepView.java:451
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateMeasureEditorSelection()
          MeasConditionStepView.java:208
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateMeasureEditorContents()
          MeasConditionStepView.java:271
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateMeasureEditorSelection()
          MeasConditionStepView.java:161
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateControls()
          MeasConditionStepView.java:148
     void oracle.dss.queryBuilder.stepView.StepView.updateStepEditor(oracle.dss.selection.step.Step, boolean, boolean, int)
          StepView.java:562
     javax.swing.JPanel oracle.dss.queryBuilder.stepView.StepView.getStepEditor(oracle.dss.selection.step.Step, boolean, boolean, int, int)
          StepView.java:522
     void oracle.dss.queryBuilder.StepsPanelEditor.startEdit(java.awt.Component, java.lang.String, int, java.awt.Rectangle)
          StepsPanelEditor.java:93
     boolean oracle.dss.util.dimensionList.DimensionList.doEdit(int)
          DimensionList.java:525
     void oracle.dss.queryBuilder.StepsPanel$MyDimensionListAdapter.startEditingNewSelection()
          StepsPanel.java:404
     void oracle.dss.queryBuilder.StepsPanel$MyDimensionListAdapter.dimensionSelected(oracle.dss.util.dimensionList.DimensionListEvent)
          StepsPanel.java:374
     void oracle.dss.util.dimensionList.DimensionList.notifyDimensionListListener(oracle.dss.util.dimensionList.DimensionListEvent)
          DimensionList.java:2074
     void oracle.dss.util.dimensionList.DimensionList.valueChanged(javax.swing.event.ListSelectionEvent)
          DimensionList.java:1772
     void javax.swing.JList.fireSelectionValueChanged(int, int, boolean)
          JList.java:946
     void javax.swing.JList$ListSelectionHandler.valueChanged(javax.swing.event.ListSelectionEvent)
          JList.java:960
     void javax.swing.DefaultListSelectionModel.fireValueChanged(int, int, boolean)
          DefaultListSelectionModel.java:170
     void javax.swing.DefaultListSelectionModel.fireValueChanged(boolean)
          DefaultListSelectionModel.java:140
     void javax.swing.DefaultListSelectionModel.setValueIsAdjusting(boolean)
          DefaultListSelectionModel.java:507
     void javax.swing.JList.setValueIsAdjusting(boolean)
          JList.java:1261
     void javax.swing.plaf.basic.BasicListUI$MouseInputHandler.mouseReleased(java.awt.event.MouseEvent)
          BasicListUI.java:831
     void java.awt.AWTEventMulticaster.mouseReleased(java.awt.event.MouseEvent)
          AWTEventMulticaster.java:231
     void java.awt.AWTEventMulticaster.mouseReleased(java.awt.event.MouseEvent)
          AWTEventMulticaster.java:230
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
          Component.java:3715
     void oracle.dss.util.dimensionList.DragList.processMouseEvent(java.awt.event.MouseEvent)
          DragList.java:202
     void oracle.dss.util.dimensionList.DimensionList.processMouseEvent(java.awt.event.MouseEvent)
          DimensionList.java:2167
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2216
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.Dialog.show()
          Dialog.java:380
     void java.awt.Component.show(boolean)
          Component.java:946
     void java.awt.Component.setVisible(boolean)
          Component.java:903
     boolean oracle.bali.ewt.wizard.WizardDialog.runDialog()
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.runDialog()
          DefaultBuilderDialog.java:481
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.run()
          DefaultBuilderDialog.java:466
     boolean oracle.dss.queryBuilder.QueryBuilder.run()
          QueryBuilder.java:2401
     void borlas.oa.Actions.actionEditQuery.doAction()
          actionEditQuery.java:44
     boolean borlas.oa.Actions.Action.fire()
          Action.java:88
     void borlas.oa.Forms.FormModule.editQuery()
          FormModule.java:132
     void borlas.oa.Forms.FormModule.access$6000071(borlas.oa.Forms.FormModule)
          FormModule.java:42
     void borlas.oa.Forms.FormModule$1.actionPerformed(java.awt.event.ActionEvent)
          FormModule.java:113
     void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1450
     void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1504
     void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)
          DefaultButtonModel.java:378
     void javax.swing.DefaultButtonModel.setPressed(boolean)
          DefaultButtonModel.java:250
     void javax.swing.AbstractButton.doClick(int)
          AbstractButton.java:279
     void javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(java.awt.event.MouseEvent)
          BasicMenuItemUI.java:886
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
          Component.java:3715
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2216
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)
          EventDispatchThread.java:93
     void java.awt.EventDispatchThread.run()
          EventDispatchThread.java:85

Few Questions - Warehouse Builder.

hello
Product Info: -
Oracle9i Database 9.2.0.1.0
Oracle9i 9.2.0.1.0
Oracle9i Patch 9.2.0.4.0
Oracle OLAP 9.2.0.1.0
Oracle OLAP Patch 9.2.0.4.0
Oracle OLAP Cube Viewer 9.2.0.1.0
Oracle OLAP Worksheet 9.2.0.1.0
Oracle OLAP API 9.2.0.4.1
Oracle OLAP Worksheet 9.2.0.1.0
{Oracle OLAP CWM Lite Patch 9.2.0.4.0 }
Enterprise Manager Base Classes 9.2.0.1.0
Enterprise Manager Translated Files 9.2.0.1.0
Enterprise Edition Options 9.2.0.1.0
Enterprise Manager Minimal Integration 9.2.0.1.0
Oracle9i Developer Suite 9.0.2.0.1
Oracle9i JDeveloper 9.0.2.822.0
Oracle9i JDeveloper IDE 9.0.2.797.0
Oracle9i Business Intelligence Beans 9.0.2.7.0
Information : -I have created dimensons cubes . I have deploed to OLAP and Analytical Workspace Manager and Loaded the data in AWM.Now I m working in jdeveloper
Problems: -
1-     I created workspace + project in jdeveloper. Now i create Business Intelligence --> Designer in the project. The BI Designer wizard starts and it ask me for OLAP Data Source (connection) . Now i create connection using JDBC + specifying my runtime target user + Using thin driver. The it searches for OLAP Server Instance and gives error that: -
java.lang.NullPointerException
     +
Failed to connect to the OLAP server Instance
     +
Stack Trace Shows:-
oracle.dss.addins.designer.OLAPSource$OlapSourceException: Connection information is incomplete, Service Name is not specified.      void oracle.dss.addins.designer.OLAPSource.checkConnectionInfo()      int oracle.dss.addins.designer.OLAPSource.test()      boolean oracle.dss.addins.wizard.configFileEditor.OlapPanel.testConnection(boolean, java.lang.String)      void oracle.dss.addins.wizard.configFileEditor.OlapPanel.btnTest_actionPerformed(java.awt.event.ActionEvent)      void oracle.dss.addins.wizard.configFileEditor.OlapPanel$3.actionPerformed(java.awt.event.ActionEvent)      void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)      void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)      void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)      void javax.swing.DefaultButtonModel.setPressed(boolean)      void javax.swing.plaf.basic.BasicButtonListener.mouseReleased(java.awt.event.MouseEvent)      void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)      void java.awt.Component.processEvent(java.awt.AWTEvent)      void java.awt.Container.processEvent(java.awt.AWTEvent)      void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Component.dispatchEvent(java.awt.AWTEvent)      void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)      boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)      boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)      void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Component.dispatchEvent(java.awt.AWTEvent)      void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)      boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)      void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)      void java.awt.Dialog.show()      void java.awt.Component.show(boolean)      void java.awt.Component.setVisible(boolean)      boolean oracle.bali.ewt.dialog.JEWTDialog.runDialog()      boolean oracle.ide.dialogs.WizardLauncher.runDialog(javax.swing.JDialog)      boolean oracle.ide.dialogs.OnePageWizardDialogFactory.runDialog(java.awt.Component, java.awt.Component, java.awt.Component, java.lang.String, int, java.beans.VetoableChangeListener)      boolean oracle.ide.dialogs.OnePageWizardDialogFactory.runDialog(java.awt.Component, java.awt.Component, java.lang.String, int, java.beans.VetoableChangeListener)      boolean oracle.dss.addins.wizard.configFileEditor.ConfigFileEditorWizard.run()      void oracle.dss.addins.designer.BIDesignerImpl.editConfigFile(int)      void oracle.dss.addins.designer.BIDesignerAddin.actionPerformed(java.awt.event.ActionEvent)      void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)      void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)      void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)      void javax.swing.DefaultButtonModel.setPressed(boolean)      void javax.swing.AbstractButton.doClick(int)      void javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(java.awt.event.MouseEvent)      void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)      void java.awt.Component.processEvent(java.awt.AWTEvent)      void java.awt.Container.processEvent(java.awt.AWTEvent)      void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Component.dispatchEvent(java.awt.AWTEvent)      void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)      boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)      boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)      void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Component.dispatchEvent(java.awt.AWTEvent)      void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)      boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)      void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)      void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)      void java.awt.EventDispatchThread.run()
2-     OLAP Connection uses exactly which driver i.e. thin or OCI8. Where r these driver files located?
3-      When i open Enterprize manager and try to view te cube using cube viewer. It first gives warning that
Materialized Views doesn't exsist . Data Loading will be slow Do u want to continue .
I Press YES
After some time it shows dialog, on which there is bell shape (i think error sign) and gives no error message and exits.
4-      This question is regrading OLAP Server Instance. Where does it exctly exsist. Because when i click OLAP option in Enterprize manager It doesn't show the option like starting or stopping the service etc (as described in its documentation some detail is given below). It just shows some help regrading creating cubes, dimensions etc.
5-      Installing Jdev903 + BI Beans
     I have copied or installed all the files of jdev903 in jdev home. Now when i try to install BI Beans into the home it still gives message that jdev9.0.3.0 or higher jdeveloper version not found..
Kaleem,
You posted this exact same message to at least 4 forums (OWB, OLAP, Data Mining, BI Beans), only the subject was changed. Your questions are not related to OWB or Data Mining at all.
If you are in doubt which forum to post to, just post to one forum. You will be directed by the person answering that forum to another forum if necessary. But please do not cross-post to multiple forums. This will not get you an answer faster but it consumes time of multiple people that could be spent instead on answering other users' questions.
Nikolai

Few Questions - Downloads

hello
Product Info: -
Oracle9i Database 9.2.0.1.0
Oracle9i 9.2.0.1.0
Oracle9i Patch 9.2.0.4.0
Oracle OLAP 9.2.0.1.0
Oracle OLAP Patch 9.2.0.4.0
Oracle OLAP Cube Viewer 9.2.0.1.0
Oracle OLAP Worksheet 9.2.0.1.0
Oracle OLAP API 9.2.0.4.1
Oracle OLAP Worksheet 9.2.0.1.0
{Oracle OLAP CWM Lite Patch 9.2.0.4.0 }
Enterprise Manager Base Classes 9.2.0.1.0
Enterprise Manager Translated Files 9.2.0.1.0
Enterprise Edition Options 9.2.0.1.0
Enterprise Manager Minimal Integration 9.2.0.1.0
Oracle9i Developer Suite 9.0.2.0.1
Oracle9i JDeveloper 9.0.2.822.0
Oracle9i JDeveloper IDE 9.0.2.797.0
Oracle9i Business Intelligence Beans 9.0.2.7.0
Information : -I have created dimensons cubes . I have deploed to OLAP and Analytical Workspace Manager and Loaded the data in AWM.Now I m working in jdeveloper
Problems: -
1-     I created workspace + project in jdeveloper. Now i create Business Intelligence --> Designer in the project. The BI Designer wizard starts and it ask me for OLAP Data Source (connection) . Now i create connection using JDBC + specifying my runtime target user + Using thin driver. The it searches for OLAP Server Instance and gives error that: -
java.lang.NullPointerException
     +
Failed to connect to the OLAP server Instance
     +
Stack Trace Shows:-
oracle.dss.addins.designer.OLAPSource$OlapSourceException: Connection information is incomplete, Service Name is not specified.      void oracle.dss.addins.designer.OLAPSource.checkConnectionInfo()      int oracle.dss.addins.designer.OLAPSource.test()      boolean oracle.dss.addins.wizard.configFileEditor.OlapPanel.testConnection(boolean, java.lang.String)      void oracle.dss.addins.wizard.configFileEditor.OlapPanel.btnTest_actionPerformed(java.awt.event.ActionEvent)      void oracle.dss.addins.wizard.configFileEditor.OlapPanel$3.actionPerformed(java.awt.event.ActionEvent)      void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)      void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)      void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)      void javax.swing.DefaultButtonModel.setPressed(boolean)      void javax.swing.plaf.basic.BasicButtonListener.mouseReleased(java.awt.event.MouseEvent)      void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)      void java.awt.Component.processEvent(java.awt.AWTEvent)      void java.awt.Container.processEvent(java.awt.AWTEvent)      void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Component.dispatchEvent(java.awt.AWTEvent)      void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)      boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)      boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)      void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Component.dispatchEvent(java.awt.AWTEvent)      void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)      boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)      void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)      void java.awt.Dialog.show()      void java.awt.Component.show(boolean)      void java.awt.Component.setVisible(boolean)      boolean oracle.bali.ewt.dialog.JEWTDialog.runDialog()      boolean oracle.ide.dialogs.WizardLauncher.runDialog(javax.swing.JDialog)      boolean oracle.ide.dialogs.OnePageWizardDialogFactory.runDialog(java.awt.Component, java.awt.Component, java.awt.Component, java.lang.String, int, java.beans.VetoableChangeListener)      boolean oracle.ide.dialogs.OnePageWizardDialogFactory.runDialog(java.awt.Component, java.awt.Component, java.lang.String, int, java.beans.VetoableChangeListener)      boolean oracle.dss.addins.wizard.configFileEditor.ConfigFileEditorWizard.run()      void oracle.dss.addins.designer.BIDesignerImpl.editConfigFile(int)      void oracle.dss.addins.designer.BIDesignerAddin.actionPerformed(java.awt.event.ActionEvent)      void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)      void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)      void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)      void javax.swing.DefaultButtonModel.setPressed(boolean)      void javax.swing.AbstractButton.doClick(int)      void javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(java.awt.event.MouseEvent)      void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)      void java.awt.Component.processEvent(java.awt.AWTEvent)      void java.awt.Container.processEvent(java.awt.AWTEvent)      void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Component.dispatchEvent(java.awt.AWTEvent)      void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)      boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)      boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)      void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)      void java.awt.Component.dispatchEvent(java.awt.AWTEvent)      void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)      boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)      void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)      void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)      void java.awt.EventDispatchThread.run()
2-     OLAP Connection uses exactly which driver i.e. thin or OCI8. Where r these driver files located?
3-      When i open Enterprize manager and try to view te cube using cube viewer. It first gives warning that
Materialized Views doesn't exsist . Data Loading will be slow Do u want to continue .
I Press YES
After some time it shows dialog, on which there is bell shape (i think error sign) and gives no error message and exits.
4-      This question is regrading OLAP Server Instance. Where does it exctly exsist. Because when i click OLAP option in Enterprize manager It doesn't show the option like starting or stopping the service etc (as described in its documentation some detail is given below). It just shows some help regrading creating cubes, dimensions etc.
5-      Installing Jdev903 + BI Beans
     I have copied or installed all the files of jdev903 in jdev home. Now when i try to install BI Beans into the home it still gives message that jdev9.0.3.0 or higher jdeveloper version not found..
Since we cannot answer technical questions here, I suggest you re-post to the product forums: http://forums.oracle.com/forums/index.jsp?cat=9
OTN

Categories

Resources