Hi All
If you can help me with getting around this using some mdx expression
that would be great.. If it can be solved by starndard time dimenstion,
that would be great too. I am running out of options to solve this
issue.

I have Fact table with following fields.


PropertyId Int
PropertyName varchar(100)
BuildDate DateTime
RentStartDate Datetime
RentStopDate Datetime,
SpecialFeatures bit,
DailyRent Money,
....
and other fields

I need to get the all the properties on Rent between any given dates
(with server time dimension). Rent stop date might be null and in this
case this should be counted too.
Right now i am facing problem in getting the counts of property with
Time Dimension hierarchy. If we drill down for a week, then the count
of number of properties on rent on that week should be displayed in the

cube.

I really appreciate your time and thanks in advance
Regards
Bala