Inefficient Attribute Retrieval from TM1 via MDX

Post bug reports and the status of reported bugs
Post Reply
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Inefficient Attribute Retrieval from TM1 via MDX

Post by mce »

Hi,

There is a bug with TM1's MDX engine about retrieving dimension attributes, which causes performance problems especially when reporting from Cognos 8 BI.
When querying for attribute info from a TM1 dimension, Cognos 8 BI uses .SIBLINGS function to query TM1 for the attribute data.
When TM1 is responding to the query, it sends attribute data for all elements in the same level as the element specified in the query, rather than sending it only for the required elements.
Cognos 8 BI filters the outcome to the ones required, but obviously by using extra time and server resources, and hence impacting the performance of the report negatively.
Especially in large dimensions, this makes report performance incredibly slow, and after a treshold, report does not even work at all as it crashes in BI bus.

APAR number is PM53674.

Regards
Post Reply