I have an ssrs against an ssas cube. i have paramterized the customers by the customer ID in the customers dimension.
I have the report created with the paramter showing but the parameter has no effect on the details of my report. If i choose the filter in the details section than no results will appear.
My mdx uses calculated member so i am not sure how or if it is having an effect on my report.
with
member [YTD Sales] as
Sum(YTD(),[Measures].[Case Equivalent]),Format_String = '0.00;0.00;0.00;0.00'
Member [PY YTD Sales] as
([YTD Sales], parallelperiod([TIME].[YMD].[Year], 1)),Format_String = '0.00;0.00;0.00;0.00'
Member [Difference] As
([YTD Sales] - [PY YTD Sales]),FORMAT_STRING = '0.00'
Member [Pct Chg] As
iif([PY YTD Sales]=0,null,([Difference] / [PY YTD Sales])) ,FORMAT_STRING = '0.00%;-0.00%;0.00%;\N\A'
--([Difference] / [PY YTD Sales]),FORMAT_STRING = '#.##%,#.##%;-#,#.00%;#%;\N\A'
select non empty {[YTD Sales], [PY YTD Sales], [Difference], [Pct Chg]}on columns,
non empty
([WHOLESALERS].[Wholesaler ID].members,{[PRODUCTS].[BRANDID],[PRODUCTS].[BRANDID].children},{[PRODUCTS].[PKGID],[PRODUCTS].[PKGID].children }) on rows
from [Retail Sales]
where tail(filter([TIME].[Month].currentmember.children,
Not ISEMPTY ([Measures].[Case Equivalent])
)
, 1
)
