Search found 1426 matches

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

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

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...
by Steve Rowe
Wed Nov 07, 2018 11:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics, pick list cube and feeders
Replies: 3
Views: 156

Re: Planning Analytics, pick list cube and feeders

I can't answer your question exactly but you need to remember that a Feeder is an event that happens in the engine as opposed to a rule that defines the behaviour of a cell. So if all the things that the feeder needs to know are not known when the event happens then the feeder will not fire (correct...
by Steve Rowe
Sun Nov 04, 2018 11:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HierarchySubsetElementDelete odd behavior
Replies: 4
Views: 213

Re: HierarchySubsetElementDelete odd behavior

Don't forget that with the old style functions dimname:hiername is supported in the dimension name position, though I've not checked with this specific function.
by Steve Rowe
Fri Nov 02, 2018 8:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 DISPLAYS #N/A VALUES INSTEAD OF "0"
Replies: 3
Views: 173

Re: TM1 DISPLAYS #N/A VALUES INSTEAD OF "0"

27 dimensions !
Are you sure?
by Steve Rowe
Thu Nov 01, 2018 3:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Case Sensitive vs. TM1 10.2 not case sensitive
Replies: 6
Views: 204

Re: PA Case Sensitive vs. TM1 10.2 not case sensitive

Just double checked a=2; b=a*A; compiles just fine (in old style TI editor) but a=2; b=a*c; does not so I don't believe there is an issue The only place I have noticed case being issue is in the server name, not noticed an issue elsewhere, not even sure it is always an issue with the server name. Mi...
by Steve Rowe
Thu Nov 01, 2018 8:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Retaining lock on file
Replies: 3
Views: 157

TI Retaining lock on file

Hi, We're having an issue in TM1 11.2.00000.27 (windows server 2016 standard) where occasionally TM1 is retaining a lock on processed file. In general the file handling routines are working fine, however around 1 in 10k files (say) the TI process is retaining a lock on the file and preventing the ar...
by Steve Rowe
Tue Oct 30, 2018 12:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchies and element attributes
Replies: 4
Views: 156

Re: Hierarchies and element attributes

When I was doing my detailed testing I'm pretty sure I got to the same place. Attributes appear to be old style objects that can't be varied by hierarchy. It would appear that IBM just created all the hierarchy equivalent TI functions without considering if the objects they addressed would exist / w...
by Steve Rowe
Tue Oct 30, 2018 10:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rules - Request your guidance please!
Replies: 4
Views: 216

Re: TM1 Rules - Request your guidance please!

Hi, Any reference in a square bracket can remain unchanged. Any reference to the rebuilt cube with a DB will need to be changed so that it either has !Job Level or an explicit Job Level element in the correct position. Any references to external cubes with Job Level can have their explicit reference...
by Steve Rowe
Tue Oct 30, 2018 9:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut with Hierarchies in PA2.0
Replies: 17
Views: 425

Re: ViewZeroOut with Hierarchies in PA2.0

Its pretty hard when we are in this (hopefully) transistionary state with some objects and functions working on the old object model and some using the new. I cannot see why you would want to have leaf level elements that only exist in a Hierarchy. I am genuinely interested to know what advantage th...
by Steve Rowe
Mon Oct 29, 2018 10:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut with Hierarchies in PA2.0
Replies: 17
Views: 425

Re: ViewZeroOut with Hierarchies in PA2.0

The complexity that requires the "Other Elements" in the dimname.dimname hierarchy that the VZO can see is because dimname.dimname does not have to have all the N levels that are in dimname.HierA that you may be trying to execute the VZO against. Therefore your dimname.dimname hierarchy has to conta...
by Steve Rowe
Fri Oct 26, 2018 11:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule file mismatch in architect and .rux file
Replies: 9
Views: 227

Re: Rule file mismatch in architect and .rux file

This is usually because of a mismatch between the .blob which holds the formatting and .rux which holds the rules. When you look at the rules through the front end you are looking at the .blob, but the DB is using the .rux This can happen when rules are promoted from live to dev for example, if you ...
by Steve Rowe
Thu Oct 25, 2018 10:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to change port numbers in tm1
Replies: 6
Views: 205

Re: How to change port numbers in tm1

Hi Sparten, We've noted in recent releases that this issue occurs intermittently. The TM1 DB will be running quite happily on whatever ports it is set to run at. If it is then stopped or the box rebooted it will occasionally report this error with port number it was running on. I used to think it wa...
by Steve Rowe
Fri Oct 12, 2018 4:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to see server instances in a server, in the architect
Replies: 3
Views: 159

Re: Unable to see server instances in a server, in the architect

Usually one of these
1. Client can not see server over network.
2. Client version differences mean that they can see but not talk to either, apply the TLS switch.
3. SSL certs on client side expired, apply new certs
HTH
by Steve Rowe
Thu Oct 11, 2018 9:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Configuring PAx on https
Replies: 3
Views: 181

Re: Configuring PAx on https

You'll want to give a lot more information about what you have tried to do and what issues you are having...
by Steve Rowe
Tue Oct 09, 2018 2:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 10
Views: 284

Re: Drill-through to a cube view

! Of all the combinations we tried I don't think we tried that one. TYVM! Also thanks for the info on DBRW, shame we need to find this stuff out so indirectly. I get that this works if you want to switch from 1 hierarchy to another, does it work if you want to reference multiple hierarchies from the...
by Steve Rowe
Tue Oct 09, 2018 8:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 10
Views: 284

Re: Drill-through to a cube view

It would of course be great if we could change the view name in the returnviewhandle function. As I often find the last 10% of the design and implementation of the functionality can remove large amounts of possible use cases for the functionality. DBRW type formula and that can access hierarchies be...
by Steve Rowe
Mon Oct 08, 2018 2:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 10
Views: 284

Re: Drill-through to a cube view

AFAIK you've never been able to change the name of the view being opened, when we've wanted to heavily customise the view the user is opening you can change the subsets (and the postion?not sure I've tried) to something specific to the user at runtime. This is not normally an issue in a multi-user e...
by Steve Rowe
Fri Oct 05, 2018 9:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 pax always shows the reports as #Name?
Replies: 4
Views: 187

Re: Tm1 pax always shows the reports as #Name?

Hi this happens because all the PAx add ins are not loaded. If you have the ribbon then the .com is loaded, if the excel functions are not working then you need to check the two excel add-ins are loaded as well.

These do occasionally seem to drop out...