COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: anilkumar on 15 Sep 2009 02:17:06 AM

Title: PLEASE GO THROUGH ATTACHMENT (URGENT)
Post by: anilkumar on 15 Sep 2009 02:17:06 AM
hI

As i attached document , iam unable to bring total, all values are not summing up
IAM NOT ABLE TO UNDERSTAND WHAT IS THE REASON

please provid the solution

Regards
ANIL K .MARRI
Title: Re: PLEASE GO THROUGH ATTACHMENT (URGENT)
Post by: jan.herout on 17 Sep 2009 02:59:39 AM
Please elaborate as the attachment is not there.

Quick hint (as something simillar happened to me long time ago).

Let's say that
- you have type 2 dimension with three levels A <- B <- C
- you have access table setting level B to NO DATA
- this would mean that A will always be zero, as NO DATA will tamper with formulas in the dlist