I have attached multiple Cube views in one excel(Different sheets) through cube view connection.
Here, i want to pull that consolidated excel file into Books. how can we achieve it. can you please help us to sort out this.
Hello Shiva,
You cannot pull the consolidated excel file into a book, but you can pull the Cube views used to create consolidated excel file into the report books and create a consolidated report book in excel format. While creating a book you have an option to choose either PDF or Excel format. You can choose the output file type as Excel and save it as .xls and create a consolidated report book. You can add all the cube views needed in one report book to create a consolidated report book. You can use a loop if you are running for multiple time periods or multiple views of the same report. Hope this helps!
Hi ShivaPrasad
Please have a look at the Design & Reference guide on how to setup a Book. You can use your existing Cube Views as the source
https://documentation.onestream.com/8.4.0/Content/Design%20and%20Reference/Presentation/Books.html
Hope this helps
Sam
