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 b...
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