IBM Support

How to build multiselect prompt using promptmany for DMR and cubes

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

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Studio","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1;10.1.1;10.2;10.2.1;10.2.1.1;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1039697

Document Information

Modified date:
15 June 2018

UID

swg21343004