Search found 134 matches

by blackhawk
Wed Oct 30, 2019 2:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Practice : Migration into a production environment
Replies: 7
Views: 11092

Re: Best Practice : Migration into a production environment

Beyond Compare will compare dimensions. It is limited, so for instance if a dimension in PROD is routinely updated with new elements, BC's effectiveness is limited very quickly. With regards to WinMerge, one gets what one pays for. For example, I grew up on a farm and there are reasons why we used ...
by blackhawk
Tue Oct 22, 2019 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Practice : Migration into a production environment
Replies: 7
Views: 11092

Re: Best Practice : Migration into a production environment

While you certainly can do it manually, it is error prone, and it doesn't catch things that are data and metadata related. Using Beyond Compare or WinMerge tools are great for processes and rules, but when it comes to comparing dimensions, or attribute data, or even cube data, that is where the manu...
by blackhawk
Wed Aug 28, 2019 5:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 22134

Re: RunProcess explanation

The biggest problem with this new command is there is no way to know when all of them are done so that you can do the next sequential action. For example, after 12 months are loaded, how do you then kick of an allocation script, or a email saying everything is fine. You have to end up jumping throug...
by blackhawk
Mon May 06, 2019 4:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Docker & McAfee on Windows Server
Replies: 18
Views: 11256

Re: Docker & McAfee on Windows Server

