TM1 Forum

Hello,
I have built a dimension with a TI process. It has 'Total Customers' as the Consolidated name. When 'Total Customers' is used in a view, it does not seem to add the data of the new customers added until I double click the Dimension and click "ALL".Then the new customers appear. Is there something that I can add to the TI to make sure all the hierarchies used in views are refreshed automatically?

telula wrote:Hello,
I have built a dimension with a TI process. It has 'Total Customers' as the Consolidated name. When 'Total Customers' is used in a view, it does not seem to add the data of the new customers added until I double click the Dimension and click "ALL".Then the new customers appear. Is there something that I can add to the TI to make sure all the hierarchies used in views are refreshed automatically?

Look in the documentation for the TI function
DimensionSortOrder(DimName, CompSortType, CompSortSense, ElSortType , ElSortSense);

Specifically, the ElSortType argument ByHierarchy.