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

Cash Flow using Actuals and Plan

Started by Fly, 08 Sep 2007 08:07:25 PM

Previous topic - Next topic

Fly

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.