Technote (troubleshooting)

Problem(Abstract)

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"

Symptom

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.

Cause

The current login user do not have appropriate permission to update the existing Datasource and package.

Environment

Windows

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.