Home Knowledge Articles IBM Cognos 8 BI Unable to Run PowerPlay Studio Report Opened in Report Studio
Follow us on Twitter


Countries

50.1%United States United States
7.6%India India
7%United Kingdom United Kingdom
5.1%Australia Australia
4.8%Canada Canada

Visitors

Today: 30
Yesterday: 111
Last Week: 3353
This Month: 9182
Last Month: 16191
Total: 382835


Unable to Run PowerPlay Studio Report Opened in Report Studio PDF Print E-mail
(0 votes, average 0 out of 5)
Written by Martijn Christenhusz   
Tuesday, 07 July 2009 18:56

Symptom
OP-ERR-0182 Invalid parameter '[T2549(non zero-suppressed on row)]' provided for 'filter' at position '1' for 'dataItem="T2549(zero-suppressed on row)"'.

Problem
When running a PowerPlay Studio that was opened in Report Studio using the Open with Report Studio command, the error appears.

Cause
This problem occurs when a parameter in a data item expression is of numeric type but the expected type is memberset. This may occur if the report contains a calculation to which zero suppression was applied.

Solution
To resolve the problem, in Report Studio, change the parameter's type from numeric to memberset. For example, the first parameter in the following expression is of numeric type.
filter([T2549(non zero-suppressed on row)],((tuple([cubes/0406Great Outdoors].[Years].[Years].[Years]->:[PC].[@MEMBER].[CONVERSION_DATE]) <> 0) and (tuple([cubes/0406Great Outdoors].[Years].[Years].[Years]->:[PC].[@MEMBER].[CONVERSION_DATE]) is not null)))
Changing the first parameter to the following changes its type to memberset.
member([T2549(non zero-suppressed on row)],'','',hierarchy([cubes/0406Great Outdoors].[Locations].[Locations]))

Comments

Please login to post comments or replies.
Last Updated on Saturday, 04 September 2010 18:55
 
 

Login

For more content en features!



CogKnowHow Newsletter

Season's Greetings


Receive HTML?

Polls

How many users are working on your Cognos environment?