Search found 1015 matches

by qml
Mon Nov 21, 2016 12:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Issue Configure TM1RunTI.exe after update to SSL
Replies: 5
Views: 3223

Re: TM1 Issue Configure TM1RunTI.exe after update to SSL

now with this update to SSL There are a few possible ways to update/replace the expiring SSL certs, so you need to say exactly which one you chose. The changes to tm1runti.exe calls will depend on which method you went with. The 'certversion=2' change only applies to a situation where you have swit...
by qml
Mon Nov 14, 2016 9:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSL Breaks RUNTI - (TM1 API Error) SystemServerClientNotFound Server connection failed
Replies: 6
Views: 5148

Re: SSL Breaks RUNTI - (TM1 API Error) SystemServerClientNotFound Server connection failed

Further the complication arises due to TM1 authenticating through a COGNOS BI server. So this is be mostly different to other installations who donot have a COGNOS BI installation. The obvious question is: did you update the TM1 Client files on the Cognos BI server? That needs to be done too if you...
by qml
Mon Nov 07, 2016 11:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Visualizing and Analyzing TM1 Data Flow
Replies: 6
Views: 5921

Re: Visualizing and Analyzing TM1 Data Flow

There are commercial products out there that do similar things e.g Cubewise's Pulse for TM1 (I am not affiliated). But of course it's a great idea to have an open-source solution for relationship charting, especially for those that don't have the need for something as feature-rich as a commercial pr...
by qml
Mon Nov 07, 2016 9:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: function opposite Char()
Replies: 3
Views: 2709

Re: function opposite Char()

The function you're looking for is CODE.
by qml
Thu Oct 27, 2016 6:52 pm
Forum: OLAP Jobs
Topic: NEW COGNOS TM1 PERMANENT POSITION DUBLIN
Replies: 1
Views: 4644

Re: NEW COGNOS TM1 PERMANENT POSITION DUBLIN

Talent International wrote:Salary: £80,000-£100,000 Euros
Is this meant to be reflective of the fact that sterling is within a whisker of parity with the euro? ;)
by qml
Wed Oct 26, 2016 9:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM Planning Analytics On Prem
Replies: 63
Views: 49065

Re: IBM Planning Analytics On Prem

The version that makes it's on premise debut "late November/early December" will be powered by TM1 v11 but known as "Planning Analytics Local Server 2.0". Make of that what you will. I don't like the idea of having parallel version numbering. It was confusing and hard to keep tr...
by qml
Fri Oct 14, 2016 8:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reducing Time to Process Feeders
Replies: 15
Views: 11117

Re: Reducing Time to Process Feeders

How exactly do you see that from the stats table? They have ca 36x so many fed cells as numeric. so what if there are 36 currencies calculated from local currency with rules :D I understand that from earlier posts it turns out it may be an overfeeding, maybe TI or implicit C: feeders would help, bu...
by qml
Fri Oct 14, 2016 3:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reducing Time to Process Feeders
Replies: 15
Views: 11117

Re: Reducing Time to Process Feeders

