TM1 Forum

Yes. Private subsets are stored in the data directory in folders for the username. Generally when migrating you want to take the opportunity to clean up some clutter from the data directory anyway. Copy all the users folders out to a separate location and Copy that to your cloud server. After you ha...

Assuming it is only the dimension cbm_hybrid_program_project that you care about being ordered; you can keep the source view as you have it but with that dimension instead just having a single element in its assigned subset which is the total of all relevant elements. Make sure consolidations are in...

Only active form reports having the issue. Must of inserted the lines incorrectly as that did not work. Delete all rows apart from the first in the active form (the one that actually contains the tm1rptrow formula. A few rows below that type a word into a cell, something visible. Update the file on...

Insert a few extra rows under the active form area and add a border to the cells a few rows down then reupload the sheet and it will be fine.

That’s just a case of selecting a given cell from an existing cube view and right click - Add to Sheet. Or similar wording to that effect.

and the value in tm1 web view looks in blue color. Is the user using a sandbox ? no he is not using any sand box.test_process1.PNG The blue colour means that the user is using a sandbox.This could either be a manually created and selected sandbox - or very likely the user has the Personal Workspace...

As an admin go into the }processsecurity cube and find that TI process - then put READ in the cell that corresponds with a security group that the user belongs to.
You can also right click on processes and go to security that way for the same purpose.

I handle this by having the master process create a text file in a folder and pass the name of that file to the sub process (doing this for ever sub process it runs.) The last line of the sub process deletes the file. At the end of the master process it loops the folder counting the files that exist...

Also one omre question in perspectives i am able to edit the action button properties by right clicking the button and properties .But in PAX once I add the button ,I am not able to edit to change any settings. I checked in design mode and also right clicking not giving the same option For buttons ...

It sounds like you have used the server parameter in the web config file. If you remove it (leave it blank) then the drop down box will appear. You will need to restart the web service after changing the config file.

You can get them from the }externals folder in your data directory.

You could completely automate this but it becomes risky in case the CSV comes in as complete garbage one time and you could end up with it creating the measures etc anyway. But create a process to handle however many columns you expect plus an extra 10 or so (all set as string - other) Have a new pr...

If that element is not at the lowest level then should i back up the data . I am renaming Region 1. Will I be able to delete Region1 with out deleting the customer data under it ? So hierarchy is like All Regions-> Region 1 ->Agency ->Customer Numeric data is stored at the lowest level and consolid...

Some people on here may be horrified by the thought of this but I have been able to apply pretty much any formatting I want by adding additional measure elements to the cube and applying rules to those elements - in this case I would make it 0 if either the condition is achieved or it’s not n-level....

To add to Wim's point - the ability to run processes from buttons in Workspace only got added in PAW 39 which was released in March. In earlier versions you will still need to add an action button to a websheet via PAX and then load that into your PAW book. https://www.ibm.com/support/knowledgecente...

Hi, Done a quick test myself and it seems ok - I must admit that sandboxes are something that haven't often been used in models I have developed/worked on - the functionality seems ok in my set up that I have at the moment though. What version of PA and PAW are you on? Also does the synchronisation ...

If they are on different tabs you need to also set the synchronisation scope to book instead of sheet.

Have a TI process loop through the subsets in the source dimension. For each subset use the MDXGet functionality; if it returns something then use scan/substring to replace the dim name references (1 subset might reference it multiple times) then create subset in the target with a createbymdx. If th...

You need to be defined as a modeler or administrator in Workspace. This is above and beyond and security set in tm1 for the model. The workspace administrator who set you up can do this.

Bit difficult to sort this kind of thing out without access to the system and a bit of trial and error. But one “workaround” solution would be that if your account dimension is always a certain number of characters then to use a substring which feeds the cellputn. This can also work if it’s not a se...