Automating Time Variable Selection In Information Broadcasting

[DebjitSingha]

Hi All,

We have a requirement, where we need to broadcast alive report in Excel format. For this requirement we setup a PreCalculation Server (as we need to broadcast in Excel format). But till now users were using these reports with input ready prompts. Now while scheduling we can create variants for few variables, but not sure how to automate the selection of time fields (Fiscal year; Fiscal Period...).
As users wants those reports be have input ready fields we cannot replace time fields with Customer Exits.

Is there a way that we can automate the Time field selection during broadcasting.

Thanks,

Debjit

[former_member182346 · Accepted solution]

Hi Debjit,

Yes the automation is well possible using ABAP program which needs to be used in process chain before information broadcasting get triggered.

Please have a look at below document :

http://scn.sap.com/docs/DOC-11981

http://scn.sap.com/people/mohan.kotwal/blog/2011/05/08/how-to-schedule-bex-broadcasting-jobs-using-p...

Thank-You.

Regards,

Vinod Bokade

[Former Member]

Hi Debijit,

I have writen a blog on the same issue( to automate the change of the variable):

http://scn.sap.com/community/data-warehousing/netweaver-bw/blog/2013/04/04/automate-change-of-user-i...

Regards,

Saurabh

[former_member182470]

A perfect document for your case:--

http://scn.sap.com/docs/DOC-11805

[umashankar_poojar]

Hi Debjit,

          If user wants those variables as 'ready for input', you can go for customer exits with 'Ready for input' option checked for those variables at query designer.

Put your code under i_step = 1 and with 'Ready for Input' marked.

Those variables by default populate customer exit values and also user can override with their input.

Thanks,

Umashankar