Model not displaying Budget figures

[#1]

Hi All,

PFA

I have created a model which has 4 fact tables and few dimensions, I have used generic keys to join fact tables but it does not show me Budget and Sales figures  side by side.

Please assist.

Thanks

[sunny_talwar]

What is your dimension here? The only thing common between Budget and Sales is StockCode, TrnMonth, & TrnYear... If you have those as your dimension.... things will work as Sum(Budget) and Sum(Sales)... since nothing else is common, other dimensions may or may not work...

[#3]

Hi Sunny,

Diemnsions :

Products

Customer 

Area,

Branch,

and the four fact tables

[vinieme12]

it's because your %Bdid isn't associated with your %said

You need to revise how you are creating the link table

[sunny_talwar]

May be like attached

Left Join Budget into Sales table

[#6]

Ok thanks for the response, it looks fine but I can also concatenate them?

[sunny_talwar · Accepted solution]

LinkTable might work... but will have to link them on the StockCode, TrnYear and TrnMonth....