Category Archives: Architect
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
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”.
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