Forum Discussion

CathrynDelay's avatar
CathrynDelay
New Contributor
3 days ago

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.  Later the view parameter was changed to also generate cash flow reports on a QTD or MTD basis.  The QTD and MTD cash flow reports reflect the correct calculated movement of balance sheet accounts for the parent cash flow accounts, but still reflect YTD calculated movement for the base accounts.  Any income statement accounts included in the cash flow reflect the correct YTD, QTD or MTD amounts for the parent cash flow and base accounts.  OS Community - Does anyone have a similar cash flow report build including options to generate the report QTD or MTD and solved obtaining QTD or MTD balance sheet base account calculated movements?

Cube View

1 Reply

  • chul's avatar
    chul
    Icon for OneStream Employee rankOneStream Employee
    2 days 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.