If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cross tab issue

Started by Nandini.t, 24 Nov 2011 11:38:44 PM

Previous topic - Next topic

Nandini.t

I have calculated data items for rows and calculated data items for columns also.

Rows calculations :
1st row, X= [section code] ='a1' and [product code] <> 'b2'
2nd row, Y= [section code] ='a2' and [product code] = 'b2'
so on

Column Calculation :
1st col,A=count([claim reference])
2nd col,B=count([Policu number])
3rd col,C=[Booked Paid Claims] + [Booked Reserves Claims]
4th col,D=[C] > 150000
so on

all columns and rows inserted in to the cross tab and while validating i am getting a validation error called

-<queryProblems>
-<messageFolder provider="CoordinationPlanner">
-<messageFolder maxSeverity="error">
<message severity="error"title="OP-ERR-0046 Unable to support query items from the same dimension on different report dimensions: {0}."type="executionStats">OP-ERR-0046 Unable to support query items from the same dimension on different report dimensions: <nodeRef ID="OPSummaryQuery::CheckQRDDimensions()"/><nodeRef ID="dimension="[MEASURES]"; edge="axis(0)"; edge="axis(1)""/>.

</message>
<message severity="error"title="OP-ERR-0046 Unable to support query items from the same dimension on different report dimensions: {0}."type="executionStats">OP-ERR-0046 Unable to support query items from the same dimension on different report dimensions: <nodeRef ID="OPSummaryQuery::CheckQRDDimensions()"/><nodeRef ID="dimension=""; edge="axis(1)"; edge="axis(0)""/>.

</message>
</messageFolder>
</messageFolder>
</queryProblems>


please let me knw the corrections i want to do to overcome this error..


Thanks

Nandini.t

please help me out....

blom0344

Quote
1st col,A=count([claim reference])
2nd col,B=count([Policu number])
3rd col,C=[Booked Paid Claims] + [Booked Reserves Claims]

These are calculations, everything else is not. I can imagine a crosstab with either column or row calculations, but not both. I am at a loss what you are trying to build. Can you give an example?