Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want one scenario for Circular Reference ,
after loading the tables it will associate based on the primary key(comman key) ,
so the data model look like not well but how it show the bad results means wrong results can anybody give one scenario and any other disadvantages .
Thanks
Madhu
Follow this too
"Qualify" statement definitely help you to avoid synthetic key and circular reference
HTH
Sreeni
Thank u Sreeni,
I am not asking how to solve the circular ref , i am asking how to show the bad results .
Thanks
Madhu
Madhu - You might be aware that when you have common keys across dimensions, circular references will be formed... so the best example is have two tables, one with 100 rows and another with 2/3 rows of data and form a circular reference.
What you can observe with a circular reference is, your query may get data from table2 which has less rows and actually you might expect the result from table1 where you have good data.. because of loosely connected tables
Sreeni