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.