COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: nachmanb on 27 Mar 2011 10:45:08 AM

Title: Error with Dimensional Report
Post by: nachmanb on 27 Mar 2011 10:45:08 AM
Hi All!

I have a report running off a cognos powercube.  I created  a member using the following that looks something like this:

member(total (currentMeasure within set [Account 6 and 7]),'total67','total67',[ERP].[Accounts].[Accounts])

I then tuple that member with another member from a different dimension and get a value.  So far so good.

The problem is when I want to take another value in the cube and subtract the above from it.  I then get an error that says:

The dimensions on the edge are inconsistent. The dimension of valueSet="93" differs from the sibling valueSets

Has anyone ever seen this or know what it means.  I'm on Cognos 8.2

Thanks in advance.
Title: Re: Error with Dimensional Report
Post by: nachmanb on 28 Mar 2011 02:38:18 AM
I figured it out.  The second value I was taking from the cube was just a regular old member.  If I wrap a tuple around it, the error goes away.