I am building a dimensional crosstab. One edge is a tuple based on 2 prompt macros and an if statement. week and pmeasure are from value prompts, year is from an IF statement based upon a sting match from the week prompt:
Tuple name: Year Total
tuple(#prompt('P_Week')#, [Current Year] , #prompt('P_Measure')#)
The if statement passes through a a choice of data items that are dynamic year options:
lastChild([All Enrolment Years1])
lag( lastChild([All Enrolment Years1]), 1)
lag(lastChild([All Enrolment Years1]), 2)
The IF statement returns the member outputted from lastChild([All Enrolment Years1]) as a string! As I am building a Tuple, I get an error message as below. And my tuple is moribund..
I have built a simple tuple based on the data item that contains lastChild([All Enrolment Years1]) and it works perfectly..
Please help! How do I stop this happening?
OP-ERR-0182
Invalid parameter ''[Current Year]'' provided for 'tuple' at position '1' for 'dataItem="Year Total"'. This parameter is 'string' type but is expected to be one of the following: 'member'.
Hey Tim,
It could really help us help you if you posted the actual expression. You might have a typo somewhere that's messing everything up.