I am writing you because I would like to know our options to implement the following design with PerformancePoint 2010:
We have a data warehouse with the data from 50 branches of some company. All data is saved together in a single database and there is a column Branch_ID in the fact table. Branch_ID
tells us which of the 50 branches each record belongs to. We created SSAS cube from this data. The cube is on the server in our company.
Now we would like to offer HTTP access to this cube to all 50 branches of above-mentioned company and we think about using PerformancePoint 2010 and Excel services. Each branch
would connect to the dashboards and workbooks over the internet (not local network!) with web browser and see only the data that belongs to their branch. We would use the »software as a service« concept.