Search found 1444 matches

by Steve Rowe
Fri Jan 11, 2019 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx not fully recalculating
Replies: 8
Views: 309

Re: PAx not fully recalculating

Hi Loki, Might be worth posting detailed version numbers
by Steve Rowe
Wed Jan 09, 2019 11:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing object access after copy from Prod to Dev
Replies: 7
Views: 281

Re: Missing object access after copy from Prod to Dev

Sounds to me like the cfg is pointing to an empty folder so it has created the initial starting objects.

Best guess is that your network engineer has not correctly copied the files to the correct location.
by Steve Rowe
Tue Jan 08, 2019 10:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx not fully recalculating
Replies: 8
Views: 309

Re: PAx not fully recalculating

If you are talking about DBRWs / custom report then you need to check the force recalc on f9 option in the PAx options to get f9 working. If you don't (I think) normal excel calcs take over and only cells that have a dependency that has changed will be refreshed.
by Steve Rowe
Mon Jan 07, 2019 9:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CELL PROPERTIES in TM1 MDX
Replies: 1
Views: 280

Re: CELL PROPERTIES in TM1 MDX

Hi Sachin,
Please do try and post in the correct forum.

AFAIK these functions are not supported in MDX with TM1.
I'm curious as to where you are trying to do this as in native TM1 there isn't really anywhere you can return a number and care about the format it is in.
by Steve Rowe
Wed Jan 02, 2019 9:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DEL Command is not working in TM1 Process
Replies: 5
Views: 385

Re: DEL Command is not working in TM1 Process

Also vCommand = 'cmd /c DEL '|'"' | vFilePath| '"'; ExecuteCommand(vCommand, 0); would work with no need for text files. Take care with using the ExecuteCommand function with the 1 parameter set, very occasionally DOS will hang and then your TI will get stuck. Unless you have a good reason use the 0...
by Steve Rowe
Tue Dec 18, 2018 9:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTQQuery
Replies: 2
Views: 216

Re: MTQQuery

Thanks mvaspal, I'd not found this tech note when searching. Having to have Skip Consolidated Values unchecked seems to be a pretty odd requirement but I'll test when I get a chance. I would habitually use a L0 subset rather than "All" + "Skip Consolidated Values" in my view definitions. Now wonderi...
by Steve Rowe
Thu Dec 13, 2018 10:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTQQuery
Replies: 2
Views: 216

MTQQuery

Hi, Can anyone confirm that MTQQuery actual works in current releases, I'm using 11.1.1.36. According to documentation it should be on by default. but I couldn't see anything in TOP to indicate it working (I can with MTQ, with work units spinning up). Added explicit parameters MTQ=-1 MTQQuery=T No r...
by Steve Rowe
Tue Dec 11, 2018 1:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple PAX issues - Excel Office 365 compatibility?
Replies: 4
Views: 641

Re: Multiple PAX issues - Excel Office 365 compatibility?

We've seen all of these and a few others.

The #Name one appears to be specific to the Excel add-ins (rather than the Com add in) becoming unchecked. Checking them again has resolved the situation whenever we have seen this issue.
by Steve Rowe
Fri Dec 07, 2018 9:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: issues with moving TI processes
Replies: 9
Views: 551

Re: issues with moving TI processes

If you are using perspectives / architect then you might want to check that the option to see the processes is checked. The option is on the view menu.
by Steve Rowe
Tue Dec 04, 2018 4:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: One vs Two Time Dimensions
Replies: 8
Views: 698

Re: One vs Two Time Dimensions

We are actually restricted on RAM because it's allocated on a virtual server and IT is stingy with what they give. Unfortunately this seems to be a bit of a common story. Running in a VM with the ability to easily add RAM to a TM1 model should be a feature of your infrastructure to adapt to a chang...
by Steve Rowe
Tue Dec 04, 2018 11:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1web on https
Replies: 4
Views: 243

Re: Tm1web on https

Hi Kavitha, Just so you know this site is not an IBM site, more somewhere where TM1'ers can get together to trade tips and resolve detailed technical issues. If you need technical support on an entire end to end piece then you really should be raising a support request with IBM, googling their on-li...
by Steve Rowe
Sun Dec 02, 2018 10:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: One vs Two Time Dimensions
Replies: 8
Views: 698

Re: One vs Two Time Dimensions

In principle the new hierarchy functionality means the classic 1d vs 2d argument goes away, everyone should go 1d and use hierarchies to deliver the cross-tab year / month analysis. Unfortunately in the absence of a "DBRH" type formula, in practice a lot of hierarchies based designs remain a paper e...
by Steve Rowe
Fri Nov 30, 2018 3:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspective Vs Pax
Replies: 5
Views: 676

Re: TM1 Perspective Vs Pax

Hi Paul, Feel your pain on this one, behaviour on a unlocked cell irrespective of a password being set should be the same, i.e. "everything" works, can't see any justification for it being otherwise. Arbitrary flipping of defects into RFE is pretty rage inducing.....it would be interesting to know w...
by Steve Rowe
Wed Nov 28, 2018 9:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders: rule based on constant values
Replies: 3
Views: 302

Re: Feeders: rule based on constant values

As Duncan said, if you are trying to flag valid intersections (maybe for some kind of data entry form where the rows in the input space are zero and there is nothing to drive to suppression) then do this in a TI process and populate the intersection directly. This could be chained with whatever mech...
by Steve Rowe
Mon Nov 26, 2018 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with entering into empty cell (PAx 2.0)
Replies: 1
Views: 723

Re: Issue with entering into empty cell (PAx 2.0)

Yup, not sure if it is a feature or a bug either, certainly its annoying. Our experience is that it only happens if you start with a slice / DBRW, remove some cells to do some pure excel work and then PAx adds back the DBRW. I assume its an attempt to provide some protection from users deleting form...
by Steve Rowe
Wed Nov 21, 2018 8:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives on Network vs Stand-Alone
Replies: 9
Views: 660

Re: TM1 Perspectives on Network vs Stand-Alone

Hi Judging by what is showing in the Cognos Configuration you are running two "full" TM1 servers that anyone can connect to. SData is the sample DB and can probably turned off and set to manual. CFB is your own content that you have built, this is running on the same hardware from which you took the...
by Steve Rowe
Tue Nov 13, 2018 8:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1server.log file not updating
Replies: 3
Views: 285

Re: tm1server.log file not updating

Hi Neelima, welcome, I've seen this happen a good amount in 10.2.2, not 100% sure of the reason but it may happen because someone opens the file from the OS. The only way to recover (that I know of of) is to restart the DB. We often noted that the DB would fail sometime after the logs stopped being ...
by Steve Rowe
Thu Nov 08, 2018 11:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics, pick list cube and feeders
Replies: 3
Views: 394

Re: Planning Analytics, pick list cube and feeders

Hi, There is a tm1 cfg ForceReevaluationOfFeedersForFedCellsOnDataChange . I don't think it applies in your situation since the initial feeder is not firing. I just mentioned it to qualify my statement that feeders fire when a cell goes from empty to populated. Suggest you post the detail of what yo...