Search found 1566 matches

by Steve Rowe
Fri May 29, 2020 1:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How set alternative hierarchy in Architect or Performance Modeler.
Replies: 4
Views: 100

Re: How set alternative hierarchy in Architect or Performance Modeler.

Hi,
Just in case you have access to Planning Analytics for Excel you can use Hierarchies there as well.

If you have not installed PAW (as opposed to not being able to access it), then you won't be able to use (all of) PAfE and so won't be able to report with hierarchies.

Cheers,
by Steve Rowe
Thu May 28, 2020 3:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button not correctly working
Replies: 2
Views: 62

Re: Action Button not correctly working

Yes

You don't edit it by right clicking the button anymore
Goto the task pane / object tree, select the worksheet tab, in here you should find all your action buttons listed. Right click and edit.
by Steve Rowe
Tue May 26, 2020 1:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX - weight of a member
Replies: 5
Views: 2490

Re: MDX - weight of a member

Couldn't you use the Elweight function to pull the value out into an attribute and then run your MDX filter versus the attribute value?
by Steve Rowe
Tue May 26, 2020 11:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pax - Expand Above
Replies: 1
Views: 53

Re: Pax - Expand Above

In the set editor toggle the Show Totals Leading / Trailing which is the Epsilon with the bars above and below it in the middle of the editor.
Make sure the set editor is in to Hierarchy mode rather than definition mode as well as this (might) make a difference too.
by Steve Rowe
Tue May 26, 2020 10:42 am
Forum: Enhancements
Topic: MDX Object type for picklists
Replies: 3
Views: 110

MDX Object type for picklists

Hi I've created an RFE for the addition of new type of picklist definition MDX:{MDX Expression}. Would like to try and avoid the creation of loads of redundant subsets to drive picklist selectors. All adds to the development time, server clutter and risk of deletion in error. When we have to create ...
by Steve Rowe
Fri May 22, 2020 3:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: @= in active sheet formula
Replies: 11
Views: 991

Re: @= in active sheet formula

@Bakkone, must have missed this option, I did look, I'll look harder!
@MarenC, it just comes back on the next edit so Yes you have to remove it for sure but I was looking to stop it happening in the first place.

Removing the snail stops it from happening as well.
by Steve Rowe
Fri May 22, 2020 1:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: @= in active sheet formula
Replies: 11
Views: 991

Re: @= in active sheet formula

Thought I'd keep all the nonsense that arises from the at sign in one place. Working in active forms in Pafe where we have the at in front of report row formula i.e. =@TM1RPTROW($C$11,"Server:DimName",,,"Description",,$D$21) If I edit (f2, return) this then Excel decides that this is an email addres...
by Steve Rowe
Wed May 13, 2020 10:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory Usage Issues - StatsByCube
Replies: 17
Views: 421

Re: Memory Usage Issues - StatsByCube

Hi, It sounds you have some problems.... From what you have said the OS is using the swap file / virtual RAM on the disc to provide all the memory that TM1 requires. This _may_ not be hurting your performance since this is all garbage but far from ideal. This would explain why adding more RAM didn't...
by Steve Rowe
Wed May 13, 2020 8:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory Usage Issues - StatsByCube
Replies: 17
Views: 421

Re: Memory Usage Issues - StatsByCube

Hi, Your first place to check for where the rest of the memory is the stats for server cube and the Garbage Memory. Garbage Memory is memory that TM1 has used but is not at the moment. Common reasons for a large Garbage Memory are Multi threaded start-up options or very large views being generated i...
by Steve Rowe
Tue May 12, 2020 8:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Opening pax sheet in paw
Replies: 2
Views: 439

Re: Opening pax sheet in paw

How have you published the websheet? Make sure you have picked the upload to server option rather than the linked approach.
by Steve Rowe
Thu May 07, 2020 9:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SAP-BW Turbointegrator Connect does not work in PA 2.07
Replies: 3
Views: 167

Re: SAP-BW Turbointegrator Connect does not work in PA 2.07

Hi _BM_ I don't have an answer for you but some more questions that may clarify the position. Is this a new install or an upgrade? Has the connector every worked? Assuming this is an on-premise build? "Cannot open connection to database" This would normally mean that either the PA hardware can not s...
by Steve Rowe
Tue May 05, 2020 11:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use of [ ] =N: in reporting cube
Replies: 4
Views: 294

Re: Use of [ ] =N: in reporting cube

Obviously only working with a little bit of detail but.... Some questions What is the difference between the 4 sets of actual data and why are they in different cubes? What is the difference in between the forecast data and the actual data, is there some difference in granularity? General Comments. ...
by Steve Rowe
Fri May 01, 2020 7:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use of [ ] =N: in reporting cube
Replies: 4
Views: 294

Re: Use of [ ] =N: in reporting cube

Without getting into the merits of what you are doing in the 'Forecast Intermediate' cube put [{'Subset list of common measures' , 'M1' , 'M2' , etc]=>DB('Reporting' , !Version, !Actual and Forecast Types, !Products , !Current Time, !FORECAST Measures) ; I can't help but ask if the situation is as y...
by Steve Rowe
Thu Apr 30, 2020 7:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewCreateByMDX - Erring on creation of empty view
Replies: 1
Views: 258

Re: ViewCreateByMDX - Erring on creation of empty view

You'd think I would use the search button... Just cross linking for anyone who finds this post and not the other one https://www.tm1forum.com/viewtopic.php?f=3&t=14797&p=73290&hilit=viewmdxset#p73290 thanks Lotsaram Also there is an APAR associated with this https://www.ibm.com/support/pages/apar/PH...
by Steve Rowe
Fri Apr 24, 2020 2:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewCreateByMDX - Erring on creation of empty view
Replies: 1
Views: 258

ViewCreateByMDX - Erring on creation of empty view

Hi, This function appears to suffer from the same issue as the subset function in that it errors if the MDX does not return any values. This seems like very dumb behaviour (though I'll no doubt be told its by design and to raise a RFE..). I've been fiddling around with creating a union of my real qu...
by Steve Rowe
Fri Apr 24, 2020 10:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issues creating a ROUNDP rule
Replies: 3
Views: 237

Re: Issues creating a ROUNDP rule

I'd strongly recommend that you regard this as a formatting problem not a data problem. If you go the rule approach then you will duplicate all the data (bad). You could round the data on loading in the TI process, this is probably the most right way. but.... As TM1 (and almost any computer) sums 2 ...
by Steve Rowe
Thu Apr 16, 2020 1:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Report generation with MDX views
Replies: 2
Views: 396

Report generation with MDX views

Hi, I think the answer is no but... With an active form I can change the MDX being used to generate the row headers in a very dynamic way. For exploration, quick and custom reports there is the VBA CreateFromMDX method available. I've a strong preference for not using VBA as it traps any front end d...
by Steve Rowe
Mon Mar 30, 2020 8:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: @= in active sheet formula
Replies: 11
Views: 991

Re: @= in active sheet formula

As an FYI, this seems to clear by doing an edit replace of "=@" with "=" across all cells and sheets. I've not seen the "@" get re-introduced to date.
by Steve Rowe
Fri Mar 27, 2020 1:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: @= in active sheet formula
Replies: 11
Views: 991

Re: @= in active sheet formula

In both PAfe and perspectives version 2.0.43 / TM1 Build 11.5 I can see that =@DBRW causes the type over write back to fail, instead just ending up with the value you entered in the cell? Any ideas what release this was fixed in or does the defect still exist in the 2.0.9 series? Cheers and Good Hea...