Add user to Cognos

Cognos Folder Permissions:

Add Domain User to appropriate Domain Security Group (GRANDVILLE -> IT -> Security Groups ->Cognos Folder Permission):

Cognos Security:

Add Domain User to appropriate Domain Security Group (GRANDVILLE -> IT -> Security Groups ->Cognos Security):

Cognos-AnalyticsViewer - Analytics Viewers can read public content. This means users with this license can view dashboards and stories. They can view previously executed reports. They cannot interact with prompts or schedule reports. Users will not be able to drill through if this means running a child report.
Cognos-AnalyticsUser - Analytics Users can create and execute reports, dashboards, explorations, data modules. and stories. They can create and run jobs and schedule reports, create data server connections. They can respond to prompts and upload files. They will also have access to the following tools (if available): Cognos for Microsoft Office, Cognos Workspace, Cognos Event Studio, Cognos Query Studio, and Cognos Analysis Studio.
Cognos-AnalyticsExplorer - Analytics Explorers can have the same access as Analytics Users. They can additionally access Planning Analytics for Microsoft Excel, Cognos Framework Manager, Cognos Cube Designer and Dynamic Query Analyzer, Jupyter Notebook, and Transformer.
Cognos-AnalyticsAdmin - Analytics Administrators can have the same access as Analytics Explorers. They can additionally access IBM Software Development Kit, the Manage menu, and Administration.

Connect to server GVMSQL01\COGNOSCONTENT with SQL Server Management. Insert a row into database CognosAccess and table "UserList" Script below:

insert into "user list" ([Select Schema],[user],[name])

values ('DATABASE', 'firstname.lastname', 'Name of database')

Example:

INSERT INTO [CognosAccess].dbo.[UserList]

(Username,CMS_Database,FC_Database,Plant_Name)

values('michael.oriley', --User Name

'SOROCDAT', --CMS Database

'DBExporterKWM', -- FunnelCloud Database ex(DBExporterKWM, DBExporterGFO, DBExporterMGK, DBExporterSMT)

'Corvac Kentwood') --Plant Name ex. (Corvac Kentwood, Corvac Greenfield, Corvac San Marcos, Corvac Morgantown, Hadley)

*** OLD Database ***

insert into "user list" ([Select Schema],[user],[name])

values ('DATABASE', 'firstname.lastname', 'Name of database')

Example:

insert into [User List]([Select Schema],[User],[Name])

values('corvac7', --Schema

'jami.rowan', --User Name

'Greenfield Ohio') --Text Database Name