Report based on Calweek

[Former Member]

Hi All,

I have seen many post in scn regarding week conversion from date, but i have this requirement that i struck upon.

In my report i have 2 manual entry variables called "Planned week from and planned week to". Here the user enters from week number say '21' and To week number say '24'. So then the data executed should be between those 3 weeks.

In my modelling i have calday and if i map it to calweek or i use a FM DATE_GET_WEEK i will get week number like 21, 22 etc. But as i have only one week number field, how do i create 2 user entry variables from calweek like "from week" and "To week".

Thanks,

Karthik

[KodandaPani_KV · Accepted solution]

Hi,

not required for the FM - DATE_GET_WEEK

source have 0CALDAY you want report have with 0CALWEEK

add the 0CALWEEK object in to under time dimension map the form source to taget.

source - 0CALDAY - taget - 0CALWEEK-  system automatically derived weeks form the day.

after completing the data check the 0CALWEEK filed data.

Thanks,

Phani.

[Former Member · Accepted solution]

Hi Phani,

Thanks for the response.

As u said i can get calweek from day by simple mapping. But in my report as i said, i have two user input variables, "Planned week from" and "Planned week to". where user enters week numbers like 21 in 'from week' and 25 in 'to week', As i have only one field 0calweek, how can i create 2 user input variables?

Thanks,

Karthik

[Former Member · Accepted solution]

Hi Krishna,

Create two variables as single values. In restriction select "Value Ranges" and select between. give two variables.

When input he can give two values and gets the required output.

Thanks

[KodandaPani_KV · Accepted solution]

Hi,

you can create variable with values range.

create the variable on the 0CALWEEK  -> give the value ranges -> select the mandatory option.

now run the query give the 21 in 'from week' and 25 in 'to week'

now you will get the desired report.

Thanks,

Phani.

[former_member186399]

Dear Karthik,

Are you already punching the calweek in the data target or you have only calendar day for meeting the above requirement

Regards

Gajesh

[Former Member]

Hi Ganesh,

I have calday coming from source and i am planning to convert it to week in my target by using a FM at transformation so that i get week number.