Dear Gurus ,
I have to show the data in a cross tab as shown below.
Premium claims Reserves
Prd 1 10 20 10
Prd 2 15 10 25
Subtotal 25 30 35
(Prd1+Prd2)
ABC(Fact) 5 10 5
Total 30 40 40
(subtotal + ABC)
XYZ(Fact) 10 5 10
Grand Total 40 45 50
(Total + XYZ)
I have created the crosstab and every thing was fine till I added Total. I have manually calculated Total and Grand Total. When I add these to the report and validate, I am seeing the below error:
QE-DEF-0459 CCLException
OP-ERR-0025 The following OLAPPlanner internal error occurred: 'OPASSERT(itDim!=m_vDim.end()) in OPEdge::AppendTagExpr() at OLAPPlannerEdge.cpp:686'.
and when I run the page I get the below error:
OP-ERR-0115
The dimensions on the edge are inconsistent. A dimension of valueSet="17" is not the leaf on the first path.
I have given Total --> Solve order 1, Grand Total --> Solve order 2.
We are using Relational model.
How can this be achieved?? Please help !!
Cheers
Pravin