TM1 Forum

tatement as below.

--------------------------------------------------------------------
DataSourceType = 'VIEW';
DatasourceNameForServer = 'Emp_Raw_info_3' ;
DatasourceCubeview = vViewName;
DatasourceUserName=TM1User() ;
--------------------------------------------------------------------


Chris

Correct me if I am wrong, but intended use of DataSourerUserName local variable is to pass user name in conjunction with DatasourcePassword to ODBC source. In context of DataSourceType = 'View' it doesn't make a lot of sense.

Please correct me if I am wrong , DatasourceUserName would only be valid when using a ODBC or ODBO source .

hyunjia wrote:oOo , Sorry , my bad , haven't gone throught the whole answer stack

I still want the process to deal with data of division A only according to its premission, because the process is common for all staffs.

deepakjain2020 wrote:

I still want the process to deal with data of division A only according to its premission, because the process is common for all staffs.

Hi Chris,

You need that Staff A should be able to access only it's division A via process. Correct me if my understanding is wrong.

If what I understood is correct then pls go through below link as discussed in earlier topics in forum (http://www.tm1forum.com/viewtopic.php?p=32121)
http://www-01.ibm.com/support/docview.w ... wg21459638

Regards,
Deepak Jain

sSubset = <YOUR SUBSET NAME, THIS MUST BE UNIQUE PER EXECUTION>;
sUser = TM1User();

SubsetCreate ( '}Groups', sSubset );

iCount = 1;
iMax = DimSiz ( '}Groups' );
While ( iCount <= iMax );
         sGroup = DimNm ( '}Groups', iCount );
         If ( Scan ( 'admin', lower ( sGroup ) ) = 0 );
                  If ( CellGetS ( '}ClientGroups',  sUser, sGroup ) @= sGroup );
                             SubsetElementInsert ( '}Groups', sSubset, sGroup, 1 );
                  EndIf;
         EndIf;
         iCount = iCount + 1;
End;   

BariAbdul wrote:Hi Declan,We can use Random function and concatenate with subset so to get unique subset each time it gets excuted.Thanks for your reply.

wang_chris wrote:Let me clarify the scenario in a simple model.

I have a cube with 3 dimensions of below.

Dim 1: Division
All_Divisions
-> Division_A
-> Division_B
-> Division_C

Dim 2: Year
Dim 3: Account, like Revenue, Costs, etc.

Also, there is a process to read all data of that cube and write down the data to a file (just for easy to understand).

Now I create staff for each division. for example: Staff_A has write permission for Division_A, none permission for other divisions. Similar for Staff_B and Staff_C.


Now when I login with Staff_A in archtect and perspective, and open the cube, I can only see the content of Division_A, since the permission of Staff_A, which is correct.

Then when I run a process with the user Staff_A . In addition to data of division A, the process can access the data of division B and C, and write them out as well.

This is what I won't see in the process. I still want the process to deal with data of division A only according to its premission, because the process is common for all staffs.

What's the solution for that process?


Regards,
Chris

wang_chris wrote:Just for a curiosity, why the developer keeps TM1 process from inheriting the running owner's permission? it looks common in other system.

Chris