Create a dynamic subset in TI with alias

[pobrouwers]

Hello,

I use this code to create a dynamic subset in TI

Code: Select all

###########################################
#         Create Dynamic Subset
###########################################

subsetName = operationTechno;
stringMDX = '{FILTER( {TM1SUBSETALL( ['| dimensionName |'] )}, [' | dimensionName | '].[Operation/Technology] = ' | '"' | subsetName | '" )}';

if(SubsetExists(dimensionName,subsetName)=0);
  subsetcreatebyMDX(subsetName,stringMDX);
endif;

That's work fine but I would like to see the alias in my dimension and not the item. The alias name is 'Lib'

An idea ?

Thx

[bihints.com]

add this line after your code:

Code: Select all

SubsetAliasSet(dimensionName,subsetName,'Lib');

[pobrouwers]

Thx
That's work