Search found 1583 matches

by Steve Rowe
Tue Jul 14, 2020 10:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RptFilter
Replies: 2
Views: 55

Re: TM1RptFilter

Hi Lotsaram, Not convinced that it isn't supposed to work across the whole tuple set. I did some testing vs SData and get reliable correct sorting irrespective of the number of dims in the row position. cigar.png You can see in the above screen shot the whole tuple on a row is sorted independently. ...
by Steve Rowe
Mon Jul 13, 2020 4:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RptFilter
Replies: 2
Views: 55

TM1RptFilter

Hi, I'm using TM1RptFIlter for the first time in anger, when I have done ordering on an dynamic report before I've always been able to restrict it to a single dimension and put the relevant MDX in the subset definition. Working on a dynamic report with multiple row headers (4) and a single column he...
by Steve Rowe
Fri Jul 10, 2020 9:10 am
Forum: General
Topic: Getting Reacquanted With The IP Rules
Replies: 1
Views: 92

Re: Getting Reacquanted With The IP Rules

*Bump* as I downshifted this replying to another post after reading this one
by Steve Rowe
Fri Jul 10, 2020 9:10 am
Forum: General
Topic: A little bit of help with world domination!!
Replies: 8
Views: 567

Re: A little bit of help with world domination!!

That's disappointing Jim, if you can prove it I'd be raising it with the competition organisers. Probably too late to help you but might make them tighten up their policies.
by Steve Rowe
Wed Jul 08, 2020 3:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }StatsByRule
Replies: 4
Views: 1100

Re: }StatsByRule

I recently tried to use this to test out some logic that I was trying. I found that the cell count is accurate though note it is cells the rule applies to that have been requested from the engine, not all possible cells the rule applies to. I was trying to use it to test the calculation cache and th...
by Steve Rowe
Mon Jul 06, 2020 1:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: STR(Num, len, dec) with only one argument
Replies: 11
Views: 620

Re: STR(Num, len, dec) with only one argument

Yeah, I suggested function alias once to Ronnie at a face to face somewhere, he thought it was an excellent idea...funnily enough while I was whinging about NumberToString. It should be simple to implement as well, just right click on the Function dimension and create the alias. If only we had acces...
by Steve Rowe
Mon Jul 06, 2020 12:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: STR(Num, len, dec) with only one argument
Replies: 11
Views: 620

Re: STR(Num, len, dec) with only one argument

Whilst you are making the RFE could you suggest they change the function name to something a bit longer as I don't have enough typing to do? Maybe ConvertTheNumberValueInBracketsFromANumberToAStringPleaseOhGoOnNowDoUsAFavourGuv( Numeric ); Seriously, there is not too much wrong with the str function...
by Steve Rowe
Fri Jul 03, 2020 1:39 pm
Forum: Enhancements
Topic: DBS should fail, hard!
Replies: 6
Views: 197

DBS should fail, hard!

Hi, if you agree with this RFE please take the time to vote. https://ibm-data-and-ai.ideas.aha.io/ideas/PAOC-I-331 I bet I don't get 10 likes! In Pafe when a user executes a DBS against a cell which is not writeable the formula returns the value of the cell. Not writeable means C level, read-only ac...
by Steve Rowe
Tue Jun 30, 2020 3:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Experience with PAW and its future prospects
Replies: 12
Views: 603

Re: Experience with PAW and its future prospects

I'd say each of the individual components of the PAW development area are better than the Architect flavour but.. When I am developing I may have 2 TIs, a rule sheet and two cube views visible all at the same time and I need to swap between them all or open up another object without breaking my flow...
by Steve Rowe
Thu Jun 25, 2020 3:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue on PAX 44
Replies: 11
Views: 477

Re: Issue on PAX 44

Isn't this the issue that happens if compatibility mode in the Excel options is not set (or unset can't remember which way round it needs to be!)
by Steve Rowe
Tue Jun 23, 2020 7:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security issue with TM1 REST API
Replies: 7
Views: 474

Re: Security issue with TM1 REST API

Couldn't you amend your rest api code to test if the user was in the appropriate group?
by Steve Rowe
Mon Jun 22, 2020 5:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple COA Best Practice
Replies: 6
Views: 249

Re: Multiple COA Best Practice

Wim's very experienced but just take care, as just because person A supports a particular methodology this does not mean it is the most right for the situation you find yourself in. There is a lot of devil in the detail, not least what is value for money for the customer. especially if they have gon...
by Steve Rowe
Fri Jun 19, 2020 8:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server Crash in PA 2.0.7
Replies: 3
Views: 168

Re: TM1 Server Crash in PA 2.0.7

Are there any messages in the log or are just just maxxing out the RAM? There was a regression defect in 2.0.9 fixed in 2.0.91 relating to stargates that was crashing the box that one of our customers hit but AFAIK it was not present in 2.0.7, this generated a DEBUG message in the log even when no e...
by Steve Rowe
Fri Jun 19, 2020 8:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change of MDX security in 2.0.9 - Discussion
Replies: 14
Views: 1073

Change of MDX security in 2.0.9 - Discussion

Yeah, a change this fundamental has to be configurable in the cfg surely? The mind-boggles as to how we got here...
by Steve Rowe
Thu Jun 18, 2020 2:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Some icons missing on set editor
Replies: 10
Views: 704

Re: Some icons missing on set editor

Just to add to the mix I saw PA4E on some comms from IBM the other day, kinda hard to say though...
by Steve Rowe
Wed Jun 17, 2020 8:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ISSUE IN MDX VIEW AS DATA SOURCE
Replies: 4
Views: 212

Re: ISSUE IN MDX VIEW AS DATA SOURCE

Just to mention I've been doing a lot with MDX views as datasources recently and not hit any issues with dimension order, its not hit my radar at all.

That's not say it doesn't still exist of course...
by Steve Rowe
Fri Jun 12, 2020 7:39 am
Forum: General
Topic: Good Morning!
Replies: 2
Views: 194

Good Morning!

That's it...
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: 182

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

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

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?