0

Lookup Function returns NULL in dashboard ( generated SQL works in MV )

I have a lookup function:

lookup(

    R.Incorta_PeriodWeek.PeriodWeekEndDate, 

   R.Incorta_PeriodWeek.PeriodWeek, 

    $Incorta_PeriodWeek, 

    date(

        '1776-07-04'

    )

)

In my dashboard this returns NULL ( grouped column ).   If I snip the generated SQL and pop it into an MV it returns the correct row.   I did try hard-coding the input date instead of using the presentation variable but no luck there either.

 

Any ideas?   Or ideas on how to troubleshoot further?

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi R. A. Dawson Sr the first place I would check is the Analytics tenant log. If there's a technical issue the lookup is returning null, you will see it there (often it's just neglecting to have a key on the lookup column). Barring that, sounds like you are already on the path of narrowing it down by removing features (presentation variable). Next you might try the same with a query() function in a test session variable.

    Like
  • Thx - this is the SQL generated which returns the correct value in the MV...

     

    SELECT

                                (MIN(R.Incorta_PeriodWeek.PeriodWeekEndDate)) AS "min"

                            FROM

                                R.Incorta_PeriodWeek

                            WHERE

                                (R.Incorta_PeriodWeek.PeriodWeek = '2021P12W1')

    Like
  • Bah - first rule of anything to do with computers - turn it off and turn it on again ( or, in this case, bump the analytic services ).

     

    To be transparent ( and thankful Dustin Basil  ;-)  )  I also added a key to my Incorta table, but it didn't do anything until I bumped it. 

     

    On to the next thing!

    Like 2
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 3Replies
  • 10Views
  • 2 Following

Product Announcement

A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at community@incorta.com.