Dynamic Ranking and Count of Open Profiles by an effective Date

Hi,    I have a Fact table for the status of profiles that has a profilestatusid (the uniqueid), profileid (links to DimProfile table that has info about that profile), isopen flag and effectivedat...