Excel formatting of TM1 reports.

[deepu_sree]

Hi All,
Presently we're generating reports in the user-required layout in this mechanism -
a) We decide which view of the required cube would give us the data for the report - by rearranging the dimensions according to the report.
b) We take a slice of the report which has the raw data - on to an excel sheet - intermediate sheet.
c) We've referenced the user-defined report fields to the intermediate sheet data.

By applying this approach, the excel gets "hanged"! For every click, it goes to a "stuck" state. Can you experts suggest an approach how to tune this?

Many Thanks!
Deepu

[lotsaram]

Presently we're generating reports in the user-required layout in this mechanism -
a) We decide which view of the required cube would give us the data for the report - by rearranging the dimensions according to the report.
b) We take a slice of the report which has the raw data - on to an excel sheet - intermediate sheet.
c) We've referenced the user-defined report fields to the intermediate sheet data.

By applying this approach, the excel gets "hanged"! For every click, it goes to a "stuck" state. Can you experts suggest an approach how to tune this?

From what you have written it seems pretty clear that you are brand new to TM1 as this is a very strange way of going about things!

However first things first, I am fairly certain that the Excel session is "getting hanged" on every click because Excel is in automatic calculation mode. When using TM1, Excel's calculation state should be set to manual this is very important for query and refresh performance.

Secondly, there is no need to have one sheet as a raw unformatted slice which is then referenced by another "report" worksheet. This is totally unnecessary. Part of the great utility of TM1 is the fact that it supports a worksheet function based query model. You can format the slice however you want, including but not limited to:
- changing cell formats such as font type, font size, cell colour, cell borders, etc.
- inserting or deleting rows or columns
- changing row, column and context filter elements
- inserting additional TM1 and/or standard Excel formulae
You can also combine data from multiple cubes or even write your own "slice" report from scratch.

I hope that helps get you going in the right direction...

[deepu_sree]

Thanks a lot buddy....now the performance is amazing... ...will explore the options that you've mentioned further...you almost saved me...many thanks to you....