In BPC 10 NW, how can I accept input thru list box(Is is a FORM control and it is not an ActiveX control)

[Former Member]

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

[Former Member]

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.

[former_member190501]

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

[Former Member]

Thanks, Raju!

Regards,

Peri