NULL handling while adding join while creating YF Views
7 January, 2015
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
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