Hi Everybody

I am facing a problem in OLAP regarding AS-On-Date. Please help me.
It's urgent.....

My problem is: I have one fact table with 4 columns: DataId, PeriodId,
Amount
I have one dimension table with 2 columns: PeriodId, PeriodEndDate

Now I want my cube to show all the data from starting up to the date
(periodenddate) as selected by user while it shows only
data from that period which is selected by user. The problem seems to
me that OLAP used inner join with equals (=) condition
while for my solution, it must use smaller than equals to (<=).

Is there any way to solve this problem.... Here I can assure that my
PeriodId will be in increment order as PeriodEndDate.
Any suggestion or help will be appriciated.....

Thanks

Ganesh