Create 1 calendar with 2 date tables

[pauldamen]

Hi,

I have a script with a fact table and a different table with amounts. De fact table is linked to the Amount table with a ProjectID.

Also linked to the fact table is a master calendar based on the date field in the fact table. Now I have a date field in the Amount table as well (DateAmount).

How can I get this linked to the master calendar as well without creating loops etc? I searched the forum but couldn't find an answer that would help me fix it.

Thanks for your help!

Regards,

Paul

[pauldamen]

Hi Rohit,

You can find my full file attached to the post of Muhammad.

Thanks for your help

Regards,

Paul

[MK_QSL]

Check enclosed file....

[arsal_90]

Please follow this document and i can't help if you don't provide the data.and you do the right thing but only you have to do is that in link part of your script you have to make flag and also comment date field in fact table. Hope this help

[mahesh_agrawal]

Hi,

Please go through the changes made in the Facts tab in the script.

I think it will solve your issue.

[pauldamen]

Hi,

Not yet, is still lot of sync keys in there

Please find attached

Regards,

Paul

[mahesh_agrawal]

Hi,

Please go through the changes made in the Facts tab in the script.

I think it will solve your issue.

Here I have droped ID and Date from Facts and AmountFacts table.

Now it will work.

[pauldamen]

Hi Manesh,

Thanks the structure looks good! But the output unfortunately not. If you look at the first tab of the dashboard (Prioritize) you see the listbox on the top left with a count, the total is 250 but I only have 50 projects so everything is times 5.

Also If you look at the table below you see every ID has 2 lines, one with the info and one with the budget (from the other table).

So something is not going correct with creating everything. Any ideas?

Regards,

Paul

[pauldamen]

Hi,

I think I al most have it. Structure looks good.

But for some reason it won't match all the keys from the fact table to the link table. It will only do when they are the same. This is because of the Left Join I think.

But how can I solve it?

Regards,

Paul

[pauldamen]

Any ideas guys?