TM1 Forum

hi all,
i want to import a cube view to the excel sheet,if we normally do the exporting it wil show us the normal Cube view in the excel without any formatting, formatting in the sense i need to add come colors an my excel should be a good looking report.so can anyone help me to import the data of the cube to a predefined formatted excel.

Thanks,

Jithin

You can use the Active Forms instead of using the Slice or Snapshot options

Active Forms does apply some formatting to the data in Excel. It also allows you to Suppress Zeros, Filtering, Data Spreading & Holding. You can also change the default formatting of the Active Forms. See the section "Formatting the Active Forms" in the TM1 Users Guide for details.

see this thread.
http://forums.olapforums.com/viewtopic. ... 72&start=0

And also read the manual!