Search found 260 matches

by Gregor Koch
Thu Sep 19, 2013 10:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Admin server "ferst start error"
Replies: 5
Views: 3838

Re: Tm1 Admin server "ferst start error"

Hi
You question confuses me but here is the comment:
maybe start here
http://pic.dhe.ibm.com/infocenter/cbi/v ... 40120.html
by Gregor Koch
Thu Sep 19, 2013 2:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Large Dynamic Subset
Replies: 16
Views: 8436

Re: Large Dynamic Subset

lotsaram, you are such a killjoy. why did you clear things up, i was so hoping for yet another 270 degree turn in what the actual problem is.

abinaya, please don't tell us how you actually did it. some secrets should remain untold.
by Gregor Koch
Thu Sep 19, 2013 1:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: mdx issues
Replies: 7
Views: 5208

Re: mdx issues

Giggle. Evgeny, try something like this. TM1Member(TM1SUBSETALL([Period]).Item([System Info].([System Parameters].[Current Reporting Period],[System Info Measure].[String])) ,0) Given you have a System Info Measure dimension in your cube with an element 'String'. This is not tested exactly like that...
by Gregor Koch
Fri Sep 06, 2013 12:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders problem
Replies: 17
Views: 10730

Re: Feeders problem

So.... what was your issue dilip?
Which part of that answer were you looking for?
And with which part have you solved your problem?
by Gregor Koch
Mon May 27, 2013 9:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with Drill-Through
Replies: 7
Views: 7573

Re: Problem with Drill-Through

You could just strip off the spaces (blanks) and use that. E.g salesmeasures should work.
by Gregor Koch
Sat Mar 09, 2013 3:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1 server crashed due to excel work
Replies: 2
Views: 2290

Re: tm1 server crashed due to excel work

Hi, Do you have a specific problem with a specific version of Excel or specific Version of TM1? Or are you just curious whether there ever were instances in all possible combinations of TM1 and Excel? If the former is the case then try and describe it more specifically. In both cases try a search on...
by Gregor Koch
Tue Dec 11, 2012 11:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to find who run a TM1 DB Service?
Replies: 4
Views: 3257

Re: How to find who run a TM1 DB Service?

Is the TM1 service set to start 'automatic' and the machine was restarted? I don't know how many people can log on to your server machine but usually this a relatively small group of which I would expect they know what they are doing. That includes letting other people know when they randomly start ...
by Gregor Koch
Tue Dec 11, 2012 11:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Relative Proportional Spread Codes
Replies: 2
Views: 2875

Re: Relative Proportional Spread Codes

Hi, I guess the reasoning why the RPS is only available through the context menu is that compared to 'simple' spreads like Proportional Spread you need to provide the details (possibly another cube) of what you want to base your spread on. The list of shortcuts can be found in the documentation. Btw...
by Gregor Koch
Fri Oct 05, 2012 1:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Urgent here -----After migrated 90 to 952 getting errors
Replies: 4
Views: 3657

Re: Urgent here -----After migrated 90 to 952 getting errors

I would be really curious whether you actually went ahead into production and how you went.
by Gregor Koch
Fri Oct 05, 2012 12:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: value compared to the dimension member
Replies: 8
Views: 4744

Re: value compared to the dimension member

Sorry Cog1, but I really had to laugh about this post. I am still smiling while I write this. You'll find that you will get a lot better answers if you give more detail in regards to why you need to do this, what kind of model this is for, what you have tried (Rules, Turbo Integrator) to achieve thi...
by Gregor Koch
Fri Oct 05, 2012 12:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1xl.ocx error
Replies: 8
Views: 6631

Re: tm1xl.ocx error

Hi i am getting this error when I tried to open the excel file in TM1 web application folder. The version of TM1 is 9.5 and excel is 2010. Obviously you don't get the error you are showing in your screenshot when you are doing the above - you get it when you manually try an register the ocx. And thi...
by Gregor Koch
Thu Oct 04, 2012 2:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Checking if 9.5.2 Fix Pack 2 has been installed?
Replies: 3
Views: 2804

Re: Checking if 9.5.2 Fix Pack 2 has been installed?

Hi
Have a look here

http://www-01.ibm.com/support/docview.w ... 63#coretm1

Unfortunately the list stops at FP1 but I would say that 9.5.2 FP 2 should be something like this

9.5.20202.24001

Cheers
by Gregor Koch
Thu Sep 27, 2012 1:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need idea on how to measure timestamp duration
Replies: 2
Views: 2596

Re: Need idea on how to measure timestamp duration

Hi, In the end I would do the transformation into hours at load time unless you will also be planning and forecasting on a minute level, which is unlikely. If it is a pure reporting cube definitely at load time. If you are an absolute beginner and also have no experience with other ETL tools you mig...
by Gregor Koch
Thu Sep 20, 2012 7:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feed based on Selected element from Picklist cube
Replies: 6
Views: 4685

Re: Feed based on Selected element from Picklist cube

Hi I guess my post comes too late and might be off the mark anyway, but... From what I understand, what you are doing in you reporting cube is A. Consolidate the numbers of the source accounts to a higher level and B. and at least for the calc that you show you are only ever using a specific year as...
by Gregor Koch
Wed Jul 25, 2012 11:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Attributes in TM1
Replies: 5
Views: 3613

Re: Attributes in TM1

Just started a few days back and 'need to do some project Monday'.
Good luck.
by Gregor Koch
Wed Jul 25, 2012 7:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Asciioutput issue
Replies: 13
Views: 9242

Re: Asciioutput issue

Hi
Put a

count = 0;

in the Prolog tab and move your

count=count+1;

to the very top of your data tab (where you have your asciioutput).
by Gregor Koch
Tue Jul 24, 2012 1:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Grabage memory runs away
Replies: 9
Views: 6978

Re: Grabage memory runs away

That was my opinion too, but a colleague of mine says that it's only by rebooting the server machine (not only TM1) that garbage memory will be given back. What do the others think? Once the TM1 server stops, once the service is no longer running, once it has ceased to exist from the point of view ...
by Gregor Koch
Tue Jul 24, 2012 12:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Gah...View display issues
Replies: 6
Views: 3946

Re: Gah...View display issues

I have a 14d cube, the last dim being a measure dim with some string elements in it. Any thoughts? This is a very long shot as well but are the dimensions exactly the same on the servers e.g. the (2nd) dimension in question has a sneaky String element in it? I had a weird one before where there wer...
by Gregor Koch
Mon Jul 23, 2012 12:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dealing with big views
Replies: 5
Views: 4487

Re: Dealing with big views

Maybe try and upgrade to 9.5.2 FP2. As PM49801 apparently (I have not tested this) is fixed there. Could be your issue.