COGNOS BI REFRESH TM1 DIMENSION CACHE

Cognos BI in DQM mode caches all the TM1 cube metadata. But sometimes you need to be able to tell Cognos that I got new elements (common example you run import process which added new dimension elements). I tried to set “Use Local Cache” set to “No”, but it didn’t help. The problem was solved by adding RefreshMdxHierarchy to the Epilog of that import process:

RefreshMdxHierarchy('Forecast Version');
RefreshMdxHierarchy('Project');

and miracle – Cognos reads new versions and projects.

You can also use RefreshMdxHierarchy(”); to refresh all the dimensions.
This function updates the MDX hierarchies in a TM1 server without requiring you to restart the server. However in my case I don’t have custom named hierarchy levels and I don’t use }HierarchyProperties control cube.

Recent Posts

Recent Comments

Meta

Written by:

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *