http://www.applix.com/rp/tm1_recommended_practices.htm
I would recommend:
- Protecting TM1 Excel Data Entry Templates and Reports
- Using Conditional Formatting to Identify Editable Cells in TM1 Spreadsheets
- Using MDX Parameters in Dynamic Subsets
Blog of IBM Cognos TM1, Cognos BI, Cognos Express, CDM and other related stuff.