Need help Link Table!!

[#1]

Hi,

I really need help!

I have 2 facts tables : Sales & Budget and 1 store common dimension

The Grain of the Sales fact table is : YYYYMMDD and the grain of the Budget Table is : YYYYMM

I create a table link but my dimension time doesn't work. No datas for years.

Could you please help me ?

Thanks in advance.

[jolivares]

First complete the date for budget YYYYMMDD, where DD is first date of the month or the last, second when you make your expressions they should be by month not by day, so you have, i think dayly sales, but no the budget.

The link table try to make concatenating the values of budget and sales.

[kaushiknsolanki · Accepted solution]

Hi,

     Have a look at the attachment.

Regards,

Kaushik Solanki

[#4]

Hi,

Try the attached file

[#5]

Thanks Kaushik and Sampath.

Now, I see the construction. The method is particular but powerful !!

Many Thanks.

[kaushiknsolanki]

Hi,

     Kindly close the post by marking this as correct answer, if you got the solution.

Regards,

Kaushik Solanki