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

OP-ERR-0115 The dimensions on the edge are inconsistent.

Started by pravin.cognos, 03 Jan 2012 12:47:07 AM

Previous topic - Next topic

pravin.cognos

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