If I was your boss and asked you this simple question (because bosses always think all questions are simple), how would respond?
Preface: Ignore budget
Current infrastructure: SSAS 2008 on Hosted Server Win 2K8 R2 64bit
Client Access: VPN then RDP only
Trying to Avoid: RDP to server to run cubes.
Goal: Using only a VPN, get cube data to the customer.
Current Cube Solution: Launch HTML page and view cube data in pivot tables in IE. (like to continue this if possible)
Question:
I need to get our cube data out to our customers. What would you recommend that I do to allow the customer to access cube data via their desktop?
(Anything goes. I need help figuring out the best solution. SharePoint, IIS, Kerberos, etc.)