Hi ,
I have a question regarding the generation of SQL Query of the analytical functions when it is used in the Coalesce Clause . case as below
Create a universe based on any table
Create a Dimension on the PK of the table
Create a Measure with any aggregate function
Create a dimension wich Coalesce a max (field#1 ) over(partition by field#2)
and
Min(field#3 ) over(partition by field #4)
then we should expect the Field # 2 and field #3 in the group by part of the generated query However we are only getting the first part of the Coalesce i.e Field #2 in this case
Does any one have a cluse how to fix this ?
Add comment