MDX query for Current Quarter, WeekNumber of the Month and DayNumberOfYear

Question

Hi Everyone,

For my Previous question, i got some replies those we met with my requirements. Thanks for that.

Please suggest me for the below requirement also.

With member
testnumber as
Year(Now())
select (testnumber) on rows,
[] on columns from [Adventure Works]

The above query will give the results of Current year. 

Similarly we need the following values also 

Current Day Number Of Year, Current Quarter number and Current Week Number of the Month.
Please suggest me how to find above three with seperate MDX queries like above query.

Thanks in advance

Answer 1

WITH    MEMBER WeekNoOfCurrentMonth As
	datepart("ww", Now())-datepart("ww", Now()-Format(Now(),"dd")-1)
	MEMBER QtrNo As
		datepart("q", Now()) 
	MEMBER DayNo as
		datepart("y", Now())
SELECT {WeekNoOfCurrentMonth,QtrNo,DayNo} on 0 from [Adventure Works]

---

vinu

Answer 2

Thank you Very much Vinu for ur quick reply.

It helped me a lot.