COGNOiSe.com - The IBM Cognos Community

Getting the below error:
Arithmetic calculations using members from different dimensions or hierarchies may not product the expected result.

First Column
Total(currentMeasure within set(Mar2014,Apr2014,May2014)

Second COlumn
Total(currentMeasure within set(children(2015))

Calculated column
Secondcolumn/ First Column

Thanks,
Nithya

Quote from: nithya1224 on 03 Feb 2015 02:02:52 PM
Getting the below error:
Arithmetic calculations using members from different dimensions or hierarchies may not product the expected result.

First Column
Total(currentMeasure within set(Mar2014,Apr2014,May2014)

Second COlumn
Total(currentMeasure within set(children(2015))

Calculated column
Secondcolumn/ First Column

Thanks,
Nithya

What you haven't told us is the structure of the package you are using. Are the month members in the first expression in the same dimension/hierarchy as the year member in the second expression?

MF.

Nope :( The members in the month from first column and Second columns is from different Hierarchy.

But still the calculations are performed and I get the correct result. Its a warning.

Is this not allowed ?

Quote from: nithya1224 on 03 Feb 2015 02:53:30 PM
Nope :( The members in the month from first column and Second columns is from different Hierarchy.

But still the calculations are performed and I get the correct result. Its a warning.

Is this not allowed ?

Since the members are in different hierarchies, it's a warning that you might possibly get the wrong result. It all depends on the stucture of the hierarchies. As you point out, it works - so you got away with it. :)

MF.