If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Error when importing OLAP Data Source

Started by Taboka, 03 Jul 2007 08:07:58 AM

Previous topic - Next topic

Taboka

Hi all,

I am trying to add a cube that is already present Analysis Server into my model.When I run the Metadata Wizard and after selecting the data source,I get the following error:

MO-ERR-0028 The user starting the process doesn't have the correct privileges.

How do I check and correct these user privileges in Analysis Manager?

Thank you...

COGNOiSe administrator


hemudwh

I dont know it will be helpful or not but try these steps.

the Cognos 8 service needs to be started as a domain account.
the credentials for the datasource connection has to be "Cognos 8 service credentials"

Steps:

     1.  the Cognos 8 service needs to be started as a domain account.  If there is no domain to startup as, start the service as a domain using a local account:

        Example:
          username: .\local_user
          password: password

        Replace "local_user" with a local account user that has OLAP Administrator privileges
        Replace "password" with the proper password

     2.  Go to Control Panel/Administrative Tools/Local Security Policy/

     3.  Once there, go to Security Settings\Local Policies\User Rights Assignments and look for the policy named "Act as part of the operating system".

     4.  Add the local user to that policy

        Example:
          LOCALMACHINE\local_user

     5.  Create the datasource to the MS Analysis Services in either Cognos Connection or Framework Manager

     6.  Set the signon to be "Cognos 8 service credentials

COGNOiSe administrator

... the reason being that MS AS 2005 accepts ONLY Integrated Windows Authentication ... My 5 cents.