If you are unable to create a new account, please email support@bspsoftware.com

 

Value prompt checkbox multiselect not working on dimensional data

Started by manow.dowlut, 04 Nov 2013 06:12:30 AM

Previous topic - Next topic

manow.dowlut

Hello,

I am facing the following issue:

1. created a value prompt set to multiselect
2. Added static choice ( 3 choices reading MUN value)
3. on page explorer added a slicer , to allow multi selection on prompt using 'promptmany' syntax:

Expression:

set(#promptmany('invoiced', 'memberuniquename', '[Sales].[Invoiced].[Invoiced].[Service RevenueType Code]->:[PC].[@MEMBER].[Sales]','','[Sales].[Invoiced].[Invoiced].[Service RevenueType Code]')#)

The following has also been tried:

#promptmany('invoiced', 'memberuniquename')# as detail filter



Problem:
When running report , user can perform multiple selection , but the page does not refresh

manow.dowlut