Search found 108 matches

by Catherine
Fri Sep 30, 2011 3:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: managing tm1p.ini with two TM1 applications
Replies: 4
Views: 1251

managing tm1p.ini with two TM1 applications

Hi, We currently have some users using a TM1 application under Citrix, with TM1 version 9.4.1. We are going to implement a new TM1 application, with TM1 version 9.5.2. The access to the new application is done through different Citrix servers. So it is not a problem to have two different versions. (...
by Catherine
Fri Sep 30, 2011 3:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel TM1 Undo Level
Replies: 4
Views: 2264

Re: Excel TM1 Undo Level

Hi, I've just gone through your post, searching for answers to another question... I met exactly the same "problem" a year ago. IBM said it is not a bug, and gave me the following explanation: "The macros of the TM1 Excel Add-In (bin/tm1p.xla) do intercept events in Excel, and for some events, repla...
by Catherine
Tue Sep 20, 2011 3:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM difference between cube and instance
Replies: 4
Views: 1172

Re: RAM difference between cube and instance

The largest contributor to garbage memory is redundant processing of feeders at server startup, particularly when using multi-threaded load. At server startup, I have no problem. Memory in Garbage is very small. And I don't use multi-threaded load. My problems appear when I run my processes during ...
by Catherine
Tue Sep 20, 2011 9:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders when stetting out rules
Replies: 6
Views: 1802

Re: Feeders when stetting out rules

Hi,

I think you have to limit your feeders. Otherwise you will increase your memory used uselessly.
Let's say that when I met the same problem in the past, I did it :)
by Catherine
Tue Sep 20, 2011 8:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM difference between cube and instance
Replies: 4
Views: 1172

Re: RAM difference between cube and instance

You're right about the garbage memory. If I turn on Performance Monitor, I get the following measures: Memory Used : 29 594 Mo Memory in Garbage : 13 403 Mo TM1 operations guide defines Memory in Garbage this way: "TM1 does not release memory back to the operating system while the TM1 server is runn...
by Catherine
Tue Sep 20, 2011 8:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM difference between cube and instance
Replies: 4
Views: 1172

RAM difference between cube and instance

Hi, I have an instance where the main cube takes 15 356 Mo in RAM when I have a look at the size in Perspectives Server Explorer. (The following biggest cube takes only 26 Mo in RAM.) When I have a look at the RAM taken by the instance directly on the server, in the Task Manager or in the Process Ex...
by Catherine
Tue Sep 13, 2011 2:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: First time opening the cube takes 5mins
Replies: 12
Views: 3801

Re: First time opening the cube takes 5mins

lotsaram wrote:note a save data will also clear the cache and require rebuilding views.
I don't agree with you. A save data does not clear the cache if there is no entry in the cube.
by Catherine
Fri Sep 02, 2011 2:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Where clause in MDX statement
Replies: 12
Views: 2981

Re: Where clause in MDX statement

@lotsa, Catherine's using ODBO, so there's no 'file' to find an EOF in. But I did see her post which said performance was poor, reading - maybe - a couple of hundred strings? _Why_ is ODBO so cr^p? ODBO is not that bad... The process is reading 216 000 lines, and it reads them twice because I have ...
by Catherine
Fri Sep 02, 2011 12:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Where clause in MDX statement
Replies: 12
Views: 2981

Re: Where clause in MDX statement

Be wary of reading in passwords to synchronize between servers! The encrypted password string can (and often does) contain unprintable characters which are seen by TI as file terminators which will cause the TI to quit when a file containing such a character is encountered. Thank you ! I don't seem...
by Catherine
Fri Sep 02, 2011 10:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Where clause in MDX statement
Replies: 12
Views: 2981

Re: Where clause in MDX statement

Should have been until the end of my test before posting... :oops:

It appears that the syntax "??ABC*" is accepted when saving the process, and the process runs without errors. BUT it doesn't bring me back the required elements...
It doesn't bring back any elements in fact...

Any ideas?
by Catherine
Fri Sep 02, 2011 9:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Where clause in MDX statement
Replies: 12
Views: 2981

Re: Where clause in MDX statement

Sorry I found the answer myself :)
SELECT
CROSSJOIN(
{TM1FILTERBYPATTERN( {TM1SUBSETALL( [}Groups] )}, "??ABC*")}, {[}Clients].Members}
) ON ROWS,
{{[Group].Group},{[Group].UniqueID},{[Group].Password}} ON COLUMNS
FROM [ClientGroups]
by Catherine
Fri Sep 02, 2011 9:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Where clause in MDX statement
Replies: 12
Views: 2981

Re: Where clause in MDX statement

Thank you for your quick answer. It does work and reduces significantly my process duration. Nevetheless, I do not look for group beginning with ABC but having ABC from third to sixth position. that's why I put SELECT CROSSJOIN( {TM1FILTERBYPATTERN( {TM1SUBSETALL( [}Groups] )}, " * ABC*")}, {[}Clien...
by Catherine
Fri Sep 02, 2011 8:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Where clause in MDX statement
Replies: 12
Views: 2981

Where clause in MDX statement

Hi, I would need your help in writing a "where" clause in a mdx statement. Here is the context. I'm having a process reading data in another TM1 instance through an ODBO source. I'm reading some infomation in a cube called ClientGroups, containing 3 dimensions: }Clients, }Groups and Group (this last...
by Catherine
Thu Jul 28, 2011 3:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Recalculation of Data
Replies: 3
Views: 657

Re: Recalculation of Data

Try to play with VMM parameter in the }CubeProperties cube.
I once had the same problem as you and it solved it.
by Catherine
Thu Jul 28, 2011 12:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC with a 64 bit server
Replies: 10
Views: 4891

Re: ODBC with a 64 bit server

In terms of my server crash problem, after a lot of mucking around I tried unchecking the "Use Unicode" check box and low and behold it all came right. So for some reason the Oracle driver was tripping over the unicode. I met exactly the same problem (TM1 9.5.2 64bit Server on Windows 2008 x64 Serv...
by Catherine
Wed Jul 27, 2011 2:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 crashes using Citrix
Replies: 3
Views: 1245

Re: TM1 crashes using Citrix

I met the problem with a 9.4 TM1 version / Excel 2007 on Citrix. The exact circumstances of the crash were the following: -Connect to TM1 -Open a cube view -Navigate in the view -Close the cube viewerWITHOUT saving the view We got an Excel crash. The problem only occured when the view was not saved ...
by Catherine
Wed Jul 27, 2011 8:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "0x1A" in asciioutput
Replies: 4
Views: 1199

Re: "0x1A" in asciioutput

Thank you !
by Catherine
Tue Jul 26, 2011 12:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "0x1A" in asciioutput
Replies: 4
Views: 1199

Re: "0x1A" in asciioutput

Is it the only difference between those two functions?
by Catherine
Mon Jul 25, 2011 3:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 perspective F9 calculation wierd behaviour
Replies: 8
Views: 4049

Re: Tm1 perspective F9 calculation wierd behaviour

Hello, I met this problem with 9.4 version. To know if this is the same problem, try this workaround: Instead of using a reference to the TM1Rptview cell in your DBRW formula, just use a cell containing the cube nam (Instance:CubeName), and make your DBRW use this new cell. Does it work? If yes, it ...