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.

[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