Few more models
Rajeshwaran Jeyabal, August 02, 2017 - 6:06 am UTC
August 03, 2017 - 1:12 am UTC
:-)
Still not clear
Amit Saroha, August 02, 2017 - 4:35 pm UTC
Hi All,
The question still remain unclear:
We should use multiple table or we should use reference Models ?
In which cases reference models should be used?
August 03, 2017 - 12:58 am UTC
It *might* seem like this is the same as a join, but dont forget, a model query can *synthesize* data, ie, a table might have
YEAR
----
2000
2001
2002
but the model query could do something like:
dimension by year
my_measure[2017] = ....
so we have "invented" data on the fly. So we might want to use this synthesized data in some way to reference other data. A join *before* the model clause commences wont work, because '2017' doesn't exist. A join *after* the model clause might not work because we want to do calculations with the lookup data whilst doing our modelling.
True Master
Amit Saroha, August 03, 2017 - 2:38 pm UTC
This is what I was looking for, thanks for clarifying it.
Truly a Master ..!!