Still no way to filter data in the SELECTINPUT prompt in DM advanced script.
Alternative - use VBA:
1. Get list of required members (using special hidden report or looping all members of dimension):
https://blogs.sap.com/2014/06/04/bpc-nw-10-vba-to-get-dimension-members-list-and-properties/
2. Use listbox in VBA form to allow user to select from the list mentioned above. TreeView control can be also used (more complicated).
3. Launch DM using VBA passing parameters to DM package:
https://blogs.sap.com/2017/06/16/simple-vba-function-to-pass-parameters-to-dm-packages/
If something is not clear - please ask additional questions!
Add comment