Report not loading after making a division calculation on a member

[Manu0521]

Hi,
I am doing a calculation on my measure by dividing its value with a data item
so I create a dataitem with an expression
if(extract(month,current_date)=1)
Then(1)
Else if (extract(month,current_date)=2)
Then (2)
Else
(1)
But when using this my report keeps on loading. If I remove the division then it loads the data.

What could be the issue.

Thanks,
Manu

[MFGF]

Hi,
I am doing a calculation on my measure by dividing its value with a data item
so I create a dataitem with an expression
if(extract(month,current_date)=1)
Then(1)
Else if (extract(month,current_date)=2)
Then (2)
Else
(1)
But when using this my report keeps on loading. If I remove the division then it loads the data.

What could be the issue.

Thanks,
Manu

Hi,

This looks like an expression you would use with a relational source, not a cube. What are you trying to achieve here?

MF.

[Manu0521]

I am having column like quota . Usually this value is loaded as yearly value in cube.

If the report is run on feb 2015 ,its 8 month from fy 2015.so I have to show my quota value as ([Quota]/8) for that month
if its on march then ([Quota]/9)

Thanks,
Manu

[Manu0521]

is there an alternate for this expression
Case
when(extract(month,current_date)=1) then (7)
when(extract(month,current_date)=2) then (8)
when(extract(month,current_date)=3) then (9)
when(extract(month,current_date)=4) then (10)
when(extract(month,current_date)=5) then (11)
when(extract(month,current_date)=6) then (12)
when(extract(month,current_date)=7) then (1)
when(extract(month,current_date)=8) then (2)
when(extract(month,current_date)=9) then (3)
when(extract(month,current_date)=10) then (4)
when(extract(month,current_date)=11) then (5)
when(extract(month,current_date)=12) then (6)
End
I think it dint like extract or current_date .

Thanks,
Manu