COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: Fly on 08 Sep 2007 08:07:25 PM

Title: Cash Flow using Actuals and Plan
Post by: Fly on 08 Sep 2007 08:07:25 PM
Hi,

I need to build a Cash Flow that combines Actuals with Plan data. In an Actual Month we would load the previous Closing Balance or current Openening Balance and that would then be used to proceed with the Cash Flow calculation.
If I use the @Feed BIF I can not use conditionals (like Closing Balance "IF Actual Month THEN @Feed with loaded openening balance, IF Plan Month THEN @Feed with calculated opening balance").

Rebuilding the @Feed BIF with @LAG is not possible because of circular reference.

Any ideas? Thanks.