Hi,

I would like to find the quarters (End Date) based upon the Year Parameter.
The MDX query is written as under,Plese check the commented block of the
query.

WITH
MEMBER [Measures].[ParameterCaption]
AS '[V Period].[EndDate].currentmember.MEMBER_CAPTION'
MEMBER [Measures].[ParameterValue]
AS '[V Period].[EndDate].CURRENTMEMBER.UNIQUENAME'
MEMBER [Measures].[ParameterLevel]
AS '[V Period].[EndDate].CURRENTMEMBER.LEVEL.ORDINAL'
SET [ForQuarter]
As
' [V Period].[AssignedYear - PeriodQuarter - PeriodMonth -
EndDate].[PeriodQuarter]'

SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue],
[Measures].[ParameterLevel]} ON COLUMNS ,
IIF(STRTOMEMBER(@Frequency).MemberValue="Yearly",
Tail([V Period].[EndDate].[Enddate]),
/*
IIF(STRTOMEMBER(@Frequency).MemberValue="Quarterly ",
descendants([V Period].[EndDate].[Enddate]),[V Period].[EndDate].[Enddate]))

*/
ON ROWS
From (SELECT(STRTOSET(@Year,CONSTRAINED)) on 0
FROM [Textile BI])



Thanks

Could you explain the [V Period] dimension structure, as also the intent
of the commented block, a bit better? There seems to be a Quarter level:

[V Period].[AssignedYear - PeriodQuarter - PeriodMonth -
EndDate].[PeriodQuarter]

But the commented code refers to a level which is presumably that of the
individual date:

[V Period].[EndDate].[Enddate]


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***