About TI Function “DimensionSortOrder”

Post Reply
Niko
Posts: 55
Joined: Tue Feb 15, 2022 6:43 am
OLAP Product: IBM Cognos TM1
Version: PA 2.09 / TM1 11.7.00000.42
Excel Version: EXCEL 2019
Location: Asia

About TI Function “DimensionSortOrder”

Post by Niko »

hi guys, anyone know Is the effect of A and B the same when executed in TI process?
A:

Code: Select all

DimensionSortOrder (cDim01, ‘ByName’, ‘Ascending’,‘ByHierarchy’, ‘Ascending’);
B:

Code: Select all

CellPutS(‘BYNAME’, ‘}DimensionProperties’, cDim01, ‘SORTCOMPONENTSTYPE’);
CellPutS(‘ASCENDING’, ‘}DimensionProperties’, cDim01, ‘SORTCOMPONENTSSENSE’);
CellPutS(‘BYHIERARCHY’, ‘}DimensionProperties’, cDim01, ‘SORTELEMENTSTYPE’);
CellPutS(‘ASCENDING’, ‘}DimensionProperties’, cDim01, ‘SORTELEMENTSSENSE’);
Post Reply