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?
Dimension did not automatically show elements
-
Alan Kirk
- Site Admin
- Posts: 6647
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Dimension did not automatically show elements
Look in the documentation for the TI functiontelula 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?
DimensionSortOrder(DimName, CompSortType, CompSortSense, ElSortType , ElSortSense);
Specifically, the ElSortType argument ByHierarchy.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.