Skip to Content
author's profile photo
Former Member

Broadcaster is not refreshing the value !

Experts !

there is a date variable in my query's variable screen. So each time when u run the query , first the screen pops up where we enter variables.

This date variable is designed in such a way that its "Ready to input" also it has default value, which is thry customer exit. and it by defaults calculates systum date - 1 ( thru i step = 1).

Now, my problem is.. if users saves this report, and open it tomm. this variable is not refreshed again.

also, thru brodcaster, if they schedule for email once every week it sends the report with the original date ( when it was created / saved and scheduled ).

is there any other settings do i need to do ?

thanks..please help

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • author's profile photo
    Former Member
    Posted on Feb 01, 2011 at 12:07 AM

    make the date varaible dynamic ( or default) according to your requirement.

    For Example if you want to run a sales report for yesterday, use CALDAY variable in your report . based on system date always go back one day and default the date. and also make sure the variable as mandatory entry.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Feb 01, 2011 at 05:42 AM

    Hello,

    Looks like you have given some date in "General Calculation" tab in Broadcasting Settings in portal. Just clear any manual value you have given. While running query will automatically pick the default value of the variable.

    I hope this will solve your problem.

    Regards

    Aman

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Feb 01, 2011 at 09:42 AM

    Hi,

    The customer exit will not run every time the report is broadcast. the variable values are stored in a table while scheduling the report and the broadcaster reads the values from that table only. Below Article provides a very good solution for this issue.

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20d671c6-b377-2d10-7488-b75841c389a3?quicklink=index&overridelayout=true

    Best Wishes,

    Mayank

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      In the same z program you can update all the broadcast settings.

      By saved reports, I think you mean bookmarks. This solution doesn't work for that. And Customer exits with i_step 1 doesn't get executed for bookmarks as well. So, I don't know how to make this work for them. If you find the solution let me know as well.

      Regards,

      Mayank

  • author's profile photo
    Former Member
    Posted on May 05, 2011 at 03:13 PM

    Does anyone has the solution... ?

    please help Or let me know, how you handle such type of problem .

    thankx

    Add comment
    10|10000 characters needed characters exceeded