Concerns regarding creating dimension master items

zhaohaifeng — Thu, 08 Nov 2018 07:20:11 GMT

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

Re: Concerns regarding creating dimension master items

MK9885 — Tue, 20 Nov 2018 15:44:10 GMT

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