I was asked recently if it is possible to create HTTP msmdpump.dll (Per user identity) connection to an SSAS cube.
Microsoft have produced a White Paper by Edward Melomed, which covers the topic in SQL Server version 2005. However, the architecture is the same in SQL Server 2008, and you should be able to extrapolate from one version to the other.
I won’t repeat Edward’s excellent paper; instead, I’d like to refer you to his White Paper, which you can find here.
Like this:
Like Loading...
Published by Jen Stirrup
Jennifer Stirrup is the Founder and CEO of Data Relish, a UK-based AI and Business Intelligence leadership boutique consultancy delivering data strategy and business-focused solutions. Jen is a recognized leading authority in AI and Business Intelligence Leadership, a Fortune 100 global speaker, and has been named as one of the Top 50 Global Data Visionaries, one of the Top Data Scientists to follow on Twitter and one of the most influential Top 50 Women in Technology worldwide.
View all posts by Jen Stirrup