BPC 10 NW - How can I show DIM members in list boxes in the page axis?

[Former Member]

Dear All,

I am showing some DIMs in the page axis. How can I show them in list boxes? i.e. in the page axis, I need to show the DIM members in list boxes. Can you please tell me how I can do that?

Thank you!

Regards,

Peri

[former_member210696]

Hi Peri,

In your page axis, if you have more than one dimension member(using EPMOlapMultiMember), the report data will be summed up for all those dimension members.

Why do you want to create a list in page axis? If user wishes to change the member in page axis, it can be done using member selector window and the dimension members will be changed. If you wish to restrict users to certain dimension members for a page axis dimension, I think that should be catered using security.

Regards,

Ashish

[Former Member]

Thank you, Ashish.

Regards,

Peri

[Former Member]

Hi Peri,

You can use the EPMDimensionPropertyValue function to display the IDs, either in a cell, as comma separated string or as a drop down list. However, please note that you cannot use any filter for this.

Hope this helps.

[Former Member]

Thanks, Nilanjan.

Regards,

Peri

[Former Member]

Hi Peri,

You can have a dropdown (data validation list) for each dimension.  When users select dimension members, they have to hit refresh to see the data.

Hope this helps.

Vijay.

[Former Member]

Thanks, Vijay.

How can I show combo box from Forms control? I am able to do that using ActiveX list box.

Regards,

Peri