Reports not displaying data when new metric is added 1

[talenx]

OK this is getting weird, I’m currently creating a report to display a list of items with the [qty sold] and the [weight] sold over a time period. Even with that set aside when i run this report with the following objects in the report "item | item code " the report returns all of the correct data. But when I add the new metrics [qty sold] and or [weight] in the report I lose close to 30 % or my data.


Table structure:

LU_ItemTBL
--------------------------------------------------
item_key | item desc | ect


Fact_ItemMovement
--------------------------------------------------
tdate| item_key | qtysold | weight | ect


Current report has the following fields

Item | item code |

i receive all of the correnct data...



Once I add the metric that i create from the Fact_ItemMovement table

Item | item code | qty sold | weight

I lose over 30 percent of my data...


Any suggestions would be great.
Thanks
talenx

 

[chael]

Try setting the metric join types to outer.
clear the cache.

The fact table may simply not have data for all items in the lookup table, and it is possible that the lookup tables are not complete...you could also specify an outer join on the attribute.

 

[talenx]

wow!!
you were right on the money...
after i changed the join type of the metric the report return all of my data.

thank you very much
talenx