Publications are an advanced type of scheduling that enable us to distribute one or more reports to several destinations and in multiple formats.
The publications' unique quality is that it can schedule a report to run just one time and then distribute its data to different users but deliver to each user only the relevant data they need.
This is achieved by using personalization. Personalization is the process of filtering the data in the scheduled report according to its recipients and then distributing the report results accordingly.
For example, let's say we need to schedule and distribute the Revenue per Store report so that each store manager will get only his or her relevant data.
The report will run and retrieve all stores' data; however, before the data is distributed, personalization will take effect and distribute the data accordingly.
In this way, we have several advantages:
The report runs just one time. Running the report just once reduces the server and database load...