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
Solved
Quick View - Annotations/Audit Comments/Variance Explanations
Would like to check if Quick View in excel can extract/pull - Annotations/Audit Comments/Variance Explanations from "View" dimension.
Please assist. Thank you.
Pradnya,
A couple of questions:
- Are you sure that you have data for the intersection that you are looking at?
- Have you managed to view this data in a Cube View?
It might be helpful for you to change the row suppression settings on your cube view:
Hi Mark,
The row suppression settings on quick view worked.. 😀
Thank you very much..!
JackLacava
OneStream Employee
OneStream EmployeeJust switching to the right view should work; if it doesn't, there might be a regression and you might want to talk to Support about it.
Can you please elaborate when you say "Just switching to the right view should work"?
In View dimension we have "Variance Explanation", where user report/input variance explanation as text.
Hi Pradnya
Can you try moving the View filter to the columns then add both 'YTD' and 'VarianceExplanation'.
Send us a screenshot so that we can see the output.
Regards,
Mark
Thank you Mark.. we tried moving the View filter to the columns and added "YTD" & "VarianceExplanation", it did not work. Showing below result
Am i missing anything?
Pradnya,
A couple of questions:
- Are you sure that you have data for the intersection that you are looking at?
- Have you managed to view this data in a Cube View?
It might be helpful for you to change the row suppression settings on your cube view: