Improved member selection in query to TM1 Server when using multiple hierarchies

In previous releases of Planning Analytics, query member selection with multiple hierarchies could sometimes include unnecessary members, leading to inconsistent query performance.

As of Planning Analytics 2.0.9.4, members selection is now predictable and consistent, resulting in consistent query performance.

In some limited circumstances, you might encounter a query that exceeds the current MaximumViewSize server configuration setting. When this occurs, it is an effect of TM1 Server in 2.0.9.4 doing a better job of selecting the members for a multiple hierarchies query to guarantee consistent query performance. We are working to reduce the additional memory usage for these limited cases in an upcoming release.

If you encounter a query that exceeds the MaximumViewSize, the current work-around is to increase the MaximumViewSize value in Tm1s.cfg to accommodate the increased memory usage.

For details on the MaximumViewSize parameter, see https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_cloud_mg.2.0.0.doc/c_maximumviewsize_1.html.