Hi All i have below requirement that For Each Item i have a regular capacity for begin effective date in the Dates table. Some times the Capacity will change for the same Item Number based on the Begin Effective date in the Dates table. Now i have a Fact table with Stock plan date for each Item Number. Here BGN_EFF_DATE and [Stock Plan Date] are not the same dates. But i want the BGN_EFF_DATE to be in the interval range of Stock plan date for each Item No . This will give me a way to combine my Capacity to that of Available Qty for given time period and Item No. Please see below attached QVW file.
Hi Massimo, Thanks a lot for your help.That document helps me a lot. The solution is very good. but only problem i have is the number of records in the table are bumping from 3 millions to 40 millions . Is that expected.