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

Friday, August 8, 2008

OBIEE Error GDO7WNZA

If you encounter this error, here is the check list.

1. Check the Oracle presentation Services. Is it Started?
2. If you are using IIS as the Web server:
The virtual directory created during the install may not be an application yet. Right click on the directory, and press the "Create" button. This will make it an application.
Restart IIS, and try accessing the link again.

-SJ

JainSys

What is Zero Trust Architecture?