Cross tab error

[Nandini.t]

I have calculated data items for columns and few data items on conditions for rows.

Rows data items :
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



                            |  A   |   B  |  C  |
                   --------|------------------
                         x  |       |      |       |
                   --------|-------------------
                          y |       |      |       |




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

-<queryProblems>
--<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 know how to overcome this error..


Thanks

[Nandini.t]

someone pllll help me out...

[anilkumar]

Hi

Drop One by one Data Item Run The Report(FOR Eg: Ist Drop A col Run The Report Then 2nd Col Drop RunThe Report) then U can understand  where is the problem


i think Drop C Col  then u put a filter C> 15000

Regards
Anil K.marri

[blom0344]

Please don't create duplicate posts as you adressed this issue earlier on..

I don't think that it is possible to build the crosstab the way you intend.

My 2 cents would be to build the crosstab based on a union set:

Define a set for each value of the row

Example (for X; written out in SQL):

Code Select Expand


SELECT 'X' AS ROWTYPE,
COUNT(CLAIM_REFERENCE),
...
...
FROM
...
WHERE
(section code ='a1' )and (product code <> 'b2')


Create a union on the set of queries and use the dataitem ROWTYPE for the rows