Aggregation for the Periods to Year to Date in Forecast
I am having an issue with cash flow report taking last month's (ie Dec 2022) value to aggregating it to the year to date (ie 2022), ignoring other months (... Oct, Nov, ). Does the account type get a...
The example cube view looks like what would happen if your accounts are Asset/Liability or Balance.
Which may be OK because you might be looking at Balance Sheet accounts.
But the important thing for Cash Flow is whether the Flow member (the Flow type dimension) that you are looking at in that cube view. I assume you would be using a flow member that represents all the total cash-related movements. The critical point is on the flow member, if you are using a Balance Sheet account. Does the flow member has the "Switch Type" property set to TRUE?
