Forum Discussion

CathrynDelay's avatar
CathrynDelay
New Contributor
7 months ago
Solved

Cube View Cash Flow Report QTD or MTD

Our cube view cash flow reports were built using an account hierarchy and includes parent cash flow accounts to rollup base accounts.  The cash flow reports were originally built on a YTD basis.  Lat...
  • chul's avatar
    7 months ago

    I would guess that your base CF accounts are Balance account types rather than Flow account types. While changing them is an option, I can't suggest that it will fix your issue because I don't know your build.

    A second option would be to use the Flow dimension to help. There's a property called Switch Type which can be set to True. It looks at the account type (in your case, Balance) and switches it to act like a Flow account type when using that Flow member.