hi Gurus,
I have one Report Studio report (Data source: Cube). We recently moved to cognos 10.
There are almost 5 reports coming out of same cube.4 of the five reports are working fine in Cognos 10 but one report when moved to Cognos 10 Stops generating MDX and throws error.
Error:
"RSV-VAL-0010 Failed to load the report specification. OP-ERR-0182 Invalid parameter '[Factual Units]' provided for 'tuple' at position '2' for 'dataItem="GPC2 GCM Factual"'. This parameter is 'tuple' type but is expected to be one of the following: 'member'."
I have tried copying other reports from current prod (Version eight ) to notepad and ran them in cognos 10 successfully.Only this one again gives error in that process also.
Any one have any Idea what is going on here,
Thanks,
Hi,
My guess is that your data item reference is a calculated value, and you're going to have to explore a different approach to identifying the tuple you want. Basically tuple (in Cognos, at least) is the intersection of two dimensions (column & row).
Try this to troubleshoot, http://www-01.ibm.com/support/docview.wss?uid=swg21410525
Thanks,
RK
It sounds like you have a data item named 'GPC2 GCM Factual' that has a tuple expression. Can you post the full expression?
It looks like that expression references another data item named '[Factual Units]'. Can you post that expression as well.
Some of the earlier builds of Cognos 8 permitted expressions that were, um, shall we say "suspect in their correctness" to parse and execute. The syntax checking was tightened up - I think for the 8.3 release, and a little more for 8.4. I suspect that your expression is trying to treat Factual Units as a member or measure, when it is a value. You need to figure out what Factual Units is (and most likely how it is derived) and change the approach there so it ends up as a measure or member.
Cheers!
MF.
Thanks for direction tjohnson3050:
Here are more details:
Actual Error Message:
RSV-VAL-0010 Failed to load the report specification. OP-ERR-0182 Invalid parameter '[CM - Actual Units]' provided for 'tuple' at position '2' for 'dataItem="GPC2 CM Actual"'. This parameter is 'tuple' type but is expected to be one of the following: 'member'.
1.[GPC2 CM Actual] =tuple([Gross Per Cap 2], [CM - Actual Units])
[CM-Actual Units]=tuple([Actual Units], [CM])
[Gross Per Cap 2]=[Production Finance Cube].[ADI Reports].[ADI Reports].[RptRowID]
[Actual Units]=[Production Finance Cube].[Measures].[Calculated Measures].[Actual Unit Amount]
[CM]=[Production Finance Cube].[Time].[Time].[Month]->?Current Month? (Catches Prompt Value)
Thanks
MFGF,
Thanks for response.
What you said makes sense because it was working fine before. Seems they tightened rules which resulted in not allowing thing they allowed in version 8.
That expression is trying to do a tuple within a tuple. A tuple must reverence individual members.
You need to convert the value from the inner tuple to a member using the member function.
Thank you for tjohnson3050 .