I was hoping that you can help me, I am having some 'realtionship issues', where I have two fields both with difference pieces of data that I need for a particular product. When I create a key between them, I lose some data (possbile because it looks to be repeating data).
I have included an example of my problem, where currently the key has been commented out. But in weeks 2010.1 - 2010.10 there is data within Forecast for all these weeks, but within Data there is only information every other week. When I include the key, the information for weeks 2,4,6,8,10 vanish. I was wondering if you can help me resolve this issue, as I need to see this data in the chart.
You're help on this matter is greatly appreciated!!
You have both [BOM-Chart - FCS Year - Week] and [BOM-Chart - Timescale] years selected.
The combination of those two gives the result you have now.
If you only select 2010 on [BOM-Chart - FCS Year - Week] you do have the correct selection I guesse.
It is not vanished, but there are too many filters which filters out the most.
I don't know what way you want to filter things, but if you want to filter on the dates you could consider creating some sort of calander to select years (which is only connected to BOM-Chart - FCS Year - Week ?? ).
I'm not shure what is wrong, but i've seen that in the Forecast table there are weeks with ".x" and ".0x" in the Data Table there are only ".0x" Weeks.
