Data not Mapped Properly

[#1]

HI All,

Please find the attached data model. There is some issue with my model. I have mentioned the details in the QVW.

Some columns are not mapped so the values are zero for it.

Please help me where the mistake might have happened.

Let me know if you need any other details.

Regards,

Keerthi KS

[stabben23]

Hi,

the field S_Status is from your Salestable and can not be used in the straight table as a dimension, the Straight table is shown correct. S_status will only present data that is from your Sales table.

[#3]

HI Staffan,

what should i do if i need to show data for S_Status ?

Sales table is linked to Receivables through S_ID(Saleorder)

Regards,

Keerthi KS

[stabben23]

Hi,

When you use Left join in models it is important that you have a 1 to 1 relation, oterwise you will have problem when you aggregate in for ex straight tables. Maybe you need to use composite key. Your script is a little bit "messy", it will take a lot of time to figure out what can be changed here. Make some tablebox to find out what relations you have between field and values.