i added another fiscal year column in same table . it worked..

thanks..

sid:-)

Here's table structure and data

may be calculation works based on month

calculation1 as get month of feb to dec of year

calculation 2 as get january month of next...

I played with fiscal year option , i selected start date as Feb 1 2008 and end date as jan 1 2010.

after procesing dimension and cube. I selected...

i will try playing with time dimension wizard and i will post the result..

thanks guys

sid

but cant i do filter in my dimension, saying current year of feburary to next year of jan, using mdx..

but i have single table, which has three columns, year, quarter month and period key column.. i have to create a new table in database

as you said 1)...