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

tuhler's avatar
tuhler
New Contributor III
3 years ago

Fit Multiple Cube Views on Single Page in Book

I have a report book that loops through over 200 members and creates a new cube view for each member. The cube view is relatively short and I could definitely fit 2 on one page. Does anyone know of a...
Books
Cube View
Reports
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
3 years ago

One way to do that could be to have an Extensibility Rule that post-processes the file, effectively merging sheets in the workbook. You would have to be familiar with fairly advanced .Net programming though. Message me privately if you want to further explore that approach, or engage our AAS team through Support or Customer Success Manager, they will have a solution.

Another approach is simply to do that in Excel itself. A quick google surfaced https://www.exceldemy.com/merge-all-sheets-in-excel-into-one/. It starts with manual methods and progresses towards the more automated approaches like https://www.exceldemy.com/merge-all-sheets-in-excel-into-one/#Method-6_Applying_VBA_Code_to_Merge_All_Sheets_into_One.

Last but not least, if you think this is a feat that should be easier to achieve in OneStream, feel free to file it in IdeaStream.