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
please help me out....
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?