Search found 1543 matches

by declanr
Mon Apr 15, 2019 4:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Days360 Tm1
Replies: 12
Views: 1067

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: 288

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: 570

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: 407

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: 427

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: 329

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: 422

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: 427

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: 291

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...
by declanr
Fri Mar 01, 2019 11:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics - Monitor & Administer Dashboard
Replies: 1
Views: 447

Re: Planning Analytics - Monitor & Administer Dashboard

I believe this is scheduled to come in the next release of PAW on premise. With the usual caveat that I am only relaying what I have been told.
by declanr
Tue Feb 26, 2019 10:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 and Powerpoint
Replies: 2
Views: 341

Re: TM1 and Powerpoint

It depends largely on what you want to do. With workspace there is an export as PowerPoint option, so a whole book can be set up in workspace and then exported as a PowerPoint - each tab becomes a slide. Since you can also embed other webpages (non PA pages) in workspace you could theoretically crea...
by declanr
Wed Feb 20, 2019 7:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Budget planning model with dynamically shifting costs
Replies: 7
Views: 326

Re: Budget planning model with dynamically shifting costs

Personally I have had similar requirements and my preference would be to resolve it with users inputting directly to the cube with period/year dimensions in it and utilising MDX and/or a dynamic websheet to only show them the relevant ranges for their projects. But failing that if you really need th...
by declanr
Fri Feb 15, 2019 9:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Basic Question - Tm1 service
Replies: 3
Views: 328

Re: Basic Question - Tm1 service

This service runs all of the "standard" web services; TM1 Web, TM1 Applications and Ops Console. It was renamed to this in Planning Analytics and as your question and the previous couple of replies show it is named rather deceptively, that being said it also at one point was called TM1 Excel Service...
by declanr
Tue Jan 29, 2019 9:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Workspace - What browser do you use?
Replies: 1
Views: 124

Workspace - What browser do you use?

Simple question to those who have been working with workspace, what browser do you use? Have you noticed performance differences between browsers? For the most part all the standard stuff seems to work in IE, Edge, Chrome and Firefox but I decided to have a screen where users input dates - this was ...
by declanr
Tue Jan 29, 2019 9:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW TI Editor
Replies: 6
Views: 372

Re: PAW TI Editor

I had in fact been thinking of proposing a similar question on here myself, due to the fact I have seen a lot of negative comments in other threads regarding both the TI Editor and Rules Editors available in workspace. My view of it with regards to your actual question is that even though workspace ...
by declanr
Sun Jan 27, 2019 5:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Viewer suppress zeroes hiding non-zero cells
Replies: 11
Views: 337

Re: Cube Viewer suppress zeroes hiding non-zero cells

There is a bug that one my customers currently has, I believe they are on PA 2.0.5 but not 100% as I don’t have access to install etc in their environment. The issue means that check feeders never shows “not fed” - I tested this with a simple a = b rule on a 2 dim cube. Again due to not having acces...
by declanr
Tue Jan 22, 2019 8:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Workspace - Synchronize Selection Widgets
Replies: 1
Views: 495

Workspace - Synchronize Selection Widgets

In Planning Analytics Workspace I have a book with multiple cubes that I want to synchronize from a single widget on the front page for store/country. Cubes which contain the store dimension should show the country and its children (stores). Cubes which contain the country dimension should show the ...
by declanr
Mon Jan 14, 2019 8:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action button conditional navigation
Replies: 3
Views: 353

Re: Action button conditional navigation

Does the action button also need to run a process? And does the user need to be able to change the value in the dbrws in the source? If the answer to both questions is no, then you can use the url api to make the dbrws hyperlinks - use the excel hyperlink formula - show the value as the display name...
by declanr
Sat Dec 01, 2018 11:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: One vs Two Time Dimensions
Replies: 8
Views: 904

Re: One vs Two Time Dimensions

What version are you on? If you have access to workspace I would go with a single time dimension but use alternative hierarchies so you can view it by 2 as well. Best of both worlds then. (Admittedly with a bit of extra maintenance but it’s theoretically easy enough when you get your head around tha...
by declanr
Fri Nov 30, 2018 8:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Database Insert
Replies: 4
Views: 826

Re: Database Insert

This isn't a TM1 thing as such, it's a SQL thing. If you try and do an insert statement in SQL directly you need to use a double apostrophe e.g. MEN''S STYLE in the insert statement and it will get into the database as you want it displayed MEN'S STYLE. This is particularly common with names etc - t...