Thursday, August 14, 2008

OBIEE Connection to a MSAS 2005 Cube

  1. Configure HTTP access to SQL Server 2005 Analysis Services. - Use these links to configure your DB server to expose the Cubes using XMLA as webservices. For Win2003 For WinXP
  2. In the instructions, please make sure that the last step is done correctly. It asks to modify the ini file and change the server name of the MSAS db. it defaults to localhost, and if the db name is different then you need to change it to reflect that name. You may get an error "The specified module could not be found" if the server name is not correct.
  3. Open OBIEE Administration Tool.
  4. Create a new RPD (or open an existing one).
  5. Open Menu File--> Import-->From Multi-Dimensional
  6. Enter the url to the configured web directory “http://MyMachine/olap/msmdpump.dll”
  7. Hit Enter.
  8. The next screen should show a list of Cubes available in the server. (mine only shows the server name, no cubes under it)
  9. I hit Import.
  10. <I am getting an error in the Administrator server at this time.%gt


jchriste said...

Did you find a fix for this? I'm having the same problem not seeing the cubes, then if I hit Import the Admin Tool crashes. I believe it has something to do with the security configuration in the IIS properties set up to enable XMLA access to MSAS or the permissions of the Account I'm running the import as (although I've applied every permission I can think of)

jchriste said...

Yes, the problem was the IIS detault account permissions. Make sure that account has permissions on the domain as well as full read permissinos in SQL Server. Once we fixed that we were able to see the cubes and proceed without any issue.