hi...i havent been able to get what i want; what i want is an MDX expression that will adjust itself to the time dimension to return the count of rows that have 'Active Sequence' in them. i have this in a form view for calculate, but it returns blank in the browser

[tblMember Elig dim].[Elig Status Desc].&[Active Sequence]

btw, this does what i want in SSMS

thanks a ton

drew

select

[Tblmember Elig Dim].[Elig Status Desc].&[Active Sequence] on columns

,nonempty

([Tbldate Dim].[Calendar].[Month]) on rows 

from [Enrollment]

but i cannot for the life of me figure out how to get this to be 'browsable' by the clients out there while adjusting for quarters etc, the way everything else does (but not off a custom calculation, off normal cube processing). So should i create the calculated column on the dimension in the dsv then make the dimension a fact dimension in the dimension usage tab against the existing eligibility measure group (it doesnt follow the appropriate business rule to make calculations)?
OR
just create a whole new fact in the dsv with the new int column and create my measure based on the calculated column duplicating the dimension relationships on the new fact? The distinction to be preserved, for those of you in the biz, is between a member month and a member's membership...the number of member months is the aggregate of each members membership, but who is a member this month depends on counting a text status value (which is why i want to coerce it to int...i have not had success with text measures).

thanks again