Search found 1605 matches

by declanr
Mon Sep 14, 2020 7:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX statement for pointing to a subset
Replies: 1
Views: 81

Re: MDX statement for pointing to a subset

99% of the time they will be exactly the same results. However, if you had an element and subset with the same name - it would return the element instead of the subset... so using SubsetToSet makes sure that it returns the subset. It’s probably good practice to be as explicit as possible of what you...
by declanr
Tue Sep 08, 2020 11:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW installation in Centos Linux or Windows Server 2012
Replies: 7
Views: 232

Re: PAW installation in Centos Linux or Windows Server 2012

Noticed that it’s only your app gateway that has failed. Have you done the install using the latest PA software that has web as a separate install? If so by default both web and app server run on port 9510; which means starting one stops/causes issues with the other. If so easiest thing to do is cha...
by declanr
Tue Sep 01, 2020 3:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetCreatebyMDX Union 3 elements or more
Replies: 3
Views: 181

Re: SubsetCreatebyMDX Union 3 elements or more

Hi, Union can only handle the joining of 2 statements. But you can nest Unions. e.g. {UNION( {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( { [ ' | vDim1 | ' ].[ ' | vEl | ' ] }, ALL, RECURSIVE )}, 0)}, {Union ( {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( { [ ' | vDim1 | ' ].[ ' | vEl2 | ' ] }, ALL, RECURSIVE ...
by declanr
Fri Aug 21, 2020 1:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Point Workspace Views to different TM1 Server
Replies: 1
Views: 328

Re: Point Workspace Views to different TM1 Server

After you have selected Default in BOTH the Source and target it will provide you with additional dropdown boxes underneath each where you can select your source and target TM1 services. These dropdown boxes are only visible AFTER you select the Environments.
LCMT.png
LCMT.png (35.22 KiB) Viewed 318 times
by declanr
Fri Aug 21, 2020 9:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Time Series Line Chart with Separate Year and Month Dimensions
Replies: 5
Views: 567

Re: PAW Time Series Line Chart with Separate Year and Month Dimensions

Since the introduction of Alternative Hierarchies I believe the best solution is to have a single continuous time dimension and then use alternative hierarchies to split it into Year and Month. That way you can utilise the same cubes in different ways; meaning you can get the benefit of each option ...
by declanr
Wed Aug 05, 2020 8:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String to Date Conversion in TI - "S1000[Oracle][ODBC][Ora]ORA-01861: literal does not match format string"
Replies: 3
Views: 346

Re: String to Date Conversion in TI - "S1000[Oracle][ODBC][Ora]ORA-01861: literal does not match format string"

Generally speaking I would suggest if possible that you store the date as a numeric cell in TM1 and just format it to look like a date; generally that makes most things a lot easier. That being said since you currently have it as a string; I would start by converting your string to a number ( ParseD...
by declanr
Wed Aug 05, 2020 8:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security in Planning Analytics Workspace
Replies: 4
Views: 304

Re: Security in Planning Analytics Workspace

I believe workspace groups were introduced in 2.0.42 There is no configuration required to enable it; if you were on a version that included it you would see the options by default. And as Moby has highlighted, at the moment it is not linked to AD etc. The groups are created and exist just within Wo...
by declanr
Tue Aug 04, 2020 8:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filter by Status - Tm1 Scorecarding
Replies: 3
Views: 251

Re: Filter by Status - Tm1 Scorecarding

I must admit that I haven't looked at or used scorecards for quite a long time. However, if memory serves the "status" is just a measure in your cube - so you could have MDX subsets that filter your driver dimension for each possible status (e.g. 1 subset for Excellent, 1 for Poor etc.) then just ch...
by declanr
Thu Jul 02, 2020 5:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Experience with PAW and its future prospects
Replies: 12
Views: 1229

Re: Experience with PAW and its future prospects

PlanningDev wrote:
Wed Jul 01, 2020 11:49 pm
Unable to select control objects as source in a TI
They have actually sorted this one now - not sure what release it came out in but you now have a drop down in the TI Data Source to swap between Control Objects or a Standard Object.

https://ibb.co/gMY8PDh
by declanr
Thu Jul 02, 2020 5:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Synchronise Action Button parameters with Sheet Selections
Replies: 8
Views: 1099

Re: PAW Synchronise Action Button parameters with Sheet Selections

So do I understand correctly that you then have to rebuild the 'synchronisation' bit of the selector widgets by making cube views refer to this }clients param dim with MDX subsets (i.e.filter the country list to whatever is in that cube for this user)? Yup, just saw the video. I love this approach,...
by declanr
Tue Jun 30, 2020 9:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Experience with PAW and its future prospects
Replies: 12
Views: 1229

Re: Experience with PAW and its future prospects

Do you think that we can completely get away with TM1 architect for development and adopt PAW? What is its future prospects? Thanks! I will answer this question purely from the development point of view that you have asked. I honestly think that I could. I do the majority of my development directly...
by declanr
Wed Jun 24, 2020 7:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SKIP If doesn't exist instead of ERROR
Replies: 3
Views: 420

Re: SKIP If doesn't exist instead of ERROR

Code: Select all

If ( Dimix ( <DimName>, <ProductName> ) = 0 );
	ItemSkip;
EndIf;
by declanr
Wed Jun 03, 2020 4:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot connect to PAW
Replies: 3
Views: 567

Re: Cannot connect to PAW

Can you connect from the same machine that PAW is running on? Or try and do an ipconfig on the PAW server and then see if you can connect with the IP address rather than the server name. In power shell on the paw server run ./scripts/admintool.ps1 in the admin tool window that opens up; go to Status...
by declanr
Wed Jun 03, 2020 6:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Different calculation for same Elements
Replies: 3
Views: 430

Re: Different calculation for same Elements

Although an element can exist in a single hierarchy/dimension with multiple parents; the element's primary key is its name - as such it cannot have different calculations for the same intersection (where the only difference is a different parent) - you can do it on other intersections; such as a dif...
by declanr
Mon Jun 01, 2020 9:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 22
Views: 2323

Re: Local Backup

PA on demand is a different kettle of fish altogether; it is very much intended to handle individual smaller models - think of those large excel workbooks people might maintain on their own machines but having the ability to utilise PA functionality instead. There is the "Digital Pack" which is sort...
by declanr
Sat May 30, 2020 6:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Process Self Triggering
Replies: 10
Views: 1063

Re: TM1 Process Self Triggering

Before the process has finished; a chore etc has kicked off another process that has caused contention (often a savedatall function) which then means that all transactions from your Master Process and its Sub Processes have rolled back and then started again when it has a clean window to do so.
by declanr
Sat May 23, 2020 3:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Synchronise Action Button parameters with Sheet Selections
Replies: 8
Views: 1099

Re: PAW Synchronise Action Button parameters with Sheet Selections

There are a number of things that you can’t quite do with the synchronisation- such as what you have highlighted and another common one of selecting an element in 1 dimension; such as a Country Code in a country dimension and seeing its corresponding element selected in another dimension e.g all Sto...
by declanr
Wed May 20, 2020 8:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 TI Scan Function
Replies: 2
Views: 432

Re: TM1 TI Scan Function

sFind = '- '; nLong = Long ( vsString ); iPos = nLong - 1; nFound = 0; While ( iPos > 0 & nFound = 0 ); sSub = SubString ( vsString, iPos, 2 ); If ( sSub @= sFind ); nFound = 1; Else; iPos = iPos - 1; EndIf; End; If ( nFound = 0 ); LogOutput ( 'INFO', 'Could not find country in string: ' | vsString...
by declanr
Thu May 07, 2020 5:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset linked to list and refresh on action button
Replies: 14
Views: 1992

Re: Subset linked to list and refresh on action button

If you select “1” after it shouldn’t be there do you at least get an error saying it’s not a valid selection?

If IBM mentioned it as a known defect did they give you a reference number for it?
by declanr
Thu May 07, 2020 4:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset linked to list and refresh on action button
Replies: 14
Views: 1992

Re: Subset linked to list and refresh on action button

A cells picklist should be re-evaluated every time you use it; so you shouldn’t see any values that are not in the linked subset or the value already in the cell.

Are you sure there isn’t still an old excel data validation list on the cell or something like that?