Consolidated Excel Report into Books

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!