Hi All,
We're facing a strange issue in the Prod environment.
We'd moved all the cubes and the pdata files from the UAT environment to the Production environment last week.
So now we have both - UAT & Prod - the environments up and running .
I'm not able to spread data (Relative proportional/Equal Spread etc.) on a few cubes on the Prod environment - it is giving me this error - "TM1 + Spreading operation has failed because the contents of the cell cannot be modified".
But I'm able to execute the same spreading in the UAT environment.
Please help.
Regards,
Deepu.
Spreading Issue in Prod environment.
-
- Posts: 29
- Joined: Tue Jun 22, 2010 4:01 pm
- OLAP Product: IBM TM1
- Version: 9.5
- Excel Version: 2007
-
- MVP
- Posts: 3702
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Spreading Issue in Prod environment.
Usually spreading would only fail because you have a rule affecting the area of the cube you are trying to spread on.
This would indicate that your UAT and Prod environments are *NOT* actually the same.
This would indicate that your UAT and Prod environments are *NOT* actually the same.
-
- Posts: 29
- Joined: Tue Jun 22, 2010 4:01 pm
- OLAP Product: IBM TM1
- Version: 9.5
- Excel Version: 2007
Re: Spreading Issue in Prod environment.
Thanks for your reply Lotsaram...But the environments are indeed the same at least in terms of the rules and the cube properties.
Also I deleted all the rules from the cube, saved the rules (after blanking out), and then recalculated the cube. Then i tried the same spread but I'm getting hte same error message.
Also I deleted all the rules from the cube, saved the rules (after blanking out), and then recalculated the cube. Then i tried the same spread but I'm getting hte same error message.

-
- Posts: 28
- Joined: Tue Jun 16, 2009 1:03 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.5.1
- Excel Version: 2007
- Location: India
Re: Spreading Issue in Prod environment.
You are getting this error "TM1 + Spreading operation has failed because the contents of the cell cannot be modified" probably becuase of the security rights given to those elements in the Production server. Check the security rights are set to write for all elements.