Search found 1499 matches

by Steve Rowe
Thu Jul 18, 2019 8:37 am
Forum: Bugs
Topic: PAx DBRW type over failure
Replies: 0
Views: 14

PAx DBRW type over failure

This impacted 2.0.42 with CAM log ins. (not tested if it happens in mode 1) When entering a number over a DBRW the formula was being over written by a value. Cause. On first log-in the issue did not show. If you close Excel and attempt to log back in you are not asked to re-authenticate but automati...
by Steve Rowe
Thu Jul 18, 2019 8:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx, authenticating with CAM and mutiple instances
Replies: 2
Views: 720

Re: PAx, authenticating with CAM and mutiple instances

This was resolved by moving to the latest versions of PAx and the TM1 DB and using the newish PMHubless connection.
by Steve Rowe
Thu Jul 18, 2019 8:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX has blank task pane
Replies: 5
Views: 671

Re: PAX has blank task pane

I think happens because you have pointed PAx at the TM1 server not the PAW server, without the PAW sever the "web" stuff doesn't work.

Also make sure you have IE11 on the client machine.

EDIT : See below, it's what JorelB says
by Steve Rowe
Thu Jul 18, 2019 8:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Occasionally stuck making ODBC connection
Replies: 5
Views: 152

Re: Occasionally stuck making ODBC connection

Hi, In my experience this usually happens because the destination server is locked performing some kind of major activity. Though you've checked to see if the connection is made is there any reason Netezza would be refusing the connection or locked in some way? I'm not aware of any to test if the co...
by Steve Rowe
Thu Jul 04, 2019 10:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder statement cleanup
Replies: 6
Views: 171

Re: Feeder statement cleanup

Wow, we're all up late!
by Steve Rowe
Thu Jul 04, 2019 9:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder statement cleanup
Replies: 6
Views: 171

Re: Feeder statement cleanup

If you've done a major rewrite then I'd suggest deleting all feeder files with the server shut down. It will sort itself out on start-up.
by Steve Rowe
Wed Jul 03, 2019 8:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM License Metric Tool?
Replies: 5
Views: 169

Re: IBM License Metric Tool?

If you need it or not depends on your licence so your partner should be able to tell you exactly if you need it or not. I would have thought that if you needed it and the audit is already underway then your going to have a potentially expensive problem. Broadly you need ILMT if you are running TM1 o...
by Steve Rowe
Tue Jul 02, 2019 8:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use subsets in DBRW
Replies: 6
Views: 454

Re: Use subsets in DBRW

The need to generate ad-hoc totals from a random lists of elements is a valid use-case, I just don't like the subset / UDC driven solution. If they are starting from scratch I think there are probably better ways we can deliver ad-hoc totals without the loss of control that subset as totals and othe...
by Steve Rowe
Mon Jul 01, 2019 11:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use subsets in DBRW
Replies: 6
Views: 454

Re: Use subsets in DBRW

I'm always curious about the desire for UDCs and avoiding setting up a true consolidation, can I ask what your use case is such that you don't want to set-up a consolidation?
by Steve Rowe
Thu Jun 27, 2019 7:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change to DimensionElementComponentAdd in PA vs 10.2?
Replies: 10
Views: 500

Re: Change to DimensionElementComponentAdd in PA vs 10.2?

Thanks for testing, so legacy code will continue to work until hierarchies exist versus the dimension.

Good
by Steve Rowe
Wed Jun 26, 2019 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change to DimensionElementComponentAdd in PA vs 10.2?
Replies: 10
Views: 500

Re: Change to DimensionElementComponentAdd in PA vs 10.2?

The second new behaviour, being unable to add an a child to an N level and so protecting the application from data loss is an "interesting" change. Whilst for many use cases it is sensible it makes other use cases much more challenging. In our code base where we want to protect the environment from ...
by Steve Rowe
Wed Jun 26, 2019 1:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 6
Views: 164

Re: Lock Contention and RollBack

What do you see against thread 2200 in TM1Top?
by Steve Rowe
Thu Jun 13, 2019 7:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI views using alternate hierarchies
Replies: 5
Views: 269

Re: TI views using alternate hierarchies

Yup, that's my understanding too I'm afraid...Hierarchies don't work with traditional views / subsets and so can't be used as a datasource...

Frustrating that the functionality is not finished...
by Steve Rowe
Tue Jun 04, 2019 2:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Method for handling Rules for Actuals/Forecast periods
Replies: 9
Views: 295

Re: Method for handling Rules for Actuals/Forecast periods

I've always been told to avoid cell security if at all possible. Is there a performance hit because of that or is it just a matter of the added complexity, don't fool with it? I think this has long been a piece of received wisdom but its possible that times have changed but I'll say up front, as li...
by Steve Rowe
Tue Jun 04, 2019 7:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Method for handling Rules for Actuals/Forecast periods
Replies: 9
Views: 295

Re: Method for handling Rules for Actuals/Forecast periods

I'm not sure I totally understand what you are asking but..... Are you using the "wrong" functionality. You get the data to the cube by the most efficient method for your design, that will vary depending on a large number of factors. Open / closed is a security issue and should be dealt with using s...
by Steve Rowe
Wed May 29, 2019 10:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders for rules in same cube with DB function.
Replies: 1
Views: 112

Re: Feeders for rules in same cube with DB function.

You've only posted one of the rule sheets so its going to be hard to tell the. Have you used the various rule trace and check rule / feeder pieces of functionality to try and diagnose the issue? Its probably an issue with a feeder statement and if you test from the source cell then you should be abl...
by Steve Rowe
Tue May 28, 2019 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI summary display
Replies: 14
Views: 830

Re: TI summary display

There is something around 7:20 that implies a known remaining run time in the video but tbh I don't believe it is possible to know this with accuracy. It's probably derived from assumptions about how much work has been requested or some other estimate. Maybe the TI is reaching out to third party for...
by Steve Rowe
Tue May 28, 2019 7:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI summary display
Replies: 14
Views: 830

Re: TI summary display

There are two issues with what you are after that mean I don't think it can be achieved without getting into the RestAPI and building your own functionality. 1. Once a user launches a TI the client session is locked there is no method to interrupt it to provide feedback on the state of the running T...
by Steve Rowe
Fri May 24, 2019 8:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: File is open in IBM Cognos TM1 Server
Replies: 3
Views: 160

Re: File is open in IBM Cognos TM1 Server

Hi Alex,

I'm not going to be much help I'm afraid but I have seen similar behaviour, erratically and infrequently, where the OS thinks TM1 still has a lock on a file that has been used as TI datasource.

Not been able to reproduce and so it has not been raised with IBM.
by Steve Rowe
Tue May 21, 2019 1:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Docker & McAfee on Windows Server
Replies: 14
Views: 461

Re: Docker & McAfee on Windows Server

Hi mce, Did you log-in and fill in the forms? I don't think that just because the path starts with hub, this relates to hub specifically.

For example this page is talking about RHEL on prem installs (I think!)

https://hub.docker.com/editions/enterpr ... erver-rhel