Dear all,

I have the following issues related to the security setup:
1) I create a process to upload a TB file to TM1 cube
2) Every month I change the TB File in the datasource tab and it requires me to save the process
3) This month I ask my colleague to do this, but I need to grant Admin right to him for doing the change. 
4) Any solution that my colleague could do the above not using the admin profile, as I am not comfortable to grant Admin to junior.

Rgds,

Eric

------------------------------
Eric Ngo
------------------------------

#PlanningAnalyticswithWatson

------Original Message------

Dear all,

I have the following issues related to the security setup:
1) I create a process to upload a TB file to TM1 cube
2) Every month I change the TB File in the datasource tab and it requires me to save the process
3) This month I ask my colleague to do this, but I need to grant Admin right to him for doing the change. 
4) Any solution that my colleague could do the above not using the admin profile, as I am not comfortable to grant Admin to junior.

Rgds,

Eric

------------------------------
Eric Ngo
------------------------------

#PlanningAnalyticswithWatson

I agree with Ryan that this is an option.

Somewhat similar, here is some boilerplate from our process template that may help you

# -------------------------------
# Assign CSV file datasource
# -------------------------------
cDataSourceFolder = '\\sdx0007.....com\..data\sapexpimp\all\';
pFileName = 'Supply file name as a parameter';
DatasourceNameForServer = cDataSourceFolder | TRIM(pFileName);
DatasourceNameForClient = cDataSourceFolder | TRIM(pFileName);​

You could pass the pFileName as a parameter or if your colleague simply replaced the file in the appropriate location then the process could use the default parameter value and would not need to modify the process.

------------------------------
Trevor Mills
------------------------------

Instead of a parameter you can also set the DatasourceNameForServer variable to the value of a string cell that the user has WRITE access on.

Cognos Command Center also has a neat trigger functionality that can be used to automatically start a TI process when a file is placed or updated in a directory.  The trigger can pass the name of the file to the Ti process as a parameter, and it can be set as the data source using the DatasourceNameForServer variable.  A bit more complex solution, but it will prevent the user from having to manually run the TI process and set the data source.

------------------------------
Stuart King
IBM Planning Analytics Offering Manager
------------------------------

Original Message:
Sent: Mon December 16, 2019 03:23 AM
From: Trevor Mills
Subject: User right - Workspace to run process

I agree with Ryan that this is an option.

Somewhat similar, here is some boilerplate from our process template that may help you

# -------------------------------
# Assign CSV file datasource
# -------------------------------
cDataSourceFolder = '\\sdx0007.....com\..data\sapexpimp\all\';
pFileName = 'Supply file name as a parameter';
DatasourceNameForServer = cDataSourceFolder | TRIM(pFileName);
DatasourceNameForClient = cDataSourceFolder | TRIM(pFileName);​

You could pass the pFileName as a parameter or if your colleague simply replaced the file in the appropriate location then the process could use the default parameter value and would not need to modify the process.

------------------------------
Trevor Mills
------------------------------