cancel
Showing results for 
Search instead for 
Did you mean: 

questions regarding settings in broadcaster

Former Member
0 Kudos

Hello gurus,

there are three very important questions that I want to ask from a practical point of view.

I would be as descriptive as possible.

Question 1

When I launch a broadcaster via a query designer, say I make the necessary entries to create a new setting for broadcasting this query, When I click on schedule, I get a new pop up asking me for how do I want to schedule this setting. There is an option says "Execution with Data Change in the infoprovider " and then there is a check box that has this infoprovider. My question is if I check this checkbox corresponding to the infoprovider, will the email be automatically triggered as and when the data is loaded. If yes, then in what case do we have to use the "Trigger DataChange event" in the respective process chain that loads the data.

Question 2

I schedule a report to be broadcasted to specific users, I have say 5 variants created for this report. This report is to be execute five times a week. Can I have it scheduled in such a way, that each time the report is triggered, there is a different variant that is selected.

Question 3

Do I have a way with the help of which only the newly loaded data is automatically broadcasted, but not the whole of report.if yes, please let me know.

Any help regarding any of these questions would really be appreciated.

Thanks and regards,

Sree

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos
Former Member
0 Kudos

Hi Ellora,

I appreciate your response, However, The first problem has been solved with this link. There are two questions still remaining. I tried searching for the same but in vain. If you or for that sake, if anyone has any idea about the second and the third question, please post here.

Regards,

Sree.

Former Member
0 Kudos

Hi Sree,

Answers to your questions.

Question 1

When I launch a broadcaster via a query designer, say I make the necessary entries to create a new setting for broadcasting this query, When I click on schedule, I get a new pop up asking me for how do I want to schedule this setting. There is an option says "Execution with Data Change in the infoprovider " and then there is a check box that has this infoprovider. My question is if I check this checkbox corresponding to the infoprovider, will the email be automatically triggered as and when the data is loaded. If yes, then in what case do we have to use the "Trigger DataChange event" in the respective process chain that loads the data.

Ans1 - No the emails are not sent on loading of data to that infoprovider. You would have to include the 'Trigger DataChange event' in the process chain to fire an event, on reception of this event all the broadcast setting scheduled to trigger with datachange in the inforpovider for which the event was triggered will execute, sending mails.

Question 2

I schedule a report to be broadcasted to specific users, I have say 5 variants created for this report. This report is to be execute five times a week. Can I have it scheduled in such a way, that each time the report is triggered, there is a different variant that is selected.

Ans 2 - I am not sure if there is an easy way to handle this.

There are two probable solutions however.

Find the base table for the broadcast settings where it stores the variants and write an ABAP to change the variant of the broadcast setting. Run the ABAP program each day in the background to assign a new variant.

Create one Variant and through ABAP program change the values stored in this variant each day.

The variant values are stored in RSRVARIANT for 3.x workbooks and RSRPARAMETRIZA for 7.x worbooks. You will have to modify values of this variant in the respective table through ABAP each day.

Question 3

Do I have a way with the help of which only the newly loaded data is automatically broadcasted, but not the whole of report.if yes, please let me know.

Ans3 - Are you compressing your request each day until the previous day. Then you could filter the query by request id not equal to blank to achieve this or build a DSO with the same structure as required by the query over the cube and load this DSO parallely. Delete the DSO each time before the days load.Build a query over this DSO and set it up for broadcasting.

Hope it helps,

Best regards,

Sunmit.

Former Member
0 Kudos

Hi Sunmit,

Thanks a lot for your answers man. I have now got solution to these questions.

thanks a lot again.

Sree.

Answers (0)