Forum Discussion

Elorian's avatar
Elorian
Resolver I
4 years ago
Solved

Lookupvalue vs Data Model relationship --> Values not returned

Hello, I need help to understand a certain behaviour I remarked with LOOKUPVALUE. To make it simple, let's say I have 3 tables: a) Fact table : containing the list of requests of a ticketing tool,...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    LOOKUPVALUE will work fine between unrelated tables.  As soon as you link the tables (as you shoould, normally) your data model will limit the data in downstream tables based on applied filter context, search direction etc.

     

    LOOKUPVALUE should only be used in desperate scenarios.  Recommendation is to either use TREATAS for filter projections, or let the data model do the work.

lbendlin's avatar
lbendlin
Super User
4 years ago

LOOKUPVALUE will work fine between unrelated tables.  As soon as you link the tables (as you shoould, normally) your data model will limit the data in downstream tables based on applied filter context, search direction etc.

 

LOOKUPVALUE should only be used in desperate scenarios.  Recommendation is to either use TREATAS for filter projections, or let the data model do the work.