Skip to Content

Cal Day variable value stays static when Broadcasted

Hello - I created a report and I have a variable for Calendar Day (Single Value Entry, Required). When the user runs this report it works fine becuase they can choose the date on the variable screen.

BUT, when I broadcast the view of the query, the date stays the same as it was entered on the variable screen when I saved the view. I would like the broadcaster to choose today's date for Calendar Day instead of the view's saved value. How can I dynamically have that date populated to today's date when using the broadcaster?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 15, 2008 at 02:20 PM

    For broadcasting you need to save variants.

    These variants will be in RSRVARIANT table.

    You can write a program to update this variable with sy-datum and schedule the program before broadcast.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Praveen,

      RSRVARIANT will not work out as in BI7 variants will not be saved there what we create through BEx Designer(Broadcast) rather RSRPARAMETRIZA table keeps track of that (in field CONTENT in form of XML). Thus, we have to write ABAP code to parse that XML string (CALL TRANSFORMARION) or use some pattern matching technique (FIND statement)

      in order to make RSRVARIANT work, we have to migrate relevant BW7 objects to BW3.5

      Alok

  • Dec 23, 2008 at 07:09 PM

    No way around this. Must create program.

    Add comment
    10|10000 characters needed characters exceeded