Hi,
I have my report server in Domain A and data cubes in domain B. I need to pass an explicit user id : B\wfadmin to connect to the data cubes and generate syn's.

Is this supported by the MSOLAP adapter?

I tried creating the B\wfadmin Id under Workspace --> Configure-->Access Control; but am unable to login to Web console as B\wfadmin
(!?!)--Report server runs with SECURITY=ON

What is the solution to connect to data cubes hosted in a different domain with security on?

Hi Rohit,

For questions in installations and configurations, please contact Information Builders' Customer Support Services and open a case for assistance. You may either call at 1-800-736-6130, or access the online system InfoResponse.

Hope it helps.

Cheers,

Kerry