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
Excel interface.
-
rkaif
- Community Contributor
- Posts: 328
- Joined: Fri Sep 05, 2008 6:58 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.1 or later
- Excel Version: 2003 or later
Re: Excel interface.
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.
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.
Cheers!
Rizwan Kaif
Rizwan Kaif