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
Incorrect Consolidation
- 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
Do you have any TM1 Rules in there?
Also check the Weights of these elements
Also check the Weights of these elements
Cheers!
Rizwan Kaif
Rizwan Kaif
- 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
Also, if no country is rule calculated, then check your feeders are correct.
Martin
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
Jodi Ryan Family Lawyer
-
- 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
Thanks for help, I had overlooked one issue in feeders before (weights are correct). It works now.
Stanislav
Stanislav