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

DImensional Error

Started by cognos05, 03 Feb 2015 02:02:52 PM

Previous topic - Next topic

cognos05

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

MFGF

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.
Meep!

cognos05

#2
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 ?

MFGF

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.
Meep!