Incorrect Consolidation

Post Reply
sbalaz
Posts: 20
Joined: Tue Jul 06, 2010 11:06 am
OLAP Product: Cognos TM1
Version: 9.4MR1
Excel Version: 2007
Location: Slovakia

Incorrect Consolidation

Post by sbalaz »

Hello everyone,

Do you have an idea what might cause the consolidation issue below? This is a snapshot of a cube view. MU Spain (MES) (elements: ..., 101724, ...) and Total Country (elements: ...,No Country,...) are consolidations.
1. You can see correct number in MU Spain, Total Country = 0,069.
2. In 101724, both Total Country and No Country, there is correct number = 0,069.

The question is how can there be 0 in MU Spain, No Country? When I trace calculation for MES Spain, Total Country, it showes the figure comes from No Country.

MU Spain (MES) Total Country 0.069
MU Spain (MES) No Country 0
(101724) Total Country 0.069
(101724) No Country 0.069

Thanks a lot for help.

Regards,
Stanislav
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Incorrect Consolidation

Post by rkaif »

Do you have any TM1 Rules in there?

Also check the Weights of these elements
Cheers!
Rizwan Kaif
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Incorrect Consolidation

Post by Martin Ryan »

Also, if no country is rule calculated, then check your feeders are correct.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
sbalaz
Posts: 20
Joined: Tue Jul 06, 2010 11:06 am
OLAP Product: Cognos TM1
Version: 9.4MR1
Excel Version: 2007
Location: Slovakia

Re: Incorrect Consolidation

Post by sbalaz »

Thanks for help, I had overlooked one issue in feeders before (weights are correct). It works now.

Stanislav
Post Reply