Using Coalesce With Two Analytical Functions

[former_member83847]

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 ?