Hello ,
I am currently developing my Cash Flow Statement and I want to add a condition for a loan account. If it has a positive balance in the Working Capital Requirement variation flow, I want to map it under one CFS table. However, if it has a negative balance, I want to map it under a different CFS table. How can I implement this condition in my Cash Flow Statement?
Thank you for your help .
The answer depends on how you are building your Cash Flow.
If using Dynamically computed members, you would simply check the loan account balance and if the sign is as desired then return the amount. You would do the same in each of the two Cash Flow destination accounts.
If you are using Formula Pass stored calculations in which formulas are attached to each Cash Flow destination accounts, you would need to do something similar as Dynamic calculations, where based on the sign of the source loan account balance, you decide whether to write it to the destination.
If you are using a common Business Rule stored calculations attached to the cube, then you can get the source loan account balance, and based on the signage write the data to the appropriate Cash Flow destination account.
If using stored calculations, there are a few more options that come to mind to accomplish this depending on how you are building the bulk of the cash flow and what sort of things you might be doing to improve performance and/or maintenance.
