Problem using an SSAS data source in IBM Cognos Framework manager
When trying to use a Microsoft SSAS OLAP cube data source in Framework Manager you get this error message:
MO-ERR-0028 The user starting the process doesn’t have the correct privileges
The solution is as follows:
- Use a network domain account for the Cognos service
- On Cognos server, in Local Security Settings under Local Policies/User Rights Assignment add the cognos service account to “Act as part of the operating system”
- ON SQL Server give cognos service security access to cube
- For the SSAS Data Source in Cognos Connection use IBM Cognos 8 service credentials for Signon.
2 Comments »
Leave a Reply
About
A Market Street Solutions business intelligence advisory consultant with deep experience in Microsoft and Cognos data warehousing architecture, data modeling, data loading and reporting. Microsoft certified – MCITP, MCT (Microsoft Certified Trainer) - in Business Intelligence and Database Development, Wharton MBA, chess player, dog lover, and husband. I live in Chattanooga, Tennessee, with my wife Jill, son Henry, dogs Bubba and Caesar, and cats Priscilla, Elvis, Prudence and Precious.
Email me, please: will.thrash@marketstreetsolutions.com
Twitter: @willthrash1
Website: Market Street Solutions
-
Recent Comments
-
Archives
- April 2012 (1)
- September 2011 (1)
- April 2011 (1)
- June 2010 (1)
- May 2010 (1)
- April 2010 (1)
- March 2010 (1)
- January 2010 (1)
- December 2009 (1)
- May 2009 (3)
- April 2009 (2)
- March 2009 (5)
-
Categories
-
RSS
Entries RSS
Comments RSS
Hi Will,
if possible could you help me to solve this situation, I want to build reports in C10 from SSAS Cube (Data Source), how can i set authorizations so a user fro example in the north region only sees that region and not every region of the company. Do I need to configure Kerberos in Active Director? not in Cognos side correct?
Thanks
DJCaldas
Hi DJ,
Yes, you need to use Kerberbos with single sign-on through Cognos. The method will be to use a role in the SSAS database with dimension security using an MDX statement. Do you have a table that relates user id’s with their regions? After the holidays, I can give you more detail. I’ve implemented this approach a few times.
Thanks,
Will