Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends ,
I have a situation
I have basically 8 Tables which are linked 2 by 2 , you can ssee in below image
So in this case i have 4 different year field and different Month field ,
I just want 1 common year field and 1 common Month field .
For that i have tried to make link table for SIte, SubSegment,Segment,Corporate table , but it is making circular reference .
Please help me !!!!
Thanks
in order to build a common year or month for all the tables you should have common key between all the tables or atleast you should have a reference key which will help you to link all the tables. As per your inputs I am not able to see any common key to which is linking the tables. can you please share the same data so that we can analyse
Hi Agnivesh,
Post sample data. In case you don't have common keys, I recommend to create some pseudo column by autonumber function and get the tables connected..
HTH
Sreeni
jaaldurgam in this case we cannot assume the key rite? because how we will get to know which site is linked with which segment
Avinash - We will get clarity if we have the data. I was giving generic answer to connect between tables...
Correct me If I'm wrong
Sreeni
your rite, let wait for the data
Hi Friend ,
Please see the sample attached data ,
Here for PLFact sheet ,
I am loading 4 times same PLFact with different join condition ,
As per my data model i have shared earlier
We are making 4 Different chart to show the site wise , segment wise and sub segment wise and corporate wise.
Hi Friend ,
Please see the sample attached data ,
Here for PLFact sheet ,
I am loading 4 times same PLFact with different join condition ,
As per my data model i have shared earlier
We are making 4 Different chart to show the site wise , segment wise and sub segment wise and corporate wise.