Variant taking date sydate for scheduling

[Former Member]

Hello Gurus,

i want to create a variant in selection screen of Bex report

that take sys-date for a date variable

coz the reports here are scheduled for broadcasting daily and month end date

Now for this there is a feature in EP

to set a variant for query data selection for scheduling

My problem is this variant shud pick date dynamically so that user gets data for the date.

Can this b done any way around ?

[former_member205352 · Accepted solution]

If your requirement is broadcasting then you can create a variant and maintain date value in "RSRVARIANT" table.

Write a program to update this table on daily basis.

This works only in BI 7.

Hope this helps.

[Former Member]

Hi Sonal,

Use SAP Exit variable or

Create new Customer Exit variable and populate default value as current date.

[How to... Create & Populate User Exit variable |http://sapbwneelam.blogspot.com/2007/10/how-to-create-populate-user-exit.html]

Hope it Helps

Srini

[Former Member]

Why don't use the corresponding SAP exit-variable for actual date in your query? Then the varian woudln't be necesary.

[Former Member]

Hi

Yeah i agree that can b done simply b using SAP exit variable for current date.

but that will b fixed for every execution

i want this dynamic date only for variant as only for broadcasting scenario

Whereas other user can directly run the report with any date.

Edited by: Sonal Patel on Sep 25, 2008 8:22 AM

[Former Member]

Hi,

Your requirement is dynamic date. Try to work on offset on customer exit or SAP exit variable to get the dynamic date.