Creates the following MDX:
SELECT NON EMPTY NONEMPTYCROSSJOIN([DockerRepo].[H1].[DockerRepo].Members,[Measures].[%COUNT]) ON 0,NON EMPTY [ImageType].[H1].[ImageType].Members ON 1 FROM [APPSIGHT_SIPHON_DOCKERPULL] %FILTER %OR({[Timestamp].[H4].[DayMonthYear].&[NaN] })
Notice NaN in the last filter element
evshvarov
commented
1 year ago
Creates the following MDX: SELECT NON EMPTY NONEMPTYCROSSJOIN([DockerRepo].[H1].[DockerRepo].Members,[Measures].[%COUNT]) ON 0,NON EMPTY [ImageType].[H1].[ImageType].Members ON 1 FROM [APPSIGHT_SIPHON_DOCKERPULL] %FILTER %OR({[Timestamp].[H4].[DayMonthYear].&[NaN] }) Notice NaN in the last filter element