Troubleshooting
Problem
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.
Symptom
QE-DEF-0260 Parsing error before or near position: 88 of: "[great_outdoors_company].[Products].[Products].[Product line]->:[PC].[@MEMBER].[2~239];" QE-DEF-0261 QFWP - Parsing text: [great_outdoors_company].[Products].[Products].[Product line]->:[PC].[@MEMBER].[2~239];[great_outdoors_company].[Products].[Products].[Product line]->:[PC].[@MEMBER].[4~237];[great_outdoors_company].[Products].[Products].[Product line]->:[PC].[@MEMBER].[3~238] QE-DEF-0260 Parsing error before or near position: 88 of: "[great_outdoors_company].[Products].[Products].[Product line]->:[PC].[@MEMBER].[2~239];" QE-DEF-0261 QFWP - Parsing text: [great_outdoors_company].[Products].[Products].[Product line]->:[PC].[@MEMBER].[2~239];[great_outdoors_company].[Products].[Products].[Product line]->:[PC].[@MEMBER].[4~237];[great_outdoors_company].[Products].[Products].[Product line]->:[PC].[@MEMBER].[3~238] RSV-SRV-0042
Resolving The Problem
Modify the promptmany macro as follow :
#promptmany('pline', 'memberuniquename', '[RootMember]', 'set(', '', ')')#
That will add the MUNs of the items properly in the promptmany function.
See attached sample example built on the "Great Outdoors Company" cube
Historical Number
1039697
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21343004