Consolidated Excel Report into Books

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!