cancel
Showing results for 
Search instead for 
Did you mean: 

Converting date to Calweek

Former Member
0 Kudos

Hi All:

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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...

Bob