I have the following calculation working
without issue in a Dimensional Report (List):
- total (tuple ([Str Member],[Sls$]) within set([Cube Package].[Time].[Time] ->?parm_Wks?))
where [Str Member] is a single Store passed from a Prompt and ?parm_Wks? is a selection of Weeks from a multi-select Prompt.
[/list]
However, whenever I want to add a second similar calculation for example either:
- total (tuple ([Other Store Member],[Sls$]]) within set([Cube Package].[Time].[Time] ->?parm_Wks?))
OR simply changing the aggregating measure
- total (tuple ([[Str Member],[GP$]) within set([Cube Package].[Time].[Time] ->?parm_Wks?))
The prompt to select multiple weeks is now changed by default to Radio Buttons allowing only an individual week to be selected!!
Any thoughts would be greatly appreciated.
Thanks in advance,
Adam.
Are you using parm_Wks anywhere else?
Try changing the expression to:
total (tuple ([Str Member],[Sls$]) within set set(#promptmany('parm_Wks','mun')#))
I find macros much easier to understand that the prompt aliases.
Paul...
Thanks for your reply.
Interestingly, I am getting Parsing Errors on the calculation when I validate the report, but it appears to run successfully!!!!
As you suggested, I changed the calculation to:
total (tuple ([Str Member],[Net Sls$]) within set set (#promptmany('parm_Wks','mun')#))
And upon validation, I am getting the following:
QE-DEF-0260 Parsing error before or near position: 53 of: "total (tuple ([Str Member],[Sls$]) within set set ()"
QE-DEF-0261 QFWP - Parsing text: total (tuple ([Str Member],[Sls$]) within set set ())
Not sure what is going on, guess some additional validation is needed.
Thanks again,
Adam.
When you validate the report, you're not passing a valid mun to the parm_Wks parameter. When it prompts you, just copy/paste a member unique name from the hierarchy, and it should validate fine.
Thanks Paul....
I got it now!