Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Dates - Creating an InfoObject with W/E Buckets

Hi Guys,

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?



Not what you were looking for? View more on this topic or Ask a question