How to create a global report for global clientHello,
I develop SSRS report for a Client, who have office in nearly all regions.
Lets talk about two regions, EMEA and US/APAC.
As of now, we have different database server for different regions. Databases are nearly identical.
Now we are going to develop a global reports for a global client.
The first thing which comes into my mind is that, there should be a single database.
Please advice what are the others ideas ...