I have GL Table after i add sales table my curreny variable give wrong value

[paulyeo11]

Hi All

I have a data model , which is GL Table , and in order for me to provide more information to the GL Table , i add the sales Table , so that user are able drill in and get more information on sales from which customer.

After i add the sales table , i am not able to make use of my currency rate variable , as it does not work. it give wrong rate. Hope some one can share with me how to solve this ?

Paul

[paulyeo11]

To provide you more info , i enclosed below the data model before add sales table work fine one currency variable.

Below image shown after i add sales table , my currency rate not working :-

My issue is the may be due to i join wrongly , i should make the sales table inside GL table.

Hope some one can share with me how to join,

Paul

[jjordaan]

Hi Paulyeo11,

Do you realy need to join?

Can't you concatenate the sales table into the GL table?

[gandalfgray]

I think you may leave sales_table as a linked table,

but I suggest you replace "date" with "sales_date"  to break the circular reference

(use  date As sales_date

in your load statement)

Then you should probably have a separate salescalendar table linked to sales_table via sales_date

/gg

[er_mohit]

Try to use left join if your Gl_Table has more Gl_Code which are exists in sales_Table

So, for this you use Left join

if don't know try to use only join then your Sales_Table into Gl_Table.

hope it helps

[paulyeo11]

Hi Jeroen

I can not concatenate . Because both table field are different and I have 5 diff sales table and GL Table from diff country.

Any way thank you for yr reply.

[paulyeo11]

Hi Gan

I have already try what you mentioned on all the point. But I still cannot figure out why after add sales table it affect my vCurrency variable.

Thank you for yr advise.

[paulyeo11]

Hi eR

Thank you for yr suggestions.

I try left john csnnot work because it will make my file become very big.

Link should be right. But it affect my var on exchange rate.

[er_mohit · Accepted solution]

try to use left keep or right keep which you want

[jjordaan]

PaulYeo11,

What er.mohit is telling is also a possibilty.

I would use the Where exists functionality because that's beter from a performance point of view.