Skip to Content

Using Coalesce With Two Analytical Functions

Apr 23, 2017 at 11:37 AM


avatar image
Former Member

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)


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 ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers