Data is not coming correctly or being increasing

[Former Member]

Hi Experts,

I have issue in joining of tables.

I have SQL tables ffrom their I am fetching data in Web intelligence through Information Design Tool.

I have 2 face tables.

(1) Sales

(2) Invoice

Dimension Table:

As, Dimension Tables I have No, of Master tables which give me Description of different Field.

Now,

For that description I have join my tables as 2 fact tables are mapped with every Master table.

Ex:

Master table is Customer Grp.

then I have join Sales Fact table with Customer Group and Invoice table with Customer Group .

So,It was LOOP.

So to Resolve it I have Change My Master table with Sales as Short Cut join and Sales and Invoice Table is Connected with Short Cut Join and Master table and Invoice is Connected as left outer join.

Now, LOOP get resolved but getting wrong data.

So, please any one can suggest.

With Regards,

Chintan Vora.

[Former Member]

Hi,

Can you share a screenshot of the schema as it will help in understanding better?

When you say "wrong data", are you getting correct data but less rows (Loop behavior) or are you getting totally incorrect data (improper joining of tables)?

Also check the SQL generated and check if correct joins are in place or is there any unwanted join.

Regards,

Yuvraj