Adding static choice for Value prompt(cube based package) show error message:

[jd]

Hi I am working with cube based package.

In prompt page I have to get rid of value prompt first two lines(prompt name and dots line) using some java code I was able to do it.
And I am trying to add the static choice for 2 prompts first line to "show me all" text, when I add this text as static choice If I run the report it is showing below error:

OP-ERR-0217

      An unexpected type of parameter value was encountered. The specified parameter type is 'String', but the expected type is 'memberUniqueName'. Error processing filter 'members([LOGSSR CUBE2].[HSPName].[HSPName].[HSPName1]) in (?hspname?)'.


any Idea how to get rid off this error??

[MFGF]

Hi,

It sounds like you added a static choice based on a hard-coded string, wheras your dimensional prompt is expecting a MUN (Member Unique Name).  In your package view on the left, expand the hierarchy your prompt is based on, and locate the 'ALL' member at the top of the hierarchy.  Right-click this member in the package tree and select 'Properties', then from the Properties dialog, select and copy the Member Unique Name of the member.  Paste this value in as your static choice.

Regards,

MF.

[jd]

Hi MFGF,

I am getting all my MUN names in my value prompt but I have to add "Show me all" text as first line in my prompt.