TM1 Forum

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...

If you are an admin in workspace you should have access to the “Lifecycle Management Tool”; this allows you to transfer workspace books between environments.
If you have a really old version of workspace local it might not be there but I think it’s been around for well over a year now.

It just sounds like your source query is picking up the alias and you only want it to be the element name.

You can change the statement to bring only the element name or you can change the process so that it works out which part is code and which part is the name.

I think I have misunderstood your issue. As Lotsa has pointed out are you just wanting to essentially show an element attributes cube on its own? I thought you wanted to show an attribute (or some attributes) for a dimension that is part of a cube (a non control cube) if that was the case you can ju...

I tried to do something similar, show an attribute and hide the element name but couldn’t do it without creating an alternative hierarchy for the attribute.
So creating an alternative hierarchy from the attribute will do the job for you but it’s additional work to set it up.

Without more info I would suggest just appending a number to each "level" to make sure the element names are unique. If your n-level column variable is called "node" and your other 12 columns for element names were col1 through to col12 then something like below on your metadata should theoretically...

TM1 doesn’t have an out of the box function for this so you will need to create the logic yourself. Rules or TI should be relatively simple. You work out the number of full months (e.g if you are looking between the 10th Jan and 15th May you would have 3 full months; Feb, Mar and Apr) then you multi...

As far as I am aware there is no ability to change the default spreading option. If you don’t want to use the right-click menu you can show users how to work with shortcuts, for your example it sounds like LS*500 would work - this would spread 500 equally across all leaves (the * indicates it should...

In excel you can do it with data validation. Set a named range of text you don’t want to be allowed. Set data validation as custom on the dbrw cells you want restricted and put something like below: =SumProduct(--ISNumber(Search(ForbiddenList,B10)))=0 Where ForbiddenList is the named range of banned...