TM1 Forum

Posted: **Thu Sep 11, 2008 12:21 pm**

Hello,

I use this code to create a dynamic subset in TI

###########################################
#         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

Posted: **Thu Sep 11, 2008 12:40 pm**

add this line after your code:

Code: Select all

SubsetAliasSet(dimensionName,subsetName,'Lib');

Posted: **Sat Sep 13, 2008 3:28 pm**

Thx
That's work

TM1 Forum

Create a dynamic subset in TI with alias

Create a dynamic subset in TI with alias

Re: Create a dynamic subset in TI with alias

Re: Create a dynamic subset in TI with alias