TM1 Forum

Hello All,

We have a requirement where user would select either accounts (measure) or location for which they like to hold the data. I created a }hold cube_dharav_Plan Cube by holding one leaves. Now TI process takes this cube as source and put 'H' value in to it through TI. So whenever users are running the TI than 'H' value appear in this cube.

Now, if user runs the Data Spread process than data is getting spread where values are hold. If i run the data spread process than data is spreading normally. I have admin rights.

As user are putting 'H' values in my }hold cube_dharav_Plan Cube (my username) through TI, data spread process considering hold only if i run the data spread process. When user runs than data is getting spread on hold cells also.

I assign the process to user with 'READ' access.

Can anyone suggest the best practices to be followed?

Please feel free if further information is required.

Thank You

Dharav

I believe that more than likely no one has a clue what you are talking about. I know I don't.

Maybe you could try re-wording your question id you need some input.

@lotsaram:

1) Requirement: User should be able to hold the data as they want. Once they hold the data than they would run the data spread process. Data Spread process takes high level data (Metro Level) from source cube and spreads in to target cube (Branch level).

2) Issue:

I created a TI process which can put hold. I have to create a TI instead of user do manually hold because when user try to hold each branch for all assets accounts (300 elements) than it takes (10 seconds). If user do same with TI than it takes 8 seconds to hold 15 branch for all assets accounts.

Construction of TI include "}hold cube_dharav_Plan Cube" as a source cube. I am admin so i did create a hold cube by simply holding one cell. Now, i assign this cube to data hold TI process which is based on Parameter pBranchID. If i run this TI process than H value appears in the cube and cell also gets hold.

I assign same above data hold TI process to users for testing. When they run this TI than H value appears in "}hold cube_dharav_Plan" cube but when they run data spread process than data is getting spread on hold cells too. It means that it does not considered H values from }hold cube_dharav_Plan cube. TI process assign to users have read access. According to my knowledge, assigned TI process to user, run as admin. If that is true than why it is not considering the H values from }hold cube_dharav_Plan cube which is created by admin.

FYI:
When user put hold manually and run the data spread process, everything works normally.

Please feel free if you require further information.

Thank You

Dharav

Personally I would teach the users to use the existing tools and create the holds "the normal way". Your work around seems elaborate and I'm not sure it makes things any easier for the user.

When a TI runs then it runs with DataAdmin access regardless of who is running the process, but it still runs with the context of the user who launched the process. I think to solve your issue either ...
1/ use TM1User and dynamically create the user specific hold cube on the prolog and use this cube not the one with your ID as the source
or
2/ use tm1runti and run the process externally with the user ID of whichever user is being used for the hold cube.

@lotsaram:

Thank You