MDX Query for Defualt Value in SSRS Parameter

hello everybody,

i new mdx , struggling come query works.  have a  ssrs report  filters week. need write query run last week default.

the query have cooked is:

with member measures.lastweek as
[time dimension].[report week].currentmember.lag(1)
select measures.lastweek on 0,
[time dimension].[report week] on 1
[sales]

this returns null value.

i have searched , searched internet answer have found nothing. appreciate help.

 

thanks.

hi jonny

 

you need associate numeric measure value query selecting (you can skip member declaration here, not creating new measure, referencing different week member), like

select measures.amount on 0,

[time dimension].[report week].[year].[2010].lastchild.lag(1) on 1

from [sales]

in example assuming [time dimension] user hierarchy , last member loaded dimension current week  (may not case in cube)

---

javier guillen

SQL Server  >  SQL Server Analysis Services