Broadcasting issue- dynamic variables

[Former Member]

Hi,

I have a query that i use for broadcasting. This query has a dynamic logic picking up the current fiscal year and current month and mandatory inputs such as company code, controlling area which are available in the selection screen as shown below:

Now In broadcasting in MHTML format thru Email and also in xls format to portal, when giving the variable assignment- I need to give the inputs for the first 3 rows and i just click ok. But it's not changing dynamically - change comes every month.

I am not saving it as a variant either.. Shouldn't it dynamically change in the variable assignment?

And Do i need to check any option? What are these options in broadcasting used for - Only upon data change, Accessibility?

Please help.

[Former Member]

Thanks for your suggestions.. I shall try using the istep=2 logic..

Regarding testing for broadcasting dynamic values in development.. since the change comes every month... how do i test in broadcasting if i wanna check immediately if this dynamic stuff works?

[former_member199691]

in development system, in customer exit  give some fixed date and brodcast the report.

Now change the fixed date in exit and broadcast againg. This way you can test if broadcast is picking up the value from customer exit or not.

[hendrik_brandes]

Hello Joanne,

if you have build your customer exit, try to encapsulate your calculation logic for example with ABAP Objects as it is described here and use your own testing variant so you can easily test on a development system without influence your productive system.

I would suggest, to make one calculation method and derive a class from you base variable, to test several situations.

Kind regards,

Hendrik

[Former Member]

Thanks Gaurav and Hendrik.

[anshu_lilhori]

Hi,

Refer this link.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20d671c6-b377-2d10-7488-b75841c38...

Hope this helps.

Regards,

AL

[ravi_chandra3]

Hi

Whenever the precalculation server executes the BEx query or workbook , it will fetch the data from the RSRD_SETT_NODE_A table and not from the customer exit logic.

Hope you got it,

Regards,

RC

[Former Member]

Ravi,

So to fetch the data from customer exit logic.. how does it work?

This is the first time am working on broadcasting- so am greek to it.

[ravi_chandra3]

Hi joanne

Please refer the belowlink

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20d671c6-b377-2d10-7488-b75841c38...

make sure that whenever you broadcast the workbook / query, the precalculation server doesn't fetch the data from the customer exit.

Hope  you got it,

Regards,

RaviChandra

[Former Member]

Gaurav, The user wants the report to their inbox without having to input anything... So a selection screen is needed even if the user wants to check the query later..

Hendrik.. The first 3 rows- i have to manually input.. and 3 reports are delivered to the users.. as 3 plan versions exist.. company code and controlling area remain the same.. and the last 3 are dynamic variables which are customer exit variables written thru CMOD.

So Will this scenario work by creating a process chain?

[former_member199691]

you can try following:

- instead of using mandatory variables for 3 dynamic variables, use optional variables and write the code in i_step = 2 instead of i_step = 1.

If this does not work, you can create a copy of the main report which will be used for broadcasting. In broadcast report, last 3 dynamic variables can be kept as "Not Ready for Input".

Regards,

Gaurav

[hendrik_brandes]

Hello Joanne,

we have been facing a similar requirement and solved it through a customer exit variables, which get their values from a configuration table. This configuration table has been filled up each time, the broadcasting job has been planned.

In your case, you will have to define a process chain where the broadcasting job will be executed via the RSRD_BROADCAST_STARTER report. Before the execution the table will be filled.

Kind regards,

Hendrik

[former_member199691]

I believe that variable values are saved when you create broadcast setting. For variables values to change dynamically, you can try changing your variables to "Not Ready for Input" (in other words, dont keep these variables in selection screen). This way, variables should be calcualted everytime broadcasting setting is executed