Attempting to hook C8 into an MS OLAP cube (SQL Server 2000 Analysis Services).
Can correctly set up the connection in Cognos Connection using domain admin/password as the signin credentials and test the connection successfully.
However, Framework Manager gags with a
"MO-ERR-0028 The user starting the process doesn抰 have the correct privileges"
when attempting to select the tested data source...
Anyone succeed with this yet?
How can I use MS OLAP cube in c8
Hi,
I did this on my laptop by changing my Cognos 8 service to log on as a user defined as a member of the OLAP Administrators group. In my data source definition from within Cognos 8, I then used the option to signon using the Cognos 8 service credentials.
Best regards,
MF.
There are 3 ways for connecting to the cube:
1. Using the user that's running the cognos service: Easy to maintain, but this gives limited security.
2. Using the External Namespace (must be AD) with SSO & Kerberos. Easy to maintain and gives user level security
3. Using a signon which is an Domain User. Easy to use for a small group of Users. Makes it possible to assign UserClasses to a single Signon. Hard to maintain if there are a lot of different security groups.
Does your user account have the proper rights to connect to the MSAS server?
Also check that you have the MSAS Client tools installed on the server and on your laptop?