Thanks dealdas for the reply.

It worked now. Basically, I had a wrong relation established between the dimension and the fact table. So, I deleted the fact table again along with...

I was trying this yesterday and it works fine in Rolap but not in Molap. I don't know why?

I am a newbie to SSAS, so I am not...

I have come up with a solution for this scenario. Its working perfectly. Also, it does'nt take too much of time unlike pivot table.

Since, I need the user to select...

Thanks for the guidance Ron.

Here is a better one.

create table order_rep (itemno varchar(10), mnth int, year int, ordermade int)

insert into order_rep values('ABC',1,2009, 5)

insert into order_rep values('ABC',2,2009, 6)

insert into order_rep...