In BPC 10 NW, I need to show DIM(say, Entity) members in a list box. When the user selects an entity, I need to show the report based on that DIM member ID.
I am able to do the above using EPMDimensionOverride(). But, for this, currently, I am using ActiveX's List Box. ActiveX list box does not look nice.
Instead, I want to the form's Combo box which looks nicer. When I tried that, I am not able to go to the VBA code's editor when I double-click the control. How can I do this? i.e. to use form's Combo box in the Excel report/input form.
Thanks in advance for the help.