SOURCE FILE?

Anonymous — Fri, 17 Oct 2014 11:25:57 GMT

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?

Re: SOURCE FILE?

alexandros17 — Fri, 17 Oct 2014 11:30:03 GMT

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