Skip to Content
avatar image
Former Member

Dynamic variable in Bex Broadcaster

We have a mandatory variable as 'Date' in the report. While creating the variant in Bex Broadcaster for sending mails daily - the date gets saved & remains constant. We need the date to be changed dynamically everyday when the mail is sent.

I would like to know how should I achieve this. Thanks. Helpful ans will be appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Feb 18, 2010 at 10:59 AM

    Hi,

    You would need to create the Date variable as Customer Exit.

    Populate the Date variable in CMOD by sy-datum or other logic, if u need. This will fix ur issue.

    Steps: 1. Make the Mandatory (existing variable) to Customer Exit

    2. Choose "Variable can be Input-Ready"

    3. Write your code in CMOD for I_STEP = 1 to populate the sy-datum

    If you do this, your existing variable will still be Mandatory, except the default value which will be shown in that is Current Date (Sy-datum). This should resolve your probs.

    Regards,

    Chathia.

    Edited by: Chathia_P on Feb 18, 2010 12:05 PM

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 18, 2010 at 11:01 AM

    Hi Shah,

    if i understand correctly, broadcasting is done daily and date should be changed to system date dynamically.

    if this is the case you can SAP Variable "0DAT", this will take current system date ane execute report (this will not prompt for variable value).

    instead of mandatory Date variable you can use 0DAT variable which is available on 0CALDAY, if not available install from business content and use it.

    Best Regards

    Edited by: Daya Sagar on Feb 18, 2010 12:01 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 19, 2012 at 04:18 PM

    Old topic but not solved. I had the same question and I found a link where the answer is clear :

    http://wiki.sdn.sap.com/wiki/display/BI/Broadcasting+With+Dynamic+Variables

    "In the Broadcaster there is no function to allow dynamic variables."

    "The only solution in this case is to create multiple settings to reflect the different variable values that are required."

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 04, 2013 at 05:49 AM

    Hi Jinal,

    Please check my blog will it useful to you

    Populate Yesterday's Date in BEx Broadcaster - Mail body or Subject

    Please check.

    Regards,

    Ganesh Bothe

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 31, 2015 at 12:26 PM

    Hello Jinal,

    I am facing same problem as that of yours. Can you please brief as to how you worked around with it ?

    Regards,

    Kaval Soalnki.

    Add comment
    10|10000 characters needed characters exceeded