Getting error (TR0164) Data source creation problem. CM-REQ-4012 You do not have appropriate permissions"
Already build cube if you try to 'Publish PowerCube as Datasource and Package..' again and if you are login with non Admin user you end up getting error "(TR0164) Data source creation problem. CM-REQ-4012 You do not have appropriate permissions"
Scenario :- Cube is already build. A non Admin user logins to Transformer and opens the mdl so that he can update the datasource and package by right click on already build Powercube. When he right click on the existing Powercube and selects 'Publish powercube as datasource and Package..' -> Selects option 'Publish the Powercube using current settings' (Publish Powercube window) -> Select Update the existing datasource -> Click on 'OK' you are then presented with the error.
The current login user do not have appropriate permission to update the existing Datasource and package.
Resolving the problem
The user trying to create or update the data source does not have required permissions to perform this task. They require Write, Execute and Traverse permissions on the Cognos namespace.
Steps to add Administration permissions
1. Go to Cognos Administration, Security tab
2. Go to Properties of the Cognos namespace, Permissions tab
3. Add User, Group or Role and grant Write, Execute and Traverse permissions
Alternately you can make the user a member of DIrectory Administrators Role.
More support for:
Cognos Business Intelligence
Software version: 8.4.1, 10.1, 10.1.1, 10.2
Operating system(s): Windows
Software edition: All Editions
Reference #: 1622953
Modified date: 13 October 2016