I am wondering if it might be possible to connect the pivot grid to the Analysis Service by utilizing a WCF Service. I know that there is that msmdpump/XMLA stuff out but that approach doesn't take care of proxy servers in between (authentication) and such. We had a scenario back then with a customer of us who wasn't able to bypass traffic for that solution.

We as the software vendors are about to create a solution which is wrapped by a WCF service but at this moment in time I do not have any idea how such could be accomplished.

I appreciate any idea or your thoughts highly.

Thanks,

Lars