TM1 Forum

Imagine the situation (it is not real but one time It was almost real)

One of users was working in Contributor Application - used 2 sandboxes in it but didn't commit his node (numbers are in blue colour and he didn't clicked on green tick). After it he went in bussiness trip but I (who has admin rights) want to take data from one of his sandbox.

How can I do it?
I tried to use TI Process SetUseActiveSandboxProperty(1) but it didn't take his data (in blue), it takes only that data which I see in Architect.
It seems it is only the user who has to launch this process.

Also I found 2 .cub_delta files in his directory but it seems they are not in simple format from which I could take data.

So have anybody any ideas how could I take data from users sandboxes using admin rights?

Assuming you have mixed mode security, log in as him using native TM1 security (you are the admin so this should be easy) and submit his data for him. I'm pretty sure there's no other way. Others may know differently.

Tomok can you export sandboxes to text from the cube? I've never tried it? I mean the user could do that if they can't submit,

Jim.

Just tried it - seems to work fine using 'Export as Text Data'.

Can you explain that you did?

When I open Architect as Admin and use 'Export as Text Data' I could see in text file only data which are submitted (which is not in blue colour in Contributor).

If I open Architect as user who entered the data I could see data from its sandboxes in blue colour but it isn't that I want.
I want to have access as Admin to user data in its sandboxes.

As explained further up the thread, you have to log in as the user to access their sandbox(es).

David Usherwood wrote:As explained further up the thread, you have to log in as the user to access their sandbox(es).

of course it is the good idea to log in as the user
but sometimes it is impossible.