Category Archives: Architect

Connecting to Alternative TM1 Server

If you’re like most of our clients you’ll have both a production and non-production environment for Cognos Express or TM1. It is not real obvious though how you switch servers from, say Production to Development, or Development to Test etc. Well here’s how you can easily change your TM1 login to point to a development, test or production server. Open TM1 Architect or Perspectives If in Perspectives (the Excel add … Continue Reading

This entry was posted in Architect, Perspectives, TM1 Admin. Bookmark the permalink. | Leave a comment

Spreading Error

You can’t do spreading from a rule driven intersection – it must be from a value that has a natural hierarchy.  So I tried to zero All Years from Current Forecast where I have a rule driving Actuals into historic periods in the forecast and I got an error saying the “Spreading operation has failed because the content of the cells cannot be modified”.

This entry was posted in Architect, Errors. Bookmark the permalink. | Leave a comment

“C” for Clear or Zero (all child values in a cube)

In TM1, what’s the easy way to zero all the values in a cube, or all the child values of a parent? Easy, open the cube in Architect, navigate to the total you want to clear out and press “C”.You’ll then be asked if you want to perform a ‘Clear’ operation.  Say yes and Zap. Gone. All zeros. Too easy! Just as an aside, you can’t do it to an intersection … Continue Reading

This entry was posted in Architect. Bookmark the permalink. | Leave a comment