BEx Broadcasting through e-mail, using dynamic variant

[Former Member]

Dear SAP Gurus,

I'm new to SAP-BI, I came across the following situation:

I've a query based on which the reports are being generated.

My client wants to broadcast it every month, as they don't have any portal, so it has to be done through e-mail.

the query has 3 system variable which are FISCALYEAR and CALDAY, i dont remember 3rd.

So, I've to create DYNAMIC VARIANT, I tried the following procedure but its not working.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/9075b11a-6e43-2c10-b7be-cfa0e97ec...

please help me.

[Former Member]

Hi shivsam ,

1. What you need is dynamic filling the variant value.

2. In transaction SE38 enter the variant name

3.choose the attributes button.

4. Here you can set the field to u201Cselection variable.u201D

5.Then you can define something like SY-DATUM(4) for fiscal year and in the same way for calday SY-DATUM+6(2) .

Hope this will help .

Regards,

Jaya Tiwari

[Former Member]

thanks for help,

problem fixed....