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