There are 7 reports . All of these reports are from the same Cube, genetrated and automtaically emailed each Monday in the form of an Excel Spreadsheet.
Can any one help how to merge the 7 reports outputs in an Excel spreadsheet and in a format provided.
Pinned topic How to merge analysis studio reports output in a single excel sheel
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-06T17:51:44Z at 2013-02-06T17:51:44Z by DanielWagemann
DanielWagemann 2700058MAJ850 Posts
Re: How to merge analysis studio reports output in a single excel sheel2013-02-06T17:51:44ZThis is the accepted answer. This is the accepted answer.In a report each defined page would go to a new tab in excel. You could copy all the report pages into a single report and give that a try. Obviously you would have to adjust the prompt behaviours if you have any defined.
Alternatively you could use event studio to send an email with the 7 outputs in a single email task. Not merged but beats getting 7 different emails.