How can I write an mdx query that slices by both a date range and dimension member value

pentaho / mondrian

Mondrian is an Online Analytical Processing (OLAP) server that enables business users to analyze large quantities of data in real-time.

http://mondrian.pentaho.com/

Other

1.14k stars 724 forks source link

How can I write an mdx query that slices by both a date range and dimension member value #1354

Closed 18516979324 closed 1 year ago

18516979324 commented 1 year ago

I need to write an mdx query that limits its results by the value of a dimension but also by a date range SELECT [Measures].[SUM] ON 0 FROM [Charge] WHERE {[Time].[YQMD].[Y].&[2018]:[Time].[YQMD].[Y].&[2022]} But it is an empty result set