How to do proper link of table in below script

[prma7799]

Dear All,

PFA file in that I have some query that I have to show Targets as YTD MTD QTD....

according to script my I did linking of two tables called FACT_GL_Entry with Targets. But I am unable to achieve YTD MTD QTD.

Please advise me.

Thanks

[Chanty4u]

did u chk dis

Set Analysis for certain Point in Time

YTD,MTD,FTD,QTD

[prma7799]

Hi  Chanty,

This is not helpful for me. Have you check my script. I think my table linking is not proper.

So I want advise on that...

Please see attached 

Thanks

[HirisH_V7]

Hi,

Can you post some sample of your fields then it will easy.

-Hirish

[prma7799]

Please find sample attachment

[prma7799]

Hi All / sunindia‌, Avinashelite‌ , jagan‌

anyone can help on

[Kushal_Chawda]

i think you are joining this QVD on two field just join on Div_Code & try to link the Target on Div_Code

join (FACT_GL_Entry1)
//DIM_Division_Master:

LOAD

Div_Code,
Div_Name as Div_name1
FROM
[..\Qvds\NAVQVDS\DIMQVDivision.qvd]
(qvd);

[prma7799]

Thanks Kushal

I will try and let you know.