I am using Analysis Server 2000, SQL Server 2000, and Win 2000. My cube is built using ROLAP without aggregates.

I would like to be able to run the SQL queries, generated from msmdsrv.exe, under the user's id, versus the service id or the hardcoded id that can be added when setting up a data source in Analysis Server.

Does anyone know if this is possible?

Ideally, I would like to use the ID and password submitted from the OLE DB for OLAP provider and in turn generate an ODBC connect string using the user's id and password. NT authentication is not an option, we are interested in SQL authentication or other native DB security.

Thanks for any suggestions.

Ed