TM1 Forum

I have a large xcelerator/excel report, 17 tabs in one workbook.

To disitribute the data from the xcelerator report, I currently have to copy and paste the data from the original spreadsheet into another spreadsheet as values.

So I run the report once, copy and paste all of the values and then save the spreadsheet.

Change one parameter, and then start all over again.

Can anyone point me in a direction re how I can automate this process, run the report and then click a buttom which will automate the movement of data from the original spreadsheet to a new spreadsheet. I also want to save the formatting from the original spreadsheet.

I want to make sure I start in a direction that has worked for others in the past.

thanks

You haven't been very clear as to what exactly the "parameter" is that is being changed but if it is a dimension element and you can cycle through a subset then the built-in "print report" function in the TM1 and Xcelerator add-ins is probably all you need. Are you aware of this feature?

The parameters are office locations, the 17 tab xcelerator report needs to be run once for each of 15 locations.

I will look at the print report function, but it sounds like it will print rather than create an electronic xls version of the report.

Don McC wrote:The parameters are office locations, the 17 tab xcelerator report needs to be run once for each of 15 locations.

I will look at the print report function, but it sounds like it will print rather than create an electronic xls version of the report.

Well that's where you would be wrong.