SOURCE FILE?

[Anonymous]

Hi folks,

i have  3 tables called t1,t2,t3

table1:

ti:(fact table)

period

_geo

table2:

_geo

ntgeo

table3:

_geo

mgeo

here we have relation ship between table is _geo.

my question is  what is the source of mgeo? how to identify the source of field ?

table 3 is contains mgeo so source is table3? or fact table?

[alexandros17]

Table 3 as you say contains mgeo so it is the source table for this field but more generally if you need to identify sources do:

ti:

period

_geo

'ti' as source

table2:

_geo

ntgeo

'table2' as source

table3:

_geo

mgeo

'table3' as source

In more complex cases this flag "source" help you to identify from where the value come

Hope it helps