Dynamic Object Selection

[Former Member]

We are trying to give the end user with the option of selecting one KF from each Set 1 and Set 2. We are using the below logic for creation of 2 two prompts.based on the slected KF's the CKF at report would vary dynamically.

We have seen other thread on this forum and tried this syntax. let us know where are we goin wrong.

also, let us kinow if we have to set any properties or check any settings at CMC level to esnure MDX parser is working fine

<EXPRESSION>

(@Prompt('Select SET 1 KF','A:A',{'Billing Qty':'Measures.4HF0ZFS0SOCJ87WCZAWVD8TUM','Billing Qty SU':'Measures.4HF11PA9ZUPAVE9UWBR6237DQ','Gross weight':'Measures.4HF11PHYITB0E0TB25TIC563I','Net Value':'Measures.4HF11PPN1RWPWNCR7ZVUM74TA'},mono,primary_key)

</EXPRESSION>

<EXPRESSION>

(@Prompt('Select SET 1 KF','A:A',{'Billing Qty':'Measures.4HF0ZFS0SOCJ87WCZAWVD8TUM','Billing Qty SU':'Measures.4HF11PA9ZUPAVE9UWBR6237DQ'},mono,primary_key)

</EXPRESSION>

We are getting the follwing error while running it from WebI report.

A database error occured. The database error text is: The MDX query WITH MEMBER Measures.60F14E7C-1617-4863-AE,44,CB,4A,49,FF,5C,8B AS '

(Measures.4HF11PA9ZUPAVE9UWBR6237DQ

' MEMBER Measures.1BC82661-7867-4934-9F,CF,B5,57,E,60,B,C4 AS '

(Measures.4HF0ZFS0SOCJ87WCZAWVD8TUM

' SELECT { Measures.60F14E7C-1617-4863-AE,44,CB,4A,49,FF,5C,8B, Measures.1BC82661-7867-4934-9F,CF,B5,57,E,60,B,C4 } ON COLUMNS FROM ZTEST_KEN/ZTEST_KEY failed to execute with the error Invalid MDX command with '. (WIS 10901)

Please share yuor thoughts on this error.

Thanks

Praveen

Edited by: kpraveenk11 on Apr 13, 2010 7:50 AM

[Former Member · Accepted solution]

Hi,

There is an extra left parenthesis at the begining of the expression that generates the error: (@Prompt.

Here is a sample I used on an Infoprovider that works perfectly:

<EXPRESSION>
@Prompt('Select measure','A:A',{'Net value in statistics':'[Measures].[0D_NETVAL_S]','Open order quantity':'[Measures].[0D_OORQTYBM]'},mono,primary_key)
</EXPRESSION>

Regards,

Didier

[Former Member]

Yeah extra ( was the culprit. its working fine now.