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 who wants to update the datasource and package of the existing Powercube should have 'Directory Administrator' role permission assigned to the user.
Once Directory Administrator role is assigned having 'read', 'write' and 'execute' permission the user should be able to update the datasource and package without any issues.
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: 2013-01-22