Forum

This content is now out of date.

Visit Our Community

NULL handling while adding join while creating YF Views

Hi,

Is there anyway we can handle NULL at the time of creating joins while defining YF views? As it stands, we can only select fields from the dropdown but can't add any other function or parameter.

We have a scenario where we want to join DATE_KEY of DATE_DIMENSION with DATE_KEY in the SUMMARY_FACT table to analyze Invoices related data. Point however is that SUMMARY_FACT.DATE_KEY contains NULL values for cases where Invoices are not yet present but we have Orders raised. In this instance, unless we handle NULL at join level, dataset being fetched by the query is not consistent yielding to underlying computed measures throwing up incorrect results.

Thanks,
Kishore

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.