In the past we had other cubes designed to use feederless rules to perform the FX translations, however we saw massive performance degradation when attempting to consolidate across multiple dimensions (i.e., feederless rules work fine if viewing the calculated data at leaf level, but when we start ...
by qml
Fri Oct 14, 2016 2:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reducing Time to Process Feeders
Replies: 15
Views: 11117

Re: Reducing Time to Process Feeders

We are looking into alternative designs, potentially a TI driven solution rather than a rules driven solution, but the client has a strong desire for real-time calculations so rules were the obvious choice when the system was being designed a long time ago. Your stats do look like there is some mas...
by qml
Fri Oct 14, 2016 11:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Top 10 Projects in a TM! Perspectives report
Replies: 2
Views: 2243

Re: Top 10 Projects in a TM! Perspectives report

The simple and quick way is as follows. Build a Cube View with Projects on rows and the remaining dimensions as title or column dimensions. Right-click anywhere within the column that contains the measure which you want the Top 10 to be applied to and select 'Filter...'. Apply a Top Count filter wit...
by qml
Fri Oct 14, 2016 11:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI syntax
Replies: 2
Views: 2389

Re: TI syntax

Not sure if it makes a difference, but I’m still curious. Is there a ’correct’ way to enter syntax in TI? A very common way seems to be like below. No paces, no/limited indentations, etc. Your question isn't about syntax, but about code formatting. It's easier to popularise coding standards if IDE ...
by qml
Fri Oct 14, 2016 10:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tries & parallel loads using tm1runti
Replies: 10
Views: 5251

Re: Tries & parallel loads using tm1runti

The most optimal way to segment parallel loads is non-overlapping segments of the 1st dimension in the cube (the reordered indexing not the original). This will result in smallest, tries, smallest memory footprint, quicker writes and commits. This sounds interesting and definitely something I'd lik...
by qml
Wed Oct 12, 2016 2:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Removing leading\trailing zeroes in TM1
Replies: 3
Views: 3807

Re: Removing leading\trailing zeroes in TM1

First of all - this is the wrong subforum, but I'm sure an Admin will kindly move the thread.

Stripping off zeroes can be done in a few ways, but I would generally convert the string to a number and then back to a string again:

Code: Select all

sShortOrderID = TRIM( STR( NUMBR( vLongOrderID ), 32, 0 ) );
by qml
Wed Oct 12, 2016 9:23 am
Forum: General
Topic: Request for help in a Quixotic quest against a useless Microsoft dialog
Replies: 6
Views: 58209

Re: Request for help in a Quixotic quest against a useless Microsoft dialog

Both upvoted. Although a lot more people will have to donate their clicks if these ideas are to get to the level of popularity of, say, Esperanto support for orthography and grammar for office and Windows.
by qml
Mon Oct 10, 2016 12:16 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: 122315

Re: SSL breaks on Nov 24

What's your understanding on that limitations? The manual switch to v2 certs approach you have chosen is absolutely fine for pre-10.2.2 FP4 versions, including yours, except for the following components: Ops Console, PmHub, CAFE. So if you are not using them, then you need not worry. Here is a quot...
by qml
Fri Oct 07, 2016 7:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Feeders - Rule is nested If's and Source Cube is a Control Cube.
Replies: 27
Views: 14384

Re: TM1 Feeders - Rule is nested If's and Source Cube is a Control Cube.

It's too bad that someone didn't know or think to tell me that, but in any case thank you for the help you did provide. It's also a pity you did not describe better what you were trying to do. There is no mention of Cognos BI in your original post. There is some mention of Framework Manager and Rep...
by qml
Wed Oct 05, 2016 3:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Numeric values not copying from source to target elaments
Replies: 44
Views: 15912

Re: Numeric values not copying from source to target elaments

Steve Rowe wrote:Suggest you apply a liberal sprinkling of asciioutput commands to your code so that you can debug it and understand where it is going wrong.
Hi Abdul,

That is what I suggested some 15 posts ago, but it doesn't seem to have struck a chord.
by qml
Wed Oct 05, 2016 2:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Numeric values not copying from source to target elaments
Replies: 44
Views: 15912

Re: Numeric values not copying from source to target elaments

Abdul, I think you have me confused with someone else. i have multiple source customers and multiple target customers being selected in the control cube , so i need multiple elements to be added in my subset. when i use the above code it is creating the subset with the last element selected in the ...
by qml
Wed Oct 05, 2016 1:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Numeric values not copying from source to target elaments
Replies: 44
Views: 15912

Re: Numeric values not copying from source to target elaments

Actually in the above code when i am trying to create the view it is throwing the below error ; Position of elements exceeds the number of elements in subset + 1. Change the below line: SubsetElementInsert( pDimension, cTempSubFrom, pSourceCustomer, i ); to this: SubsetElementInsert( pDimension, cT...
by qml
Wed Oct 05, 2016 1:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Roll up in subset using MDX query
Replies: 6
Views: 5452

Re: Roll up in subset using MDX query

I created a MDX query to find out the lines which is having type as categoryA and it works fine,but what Im missing is the roll up total.. Please let me know if the total can be done? THE way to aggregate numbers in TM1 is via consolidations defined in dimensions. Other ways exist, but always have ...