So we have Cognos 11.0.11 Reporting off TM1 10.2.2
We have implemented Element Level security within our TM1 department Cost Centre dimension. When we create a crosstab report that has 3 or more dims nested in the rows (plus measures) the TM1Serv service crashes (1 of 3 tm1 services, the Cognos service is not effected). Nothing in the TM1 logs, Cognos logs that indicate the issue.
After a bucket load of testing on our test server we have narrowed it down to the Filler (http://www-01.ibm.com/support/docview.wss?uid=swg21660287) {setting hierarchyUseFillerMember=True}
that you set within c11_install/configuration/xqe.config.custom.xml and then restart the Cognos service.
When this is set the service crashes on any of our three servers. When this is not set, i have successfully nested 9 levels on the rows without a crash.
I have also found an old IBM link that merely states a very similar if not the same, issue but no resolution. (http://www-01.ibm.com/support/docview.wss?crawler=1&uid=swg1PI76570). Currently following this up with IBM as well.
So my question is. Has anyone with a Cognos 11 setup running of a 10.2.2 TM1 back end with Element Level security (and the filler set) come across this issue of a crashing TM1Serv service and how did you fix it ?