Topic
  • 1 reply
  • Latest Post - ‏2013-01-31T11:03:09Z by Karnatikishor
Karnatikishor
Karnatikishor
4 Posts

Pinned topic Need to show 3 weeks ago revenue in my Cognos Report

‏2013-01-31T09:38:12Z |
Hi Experts,

In my Cognos Report i have to show 3 weeks Ago Revenue, 2 weeks Ago Revenue and 1 Week Ago Revenue. Report should execute based on the CampaignID along with the Rundate (CampaignID and Rundates are prompts in my report). The corresponding table have the below details

RunDate:23-Jan-13 weekno: 1 week_start_Date: 20-JAN-13 week_end_date: 26-JAN-13

week_Revenue: 50
Updated on 2013-01-31T11:03:09Z at 2013-01-31T11:03:09Z by Karnatikishor
  • Karnatikishor
    Karnatikishor
    4 Posts

    Re: Need to show 3 weeks ago revenue in my Cognos Report

    ‏2013-01-31T11:03:09Z  
    for the above we can do back end using the below expression for 3 weeks Ago Revenue

    SELECT WEEK_REVENUE FROM

    NT_PREPAID_TARGET_TAKERS
    WHERE CAMPAIGN_ID=919
    AND RUN_DATE='23-JAN-13'
    AND WEEK_NO=-3

    but i want exact function to use inside my Cognos Report.