How can automation be done for displaying a new company in query designer

[Former Member]

The report goes as mail to the user.He does not have the option of using the navigational attributes in that.In the columns there is restriction for different companies.So,every time a new company is added it should reflect in the report as well. Please tell me how can I automate this instead of manually adding restriction for the new company everytime.

[Former Member]

Murali

The report is going to the user only once.So,we dont want to send it again and again wherever some change occurs.

Amit

Can you please tell me that if 4 comapanies are getting added then the new column which I have added will give the data for all the new comapnies together. How will the user come to know that the which data is for what company.

[Former Member]

Instead of restricting column elements by company use company in columns as characteristic so that depending on the number of companies ...columns will automatically get created.

Rgds

amit

[hai_murali_here]

Hi Monika,

You can perform this using Broadcasting wherein there are options available to trigger the broadcasting(sending the reports) whenever the data change occurs in the Backend.It means whenever the new entry gets added/modifiedin backend,it will trigger the broadcasting so that the latest data will be broadcasted to the intended recipients.

You should have a Data Change event in a process chain and the corresponding query message in BEx Broadcaster to notify users (via roles) that the InfoProvider content has changed

Refer this link which will be useful for you

https://cw.sdn.sap.com/cw/docs/DOC-10157;jsessionid=7Shvbesq......AG2cIgA_SAP;saplb_*=(J2EE8941720)8...

Rgds,

Murali

[Former Member]

instead of including companies which you want..try excluding comapnies which you don't want..that way any new company by default would be added since it is not excluded in your selection.

rgds

amit