Dates - Creating an InfoObject with W/E Buckets
I have 'Pricing Date' in an DSO and I want to create a 'bucket' of weeks for a range of pricing dates. When the user runs the queries, they will have a variable to enter a range of Pricing Dates and the output will be the 'bucket weeks' for those dates eg. run for 30/10/07 - 21/11/07 and the report shows w/e 3/11/07, 10/11/07 etc with values below this.
I was thinking of a new InfoObject for 'Weeks' in the Cube, that will hold the w/e ending date, and will link to the 'Pricing Date' in the Transformation. Would this solution work and if so, can someone help me with the code?