Run is not happy with
[Dim Policy].[Pol Eff Date].CurrentMember.MemberValue >= Parameters!FromPolEffFullDate.Value
when I change to
[Dim Policy].[Pol Eff Date].CurrentMember.MemberValue >= CDate('1/1/2017')
it works
Parameter I tried datetime and text and everything
not sure i understand how Eval is done on that script
SELECT
NON EMPTY
{ [Measures].[Vwp],[Measures].[Inc Amt],[Measures].[Loss Ratio],[Measures].[Vep],[Measures].[EP Loss Ratio]}
ON COLUMNS, NON EMPTY { ([Dim Coverage].[Coverage Cd].[Coverage Cd].ALLMEMBERS [Dim Mileage].[Mileage Cd].[Mileage Cd].ALLMEMBERS [Dim Producer].[Producer Cd].[Producer Cd].ALLMEMBERS [Dim Program].[Program Cd].[Program Cd].ALLMEMBERS [Dim Zip].[Zip Cd].[Zip Cd].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_VALUE, MEMBER_UNIQUE_NAME ON ROWS FROM [pandl]
WHERE
(
Filter( [Dim Policy].[Pol Eff Date].AllMembers,
[Dim Policy].[Pol Eff Date].CurrentMember.MemberValue >= Parameters!FromPolEffFullDate.Value
and [Dim Policy].[Pol Eff Date].CurrentMember.MemberValue <= CDate('1/5/2017')
)
)