When selecting a cube in the TfrmConnectionDesigner form, the TcxComboBoxProperties.OnChange event for edtCube is set to edtServerChanged. This causes the cube list to be initialized every time the user selects a cube, so the user is unable to connect to a cube other than the first cube. Clearing the event from edtCube corrects the issue.
OLAP mode - The "OLAP Connection" dialog doesn't allow end-users to select a cube other than the first one in the Cube drop-down list
Answers approved by DevExpress Support
We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.
Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.
Hello Jon,
I have reviewed our 14.2.4 cxPivotGridOLAPConnectionDesigner.dfm file and see the following code there:
object edtCube: TcxComboBox Left = 104 Top = 104 Properties.DropDownListStyle = lsFixedList Properties.OnChange = edtDatabaseChanged
This means that the OnChange event for edtCube is set to edtDatabaseChanged, but not to edtServerChanged. Please ensure that you have not changed our code in this file. You can run our Setup in Repair mode to get the original sources if necessary. I am looking forward to your feedback.
You are correct in that I incorrectly stated edtServerChanged. This is still wrong. Build the OLAPBrowser demo, connect to an Analysis Services database, and attempt to select a cube other than the first cube in the database. When you select any cube, edtDatabaseChanged is called, which calls InitializeCubeList, which clears out and rebuilds the Cube combo box. So every time you select a cube in the dropdown list, the combobox refreshes and the first cube becomes the selected cube.
The edtCube.Properties.OnChange event is wrong and should not be connected to edtDatabaseChanged. Please correct your sources so I don't have to correct them on my end each time I install an update to ExpressPivotGrid.
Thanks
Hello Jon,
Thank you for your clarification. This assignment indeed looks incorrect, so I have forwarded this problem to our developers.