Print Page - Cross tab error

Title: Cross tab error
Post by: Nandini.t on 06 Dec 2011 12:12:45 AM

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

Title: Re: Cross tab error
Post by: Nandini.t on 06 Dec 2011 09:59:33 PM

someone pllll help me out...

Title: Re: Cross tab error
Post by: anilkumar on 07 Dec 2011 12:09:40 AM

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

Title: Re: Cross tab error
Post by: blom0344 on 07 Dec 2011 03:07:21 AM

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


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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Nandini.t on 06 Dec 2011 12:12:45 AM