Search found 1015 matches
- 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...
- 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...
- 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...
- 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.
- 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
Is this meant to be reflective of the fact that sterling is within a whisker of parity with the euro?Talent International wrote:Salary: £80,000-£100,000 Euros
- 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...
- 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...
- 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 ...
- 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...
- 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...
- 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 ...
- 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...
- 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:
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 ) );
- 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.
- 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...
- 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...
- 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
Hi Abdul,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.
That is what I suggested some 15 posts ago, but it doesn't seem to have struck a chord.
- 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 ...
- 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...
- 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 ...