I have a query on infocube which has Calweek.year as a time dimension. User want to enter calender day on selection variable and have it converted to specific calweek/year to display data from the cube. How can I do this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Add Calendar Day as another characteristic in your time dimension, then add a filter variable to your query for Calendar Day Range, but drill-down in the report by 0CALWEEK.
Hope this helps...