peformance problem with hierarchy

[venkiatmaruthi]

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?

[venkiatmaruthi]

Please help on this. I am not able to figure out the problem.