For us, it is not at install time (I think we have put in the filters for that part), it is primarily at startup time for PAW. Anytime the PAW server needs to be restarted or if we have to upgrade it or just reboot, we run into this issue. What we end up doing is disabling the scanner, and that (som...
by blackhawk
Sat May 04, 2019 4:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Docker & McAfee on Windows Server
Replies: 18
Views: 11256

Re: Docker & McAfee on Windows Server

I have not specifically had that error, but I can tell you McAfee and PAW/Docker do not play well together. We are consistently seeing 80-100% CPU on McAfee services and oftentimes it prevents PAW from even starting all of the services...due to timeouts. I have never had great experiences with McAfe...
by blackhawk
Wed Apr 03, 2019 1:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI performance drops dramatically during execution
Replies: 6
Views: 3210

Re: TI performance drops dramatically during execution

The cube was created in PA (only the TI was migrated) and actually, years ago, the 10.2 cube had its dimensions reordered; I just did not check or consider that initially in PA. We kind of worked our way into by taking the DATA procedure code out and putting in back in one section at a time until w...
by blackhawk
Tue Apr 02, 2019 11:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI performance drops dramatically during execution
Replies: 6
Views: 3210

Re: TI performance drops dramatically during execution

Almost embarrassed to say it. The problem was the cube needed the dimensions re-ordered. Took care of it. One of those things I just do not think about often enough. Thanks, @bgregs, for looking over my shoulder on this one... Glad you have it resolved, however, I am not sure I follow why that woul...
by blackhawk
Tue Apr 02, 2019 7:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI performance drops dramatically during execution
Replies: 6
Views: 3210

Re: TI performance drops dramatically during execution

[*] It processes the first 160549 records in the Data procedure at a rate just shy of 11,000 records per sec. [*] Starting with record 160550, the processing speed drops to between 16 and 20 records per sec. Yeah. That is unusual to be sure. It is behaving like the first 160k records are being cach...
by blackhawk
Tue Mar 19, 2019 7:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does anyone know how to run 2 PAW instances on same server?
Replies: 11
Views: 6346

Re: Does anyone know how to run 2 PAW instances on same server?

Right, IMO, IBM made a mistake architecting this application in Docker.... Don't get me started! Agreed, I think the thought was to split everything up so that they could expand to a swarm and try to blow out the footprint. However, there are only a few cases where this is truly needed and I think ...
by blackhawk
Tue Mar 19, 2019 5:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does anyone know how to run 2 PAW instances on same server?
Replies: 11
Views: 6346

Re: Does anyone know how to run 2 PAW instances on same server?

IMHO, not being able to do this misses a major goal of application virtualization.. I believe one of the goal of Docker is to make virtualization more computing efficient by sharing the O/S host and financial efficiency by not having to pay for multiple operating system licenses. If IBM had made PA...
by blackhawk
Tue Mar 19, 2019 4:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does anyone know how to run 2 PAW instances on same server?
Replies: 11
Views: 6346

Re: Does anyone know how to run 2 PAW instances on same server?

But load balancing doesn't require a separate instance of PAW. That is supposed to be handled on the same instance, just, as you say horizontally scaled. Remains to be seen how that is actually accomplished :shock: Two instances on the same server is more akin to a DEV and QA instances where the env...
by blackhawk
Tue Mar 19, 2019 3:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does anyone know how to run 2 PAW instances on same server?
Replies: 11
Views: 6346

Re: Does anyone know how to run 2 PAW instances on same server?

The easiest way to do this is to run two VMs on the same machine that have docker installed in each one. By doing that, each will get a different IP and have their own environment to run in. Trying to share multiple instances in the same docker host is going to be trouble. I personally prefer Hyper-...
by blackhawk
Thu Feb 28, 2019 3:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Integrate TM1 with SAP Data Services(BODS)
Replies: 2
Views: 2276

Re: Integrate TM1 with SAP Data Services(BODS)

Arb1486, I have never used BODS, but there are a few options for TM1 for getting at the data: If BODS supports OLEDB for OLAP you can connect directly to TM1 and access the data as a multidimensional datasource. If BODS supports ODBC, you can use a third party connector, such as TM1Connect (www.tm1c...
by blackhawk
Fri Feb 23, 2018 7:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift
Replies: 6
Views: 4198

Re: TM1 10.2.2 Turbo Intergrator unable to connect Amazon Redshift

Thush_CMB: You say it ran successfully previously? Perhaps an application-based security/firewall change on the server? Is the TM1 Service tied to a network account? Could that network account password have been changed but TM1 instance was never cycled to re-load it's authentication? i.e. Lost its ...
by blackhawk
Wed Sep 21, 2016 2:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does TM1 10.2.2 support Excel 2016 ?
Replies: 14
Views: 14676

Re: Does TM1 10.2.2 support Excel 2016 ?

From my experience, TM1 10.2.2 Perspectives seems to run fine in 2016. You get the usual occasional crashes and odd behavior sometimes on views as dimensions are updated, etc. However, what DOES NOT work, is Cafe. Cafe will not start if it doesn't recognize the version of excel and it seems that 201...
by blackhawk
Fri Sep 09, 2016 3:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSL breaks on Nov 24 (TM1 SSL Certificates Expire on 24 November)
Replies: 164
Views: 122300

Re: SSL breaks on Nov 24

I confirmed with IBM yesterday that they are releasing a new 1024 bit certificate, that will allow existing users (including 9.5) to remain untouched in terms of software upgrades. The new certificate is going to be part of an interim fix for 10.2 but may also be issued separately for those who cann...
by blackhawk
Thu Aug 04, 2016 12:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to drill/get decendents of multiple consolidated elements
Replies: 9
Views: 7549

Re: MDX to drill/get decendents of multiple consolidated elements

Interesting...not sure why someone didn't mention this earlier, but TM1DrillDownMember takes a set as a parameter, so to drill down on multiple elements, why not just use the set notation? TM1FilterByLevel( TM1DrilldownMember( { [CostCenter].[CCLV1], [CostCenter].[CCLV5], [CostCenter].[CCLV7] }, ALL...
by blackhawk
Mon Aug 01, 2016 5:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning to TM1 using Performance Modeler
Replies: 6
Views: 4374

Re: Planning to TM1 using Performance Modeler

I totally agree with "tomok", in fact, there are a lot of things you have to do in your TM1 models to get them to "fit" into the paradigm that contributor operates which go against the natural behavior of a good clean TM1 model. I find many customers appreciate the true TM1 model...
by blackhawk
Fri Jul 22, 2016 7:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How do YOU keep track of changes?
Replies: 16
Views: 11959

Re: How do YOU keep track of changes?

George, The TI coding may work fine for incremental changes to the system. Few dimensions here...few elements there. But what about dimensional re-orgs? What about attribute values and cube values? Now you have to either write a potentially gargantuan TI script or you have to start creating data fil...
by blackhawk
Thu Jul 21, 2016 4:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How do YOU keep track of changes?
Replies: 16
Views: 11959

Re: How do YOU keep track of changes?

Actually, there is a utility out there for visually comparing objects between TM1 servers (see www.TM1Compare.com). It does all the visual deltas (including things like attributes, cube data, application objects, etc.) and lets you examine what changed and then copy them to the destination server. I...