Following query pass year 2016 value from [Period] dimension to [Exchange Rate] Dim.
WITH
member YearX as
NONEMPTY(
[Period].[Operational Year - Semester - Quarter - Month].[Year].&[2016] ,
[Measures].[Targets - EdoxabanNetSalesTargets]).item(0).Properties("Key")
SELECT {[Measures].[Exchange Rate]}
on 0, non empty
(
[Exchange Rate].[From Currency].[From Currency]
, [Exchange Rate].[To Currency].[To Currency]
)
on 1 from [XXXX Cube]
where STRTOMEMBER( "[Exchange Rate].[Operational Year Key].[Operational Year Key].&[" +
YearX
+ "]")
No comments:
Post a Comment