Measure in Load Script

[robin_heijt]

Hi,

Anyone that can tell me how I can create a dimension from the following expression in my data load script?

It works fine as a master dimension, however I want it as a normal dimension.

=
IF(
	AGGR(
		IF(Count(DISTINCT {<Baseline=,[Adherence Filter]={'In Scope'},[OPR 2018] = {'4A'}, Name *= e({<Baseline=,[Adherence Filter]={'In Scope'},[Movement Type] = {'Promotion Band Up'}>})>} "Global ID")='1','Not Implemented'),"Global ID")
='Not Implemented','4A Not Implemented',

IF(
	AGGR(
		IF(Count(DISTINCT {<Baseline=,[Adherence Filter]={'In Scope'},[OPR 2018] = {'4A'}, Name *= p({<Baseline=,[Adherence Filter]={'In Scope'},[Movement Type] = {'Promotion Band Up'}>})>} "Global ID")='1','Implemented'),"Global ID")
='Implemented', '4A Implemented',

IF(
	AGGR(
		if(Count(DISTINCT {<Baseline=,"Adherence Filter"={'In Scope'},[OPR 2018] = {'1B'}, Name *= p({<Baseline=,"Adherence Filter"={'In Scope'},[Movement Type] = {'Termination Voluntary', 'Termination Involuntary'}>})>} "Global ID")='1','Implemented'),"Global ID")
='Implemented', '1B Implemented',

IF(
	AGGR(
		IF(Count(DISTINCT {<Baseline=,"Adherence Filter"={'In Scope'},[OPR 2018] = {'1B'}, Name *= e({<Baseline=,"Adherence Filter"={'In Scope'},[Movement Type] = {'Termination Voluntary', 'Termination Involuntary'}>})>} "Global ID")='1','Not Implemented'),"Global ID")
='Not Implemented','1B Not Implemented'))))

Thanks.

[dwforest]

Not without knowing the source SQL; basically you'll need to aggregate the data and put case statements.
May also do aggregation and if statements in subsequent RESIDENT load.