Date Dimension in Mondrian Schema

[sanjayraja]

Hi,

Working on a project where we generate the Mondrian Schema. It works well with basic MDX through calcite into Druid - however with more complex MDX - I have some challenges with how the date dimension needs to be setup. Any pointers ?

The query I am trying to execute is

With Member [Measures].[0] as IIF([Measures].[No Of Sessions]>0,1,0) Member [Measures].[1] as Aggregate({[Session Date].[Day].[2016-12-10].Lag(4):[Session Date].[Day].[2016-12-10]},[Measures].[0]) Member [Measures].[Repeat Users] as COUNT(FILTER([User].[User].Children,[Measures].[1]>1)) Select { [Measures].[Repeat Users] } on Columns From [Session Date Cube] Where { { [Session Date].[Day].[2016-12-10] } }

I have tried creating a dimdate in Druid and also tried by putting all the dimdate info inside the main table.

The above query just hangs and I do not get anything back from Mondrian.

PS: This works well in a Star Schema on Postgres

Please advise