Search found 1554 matches

by declanr
Tue Jul 16, 2019 9:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Button does not give RUN Process option
Replies: 5
Views: 233

Re: PAW Button does not give RUN Process option

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...
by declanr
Mon Jul 15, 2019 2:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Paw - Synchronise Sandboxes
Replies: 3
Views: 460

Re: Paw - Synchronise Sandboxes

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 ...
by declanr
Sat Jul 13, 2019 7:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Paw - Synchronise Sandboxes
Replies: 3
Views: 460

Re: Paw - Synchronise Sandboxes

If they are on different tabs you need to also set the synchronisation scope to book instead of sheet.
by declanr
Thu Jul 11, 2019 8:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Save MDX based Subset for Clone Dimension
Replies: 3
Views: 351

Re: How to Save MDX based Subset for Clone Dimension

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...
by declanr
Wed Jul 10, 2019 6:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Cannot see the dimension or processes
Replies: 3
Views: 287

Re: PAW Cannot see the dimension or processes

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.
by declanr
Mon Jul 01, 2019 9:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBO Process
Replies: 11
Views: 337

Re: ODBO Process

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...
by declanr
Sun Jun 23, 2019 5:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Workspace BOOK
Replies: 2
Views: 681

Re: Copy Workspace BOOK

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.
by declanr
Fri Jun 21, 2019 3:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBO Process
Replies: 11
Views: 337

Re: ODBO Process

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.
by declanr
Mon Jun 17, 2019 9:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Replace Columns with Element Attributes
Replies: 5
Views: 148

Re: PAW Replace Columns with Element Attributes

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...
by declanr
Mon Jun 17, 2019 5:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Replace Columns with Element Attributes
Replies: 5
Views: 148

Re: PAW Replace Columns with Element Attributes

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.
by declanr
Tue Jun 04, 2019 6:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating dimension elements using TI with multiple level hierarchy
Replies: 3
Views: 825

Re: Updating dimension elements using TI with multiple level hierarchy

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...
by declanr
Mon Apr 15, 2019 4:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Days360 Tm1
Replies: 12
Views: 1184

Re: Days360 Tm1

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...
by declanr
Wed Mar 27, 2019 4:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Spread functionality
Replies: 4
Views: 345

Re: Spread functionality

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...
by declanr
Mon Mar 25, 2019 8:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to restrict a user not to enter a value in the active form
Replies: 10
Views: 665

Re: How to restrict a user not to enter a value in the active form

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...
by declanr
Wed Mar 13, 2019 6:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill down in only a row
Replies: 4
Views: 469

Re: Drill down in only a row

In architect/perspectives/tm1 web you can’t drill down on only 1 instance of an element that appears multiple times in a nested dimension.
If they are on PA this is something that can be achieved in the new interfaces such as workspace cube views.
by declanr
Wed Mar 06, 2019 10:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI processes significantly slower after upgrade from TM1 10.2.2 to TM1 2.0
Replies: 4
Views: 478

Re: TI processes significantly slower after upgrade from TM1 10.2.2 to TM1 2.0

Start by narrowing down which part of the TI is running slower, easiest quick way to do this is to put in asciioutputs with time stamps at the end of main sections in the process. There will be plenty of things that could make it slower, the more you can narrow it down the more suggestions you will ...
by declanr
Wed Mar 06, 2019 10:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Delimiter to be Used
Replies: 2
Views: 355

Re: Delimiter to be Used

Like you are suggesting, there are characters that are unlikely to be used in text fields and can be used as your separators but if you have free entry text fields you can’t guarantee a character won’t be used. You can enclose all fields in quotes and specify the quote character for the TI using dat...
by declanr
Wed Mar 06, 2019 4:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 PAW Start.bat exit with code 0
Replies: 4
Views: 487

Re: Tm1 PAW Start.bat exit with code 0

Download windowscontainernetworking-loggingandcleanupaide.ps1 from github and run it with the cleanup option, see if that helps. I run workspace on a Server 2016 VM on my personal machine rather than having it directly on the PC but I believe it’s not ideal to run it on a laptop (which I assume you ...
by declanr
Tue Mar 05, 2019 9:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI processes significantly slower after upgrade from TM1 10.2.2 to TM1 2.0
Replies: 4
Views: 478

Re: TI processes significantly slower after upgrade from TM1 10.2.2 to TM1 2.0

When you say the processes that are generally slower are those that are triggering work on another Database, do you mean another tm1 service or something on a relational DB? If it’s on another tm1 service, is that on the same Server and if so is every process on that service slower? If it’s relating...
by declanr
Mon Mar 04, 2019 7:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Error
Replies: 1
Views: 354

Re: PAW Error

Hi, I would recommend if possible as a starting point keeping the workspace server completely free of any other software/tools. That being said when issues arise with workspace a good starting point is to search for windowscontainernetworking-loggingandcleanupaide.ps1, Run it with the cleanup option...