Skip to Content
avatar image
Former Member

Report based on Calweek

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 12, 2015 at 10:05 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

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

  • Jan 12, 2015 at 08:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

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