Hi,
I am workign in DMR model. I have two dimensions Time_D(monthly, weekly and dialy) and product_D having level1 to level4.
I have a filter in my report having logic as below for monthly
case ?P_timeperiod?
when (1) then supply_demand_vw.yearmonth between ?P_startmonth? and ?P_endmonth?
else (1=2)
end
If I select product at level1.... the report is not showing result and keep on running for hours and hours.
So I changed the logic by dividing yearmonth column to year and month seperate as yearmonth is a calcualted column so adding this and checking the yearmonth might have taking time becuase of no of records are more.
1)
case ?P_timeperiod?
when (1) then supply_demand_vw.year between left(?P_startmonth?,4) and left(?P_endmonth? ,4)
else (1=2)
end
2)
case ?P_timeperiod?
when (1) then supply_demand_vw.yearmonth between right?P_startmonth?,2) and right(?P_endmonth? ,2)
else (1=2)
end
Now if I select product at level4 the report is not running. If I change to the old logic then report is working fine.
I couldn't understand how to fix this.... anyhelp please?
Please help on this. I am not able to figure out the problem.