Search found 534 matches
- Mon Jun 29, 2015 3:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Moving Data from TM1 to SQL DB
- Replies: 7
- Views: 5740
Re: Moving Data from TM1 to SQL DB
Could you put the SQL insert statement into a variable and ASCIIOutput the variable into a file. Make sure that you set DatasourceASCIIQuoteCharacter to '' in the prolog. Then you will see exactly what it is sending. Also it would be useful to see in detail what the characteristics of each field in ...
- Sat Jun 27, 2015 10:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Moving Data from TM1 to SQL DB
- Replies: 7
- Views: 5740
Re: Moving Data from TM1 to SQL DB
Could you also include a "describe" of the SQL table and a picture of the variables tab of the process so that we can see how the TM1 variables and the SQL fields are defined?
- Mon Jun 01, 2015 2:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Turbo Integrator Preview Function
- Replies: 8
- Views: 6205
Re: Turbo Integrator Preview Function
The key thing with manually editing .pro files (apart from don't ) is to ensure that the line count for each code section is correctly shown in the header row for that section. Each code section is identified by a header row with two numbers, the first identifying which section it is and the second ...
- Fri May 29, 2015 5:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Stargate views and }StatsByCube
- Replies: 6
- Views: 4889
Re: Stargate views and }StatsByCube
The calculation threshold affects when individual calculated or aggregated cells are stored in the calculation cache, which is completely separate from the view cache, which is controlled by the VMM and VMT parameters. In reality they are related as if you have cached stargates it can make individua...
- Fri May 29, 2015 2:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Stargate views and }StatsByCube
- Replies: 6
- Views: 4889
Re: Stargate views and }StatsByCube
I presume you turned monitoring on for the server and waited a minute then refreshed.
- Fri May 29, 2015 8:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1server.log : File Format is too old
- Replies: 3
- Views: 4457
Re: TM1server.log : File Format is too old
Remember - take backups before you change anything, and don't get sucked in to spending too much time.
https://xkcd.com/356/
https://xkcd.com/356/
- Thu May 28, 2015 1:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1server.log : File Format is too old
- Replies: 3
- Views: 4457
Re: TM1server.log : File Format is too old
One thing you could do is to look into some working .cub files with a hex editor and see if there is a common byte pattern at the front, which would probably be some sort of internal file format/version stamp. If you find that all the valid .cub files start with the same few bytes you could look at ...
- Tue May 26, 2015 11:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Server crash caused(?) by "Group index is out of bounds"
- Replies: 3
- Views: 3096
Re: Server crash caused(?) by "Group index is out of bounds"
Given that the server died, and that these are messages from the server log, it seems quite likely that "TM1.Client" means that this is an error raised by a server class for handling the interaction with the client. One way to test this would be to increase the log level of TM1.Client (to ...
- Tue May 19, 2015 7:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: in-cube calculation referring to another slice
- Replies: 5
- Views: 4197
Re: in-cube calculation referring to another slice
I have a vague memory that the new "In cube calculation" feature of Performance Modeler has a slightly different syntax, but that it generates normal rule statements under the cover. Perhaps there is an IBMer or IBM Partner out there who is familiar with demonstrating it and can confirm or...
- Fri May 15, 2015 12:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to enable MTQ in Cognos 10.2.2?
- Replies: 7
- Views: 7468
Re: How to enable MTQ in Cognos 10.2.2?
This is the best post on the forum about logging stargates.Stanislav2 wrote:Can you please point me to some documentation how to do this?
- Fri May 01, 2015 3:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to filter #NA (i.e. UNDEF) values in TI
- Replies: 10
- Views: 8806
Re: How to filter #NA (i.e. UNDEF) values in TI
If the exact value you are seeing is 4.94066e-324 then check whether you have (or have ever had) UNDEFVALS in the cube rule. This is the value TM1 uses to represent a null cell when UNDEFVALS is specified.
[EDIT] and BTW another interesting link
[EDIT] and BTW another interesting link
- Wed Apr 22, 2015 8:38 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to filter #NA (i.e. UNDEF) values in TI
- Replies: 10
- Views: 8806
Re: How to filter #NA (i.e. UNDEF) values in TI
I think you need ISUND.
- Mon Apr 13, 2015 7:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Checking for a valid date
- Replies: 10
- Views: 6755
Re: Checking for a valid date
or an alternative picklist cube rule might be ...
Code: Select all
[] = S:SUBST( 'static: 1: 2: 3: 4: 5: 6: 7: 8: 9:10:11:12:13:14:15:16:17:18:19:20:21:22:23:24:25:26:27:28:29:30:31', 1, 6 + 3 * (some expression returning the number of days) );
- Mon Apr 13, 2015 9:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 web 10.2.2 memory leaks
- Replies: 8
- Views: 11007
Re: TM1 web 10.2.2 memory leaks
Excellent. Looks as if the new job has taught me something useful after all.
- Fri Apr 10, 2015 9:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CellputN server crash
- Replies: 3
- Views: 3357
Re: CellputN server crash
So how is the picklist defined? If it is in a picklist cube then when you write to a cell you are executing the rule in the picklist cube to determine the possible options for the cell. There are circumstances (infinite recursion used to be one) in which that can kill the server.
- Wed Apr 08, 2015 4:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Weird Consolidation Behavior
- Replies: 5
- Views: 4035
Re: Weird Consolidation Behavior
The way the rule is written it seems that you are calculating the ratio for "all regions" and applying it to every region. Is this what you had intended? Have you done a trace as suggested by tomok to check that this is the actual statement that is being used for the cell in question? In o...
- Wed Mar 25, 2015 11:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ascii Output - Getting Repetative Data
- Replies: 4
- Views: 3359
Re: Ascii Output - Getting Repetative Data
Read through this post and everything linked from it. This is a common problem discussed in this forum frequently.
- Fri Mar 20, 2015 2:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 web 10.2.2 memory leaks
- Replies: 8
- Views: 11007
Re: TM1 web 10.2.2 memory leaks
Here is an interesting link http://www-01.ibm.com/support/knowledgecenter/SS7JFU_6.1.0/com.ibm.websphere.express.doc/info/exp/ae/tprf_tunejvm_v61.html The particularly interesting bit is here -Xmn This setting controls how much space the young generation is allowed to consume on the heap. Properly t...
- Wed Mar 18, 2015 4:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Fix Pack Releases: 10.2 Series
- Replies: 49
- Views: 299880
- Sun Mar 15, 2015 3:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 web 10.2.2 memory leaks
- Replies: 8
- Views: 11007
Re: TM1 web 10.2.2 memory leaks
It is possible that there is not actually a memory leak, but instead that a large amount of memory has been allocated to Tomcat and the Java run-time is not doing garbage collection because it doesn't need to. Is there any way you can find and post the Java start-up options?