on 06-04-2013 8:06 PM
Dear All,
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.
Regards,
Peri
Hi,
For form control, you have to right click the combox box>Assign Macro>New.
Select New if the control is not assigned to any macro or select Edit if it is alread assigned to a macro.
Hope this helps.
Regards,
Kalyan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can use EPMDimensionPropertyValues.
For more information on how to use this function check below video from EPM Academy
http://wiki.sdn.sap.com/wiki/display/CPM/EPM+Add-in+Academy
Miscellaneous Reporting -->Reporting using Dynamic Filters
Hope it helps..
regards,
Raju
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.