TM1 Forum

Posted: **Fri Nov 04, 2011 10:37 am**

Hi all,

We know that By default, TM1 does not display the aliases.
Currently we are building 20 to 30 dimension which are having aliases. After creating the cube, we need to set the use aliases button in each dimension manually.

Is there any we can set use aliases on option for all dimensions.

Posted: **Fri Nov 04, 2011 10:57 am**

Have you tried the SubsetAliasSet function in TurboIntegrator? Assuming you have a default subset defined or a consistent naming convention for the subsets to assign a display alias to and a consistent naming convention for aliases then I think this would do exactly as you need.

This code snippet should do what you require.

Code: Select all

# loop through dimensions to set display alias
sDimName = '}Dimensions';
sSubName = 'Default';
sAliasName = 'Code and Description'; 
nCounter = 1;
nMaximum = DimSiz(sDimName);
WHILE(nCounter <= nMaximum);
  sElName = DimNm(sDimName, nCounter);
  IF( SubSt(sElName, 1, 1) @<> '}' & DimensionExists('}ElementAttributes_' | sElName) = 1 );
    IF( SubsetExists(sElName, sSubName) = 1 & DIMIX('}ElementAttributes_' | sElName, sAliasName) > 0 );
      SubsetAliasSet(sElName, sSubName, sAliasName);
    EndIF;
  EndIF;
  nCounter = nCounter + 1;
END;

TM1 Forum

TM1 does not display the aliases

TM1 does not display the aliases

Re: TM1 does not display the aliases