Concerns regarding creating dimension master items

[zhaohaifeng]

Hi All,

My concern was that, now we want to create the dimension to limit the data as below :

Month=if(I_Time_Key> v_Daily_MonthBegin_lastyear and I_Time_Key<= v_Daily_MonthBegin,ChooseMonth);

So if we want to used the dimension for the chart, whats the difference for

if(I_Time_Key> v_Daily_MonthBegin_lastyear and I_Time_Key<= v_Daily_MonthBegin,ChooseMonth)  or

Month ?

As my understanding, both of them are the same function, but as checked sometimes they are not same. May i know any different between them? Thanks.

Best Regards,

Haifeng

[MK9885]

Simply because 1st one is using IF condition and 2nd is just the field Month which is not even used in IF condition?