The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
rpatel
10 months agoNew Contributor
View Member Issue on Cash Flow Report
Hi All,
I am working on a Cash Flow Cube View to show the beginning cash, ending cash, and change in cash (activity) in three separate rows. All the base cash accounts are under the new parents (beginning cash, ending cash, and change in cash) in an alternate account hierarchy for the Cash Flow. We are using the BegBal_Dynamic flow member from the Blueprint app for beginning cash, EndBal for ending cash, and Activity_Calc for the change in cash. Figures are flowing in, but for these accounts the columns have a view member set to Periodic, QTD, and YTD. The problem is that figures are not representative of the View member, that is to say that they are all the same on the ending cash. Below is a screenshot and the Cell POV for each of the members. I am happy provide any other screenshots or additional information to get a resolution on this.
Thanks in advance!
MTD (Periodic):
Cb#Batesville_Cons:E#LE_TOT:P#?:C#Local:S#Actual:T#2025M5:V#Periodic:A#End_Period:F#EndBal:O#Top:I#Top:U1#CC_TOT:U2#Product_Total_Core:U3#Reported_GAAP_Tot:U4#PayType_Total:U5#Initiative_Total:U6#None:U7#None:U8#None
QTD:
Cb#Batesville_Cons:E#LE_TOT:P#?:C#Local:S#Actual:T#2025M5:V#QTD:A#End_Period:F#EndBal:O#Top:I#Top:U1#CC_TOT:U2#Product_Total_Core:U3#Reported_GAAP_Tot:U4#PayType_Total:U5#Initiative_Total:U6#None:U7#None:U8#None
YTD:
Cb#Batesville_Cons:E#LE_TOT:P#?:C#Local:S#Actual:T#2025M5:V#YTD:A#End_Period:F#EndBal:O#Top:I#Top:U1#CC_TOT:U2#Product_Total_Core:U3#Reported_GAAP_Tot:U4#PayType_Total:U5#Initiative_Total:U6#None:U7#None:U8#None
1 Reply
- chul
OneStream Employee
If your account type on A#End_Period is a balance (ie. Asset, Liability or Balance), then your view won't have an impact on the amount that's shown.
Related Content
- 9 months ago
- 1 year ago
- 2 years ago