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
Cubeviews - Add blanks between Member expansions
Hello,
I hope you're all doing well, this is my first time posting in the forum.
I recently built a cubeview that contains one Row, I was wondering if there is a way to automatically generate blanks after each member - in my case after each Entity of the hierarchy - and considering that i have multiple member expansions.
In order to clarify my request, please find below an overall of how do blanks should be automatically generated (1st Screenshot), you will also find a screenshot of the members used in my cubeview.
Thanks in advance, wishing you all a blessed day
Not that I'm aware. You could maybe do it in actual reports, with Cube View Extenders, but not in Excel as far as I'm aware. The best i can think of is writing custom member list with some dummy "blank" member, then have a conditional format that will paint them "white on white" - but again, chances are it doesn't work when exported to Excel.
Obviously it works if you simply create multiple rows, one for each entity, and put blank rows inbetween.
2 Replies
- JackLacava
OneStream Employee
Not that I'm aware. You could maybe do it in actual reports, with Cube View Extenders, but not in Excel as far as I'm aware. The best i can think of is writing custom member list with some dummy "blank" member, then have a conditional format that will paint them "white on white" - but again, chances are it doesn't work when exported to Excel.
Obviously it works if you simply create multiple rows, one for each entity, and put blank rows inbetween.
Thank you Jack for your input, i came up with the same solution : by creating dummy "blank" rows (formatting them white on white), that shares the same member expansion as my entity rows, so as entitys with nodata or zeros gets suppressed alongside their blanks by doing so i managed to also avoid back-to-back blanks
