SSRS Date parameter - current month from SSAS cube

i have ssas cube date dimension called posting period , have report parameter using date dimension show current month.

so far have worked out following expression which working(fiscal year calendar going may may) for the year component - can't figure out how work on quarter date part (and month) so as can see quarter , month hardcoded in below expression:

="[postingperiod].[posting period].[year].&[" + cstr(year(today())-1) + "].&[q4].&[10]”

any appriciated.

tx

hi hcmj,

in scenario, use expression
="[postingperiod].[posting period].[year].&[" + cstr(year(today())-1) + "].&[q4].&[10]”
set default value of parameter , use in mdx query, right?

if in case, can use expression below
="[postingperiod].[posting period].[year].&[2013].&[q" & datepart(dateinterval.quarter,today()) & "].&[10]”
set value on quarter date part.
, returns:

if have misunderstood, please point out , elaborate meaning of "but can't figure out how work on quarter date part (and month) so as can see quarter , month hardcoded ", can make further analysis.

regards,

---

charlie liao
technet community support

SQL Server  >  SQL Server Reporting Services, Power View