Skip to Content
avatar image
Former Member

Using Coalesce With Two Analytical Functions

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
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers