I have 2 POS ODSs , one contains 26 weeks daily POS data and the other one contains 78 weeks of weekly POS data. The first one is at the POS Date level and the second one is at the week end date level. And my week starts on a Saturday and ends on a Friday. I have to bring the data from both the ODSs into my cube on a week end basis.
Can anyone throw in some thoughts, how I can achieve this.