When building a report in Report Studio against a Cube or a DMR, if you modify the expression of a data item in
a LIST or in a CROSSTAB to put macro like :
#promp('pline', 'memberuniquename', '[RootMember]', '')# You will be able to be prompted to select a SINGLE value and submit it. But, if you wish to select multiple values and submit them all at once, you may create a prompt page, add a value prompt in the prompt page, set the 'Multi Select' property of the prompt to 'Yes' and modify the macro above to use promptmany() like the following : #prompmany('pline', 'memberuniquename', '[RootMember]', '')#
But, this will fail with the following error message when you select more than one item and submit.
a LIST or in a CROSSTAB to put macro like :
#promp('pline', 'memberuniquename', '[RootMember]', '')# You will be able to be prompted to select a SINGLE value and submit it. But, if you wish to select multiple values and submit them all at once, you may create a prompt page, add a value prompt in the prompt page, set the 'Multi Select' property of the prompt to 'Yes' and modify the macro above to use promptmany() like the following : #prompmany('pline', 'memberuniquename', '[RootMember]', '')#
But, this will fail with the following error message when you select more than one item and submit.
Modify the promptmany macro as follow :
#promptmany('pline', 'memberuniquename', '[RootMember]', 'set(', '', ')')#
That will add the MUNs of the items properly in the promptmany function.
No comments:
Post a Comment