- 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
- 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.
- Open OBIEE Administration Tool.
- Create a new RPD (or open an existing one).
- Open Menu File--> Import-->From Multi-Dimensional
- Enter the url to the configured web directory “http://MyMachine/olap/msmdpump.dll”
- Hit Enter.
- The next screen should show a list of Cubes available in the server. (mine only shows the server name, no cubes under it)
- I hit Import.
- <I am getting an error in the Administrator server at this time.%gt
Thursday, August 14, 2008
OBIEE Connection to a MSAS 2005 Cube
Subscribe to:
Post Comments (Atom)
-
Sachin JainSys Inc. The basic out of box security available with OBIEE is via the administration tool. To administer the users/groups one... -
The primary method to move data to the Oracle ATP instance is by using Data Pump. You export data from your On-Prem database. Use the fol...
-
Sachin BuzzClan LLC Unlike 10g installation, which contained everything within the OracleBI and OracleBIData directories, the 11g i...
2 comments:
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)
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.
Post a Comment