question

Ken 2 avatar image
Ken 2 asked

SSRS / SSAS - parameter has no effect on my report

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
            )
ssasmdxparameters
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.