Log File for Uploads from Excel Spreadsheets

[dacorreia]

Is there a log file that will log messages to TM1 actions when a user tries to update TM1 data from a Excel spreadsheet using a DBSW call? There is some security issue that is not allowing the user that has Write access to all the dimensions to a cube to update the cube. When I press Shift F9 nothing happens. When I do F2 on a cell with the DBSW, I get N/A back. This tells me that user does not have access to that cube. When I do the same operation logged in as a admin, the F2 command return the cell's value.

If I can see some message showing why the update failed, I can track down the dimension or security rule that is not allowing the DBSW call to successfully update the cube's cell.

David Correia
XO Communication

[jim wood]

Have you set logging to the destination cube as true?

[lotsaram]

Is there a log file that will log messages to TM1 actions when a user tries to update TM1 data from a Excel spreadsheet using a DBSW call? There is some security issue that is not allowing the user that has Write access to all the dimensions to a cube to update the cube. When I press Shift F9 nothing happens. When I do F2 on a cell with the DBSW, I get N/A back. This tells me that user does not have access to that cube. When I do the same operation logged in as a admin, the F2 command return the cell's value.

If I can see some message showing why the update failed, I can track down the dimension or security rule that is not allowing the DBSW call to successfully update the cube's cell.

The TM1 transaction logging does exactly that, it logs transactions. If the user has insufficient access to the data to make a transaction then it can't help you as nothing will be logged. Simple as that.

To troubleshoot you need to look at the user's effective security access. The N/A value on the DBSW could be due to one of many reasons. You should look at the following things in the following order.
- does the user have WRITE, READ or NONE access to the cube itself?
- does the user have READ access to each dimension in the cube?
- for any dimensions in the cube where element security is applied does the user have WRITE access to the elements where the update is attempted?
- is cell security being used on the cube which could overrule the element security?

TM1 security is cumulative so a user's effective permissions are their combined maximum access from all groups that they belong to.

It is easier to check access with the user using the perspectives cube viewer as opposed to a spreadsheet with DBRW formulas. Can the user see the cube? Can they open a cube view? When opening a cube view is there an error message about no access to members of a dimension? If they can open a view with no errors are the cells at leaf level white or grey?

I see you have a parallel thread which seems to be the same problem but asking a different question. You need to understand TM1 security and fix the user's permissions. Giving users data admin privileges so that they can write data is a very poor and unprofessional quick fix.