Search found 58 matches

by Mems
Thu Jul 12, 2012 9:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CosolidateChildren error
Replies: 9
Views: 5386

Re: CosolidateChildren error

Hahahaha, ok I should get a new job :) thanks! My apologies for wasting time.
by Mems
Thu Jul 12, 2012 7:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CosolidateChildren error
Replies: 9
Views: 5386

Re: CosolidateChildren error

Any feedback, regarding alternative ways except consolidatechildren to calculate?
by Mems
Tue Jul 10, 2012 1:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CosolidateChildren error
Replies: 9
Views: 5386

Re: CosolidateChildren error

Apologies,
by Mems
Tue Jul 10, 2012 1:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CosolidateChildren error
Replies: 9
Views: 5386

Re: CosolidateChildren error

Hey, Nope I believe I have to use ConsolidateChildren https://docs.google.com/a/venncubed.co.za/spreadsheet/ccc?key=0Apg9YxtHGHQmdG9BUnJEdXdUczZoTExfczRlSkwwRGc&pli=1#gid=0 Please see URL I want to get the 2.39. My calcs are as follow Skipcheck; ['Case Cost' ]=['Total Activity Cost']\['Cases'] [...
by Mems
Tue Jul 10, 2012 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CosolidateChildren error
Replies: 9
Views: 5386

Re: CosolidateChildren error

David, I broke it down to just one cube to fix the error. The one extra rule. ['Inner Case Cost' ]=['Activity Cost']\['Inner Case'] Feeders; ['Inner Case' ]=>['Inner Case Cost' ] ; ['Inner Case' ] => ['Weighted Formula Calc Inners' ]; ['Inner Case' ]=> ['Weighted Inner Case Cost' ]; The cube has 6 d...
by Mems
Tue Jul 10, 2012 9:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Message, Not in Knowledge Base
Replies: 8
Views: 6188

Re: Error Message, Not in Knowledge Base

Hey All,

I have got the same error.
See http://www.tm1forum.com/viewtopic.php?f=3&t=7641

Is there a solution?
by Mems
Tue Jul 10, 2012 8:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Code for duplicate elements
Replies: 4
Views: 3376

Re: Code for duplicate elements

Apologies, I have a Cost Pool dimension with 8 levels of data. The dimension is reshuffled each year. I want to make sure that one cost pool element is not mapped under two different levels creating a double count. Each year this takes me days to complete and I was hoping somebody could help me veri...
by Mems
Tue Jul 10, 2012 8:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CosolidateChildren error
Replies: 9
Views: 5386

CosolidateChildren error

Hey All, I am using tm1 v9.5.2 FP2, but have replicated the issue on tm1 v9.5.1 ans Express v9.5. The rule I am using is ['Weighted Formula Calc Inners'] = IF(ELLEV('Item',!Item)<>0, ConsolidateChildren('Item'), ['Inner Case Cost']*['Inner Case']); The problem being, the cube runs at about 1GB and w...
by Mems
Tue Jul 10, 2012 7:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Code for duplicate elements
Replies: 4
Views: 3376

Code for duplicate elements

Hey all,

I was wondering if someone has worked on a TI code to export multiply mapped elements to a .csv file.

Thanks,
by Mems
Mon Jul 09, 2012 1:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }StatsByCubeByClient Help please!!
Replies: 4
Views: 2676

Re: }StatsByCubeByClient Help please!!

Darkhorse,

I have recreated the issue on my side using FP2 for v9.5.2

I suggest you log a call at IBM.

Regards,
by Mems
Mon Jul 09, 2012 7:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MS Access Code to execute process
Replies: 5
Views: 4087

Re: MS Access Code to execute process

Hey All,

Thanks everything worked perfectly.

Regards,
by Mems
Fri Jul 06, 2012 7:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executive Viewer Synchronizing two differnt dimensions
Replies: 0
Views: 1454

Executive Viewer Synchronizing two differnt dimensions

Hey All,

I have client running, TM1 v9.5.2 and EV v9.5

We have to similar (Not the same) dimensions that we want to sync in EV. Is this possible?
The one dimension just have one additional level of detail.

Any help in this regard would be greatly appreciated.

Thanks,
by Mems
Wed Jul 04, 2012 3:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MS Access Code to execute process
Replies: 5
Views: 4087

Re: MS Access Code to execute process

Hey All,

Thanks for the replies.

We are running TM1 v9.5.2 HF2 at the moment. (Upgrading to 10 in the next couple of months).

So I guess the RunTi.exe will work?

I will test and give feedback.

Thanks!!!
by Mems
Mon Jul 02, 2012 10:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MS Access Code to execute process
Replies: 5
Views: 4087

MS Access Code to execute process

Hey All,

I would like to insert a piece of vb code into MS Access to execute a Tm1 process.
If anybody knows the syntax for this. It would be much appreciated.

Regards,
by Mems
Thu Apr 19, 2012 8:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is the Sandbox function possible in Executive Viewer?
Replies: 0
Views: 1735

Is the Sandbox function possible in Executive Viewer?

Please assist, My client is running TM1 Executive Viewer 9.5 All personnel are using Executive Viewer to input data (nobody except myself has access to architect\perspectives). One of the new staff members, while playing around switched on his sandbox in EV, is that even possible? I've tried finding...
by Mems
Thu May 12, 2011 1:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube and dimension name list
Replies: 3
Views: 14985

Cube and dimension name list

Is there an easy way to get all your cube names and their dimensions into excel, using TM1 v9.5.1
by Mems
Fri Apr 15, 2011 7:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SDK-ERR-0064 Installation of Xcelerator failed
Replies: 6
Views: 8309

Re: SDK-ERR-0064 Installation of Xcelerator failed

Ok, This a copy of the logfile - just cleaned up a bit. SDK-ERR-0064 Installation of Xcelerator failed: SDK-ERR-0148 Process exit code is 8 : Error: -2147217389 Error (Hex): 80041013 Source: SWbemServicesEx Description: Provider load failure Invalid Configuration section: CompilationSection or, inva...
by Mems
Thu Apr 14, 2011 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SDK-ERR-0064 Installation of Xcelerator failed
Replies: 6
Views: 8309

SDK-ERR-0064 Installation of Xcelerator failed

I am trying to install Express v9.5 on my laptop running windows 7 64-bit. The problem being that I can Install ‘Manager’, ‘Advisor’ and ‘Reporter’, but for some reason I cannot install ‘Planner’ or ‘Xcellerator’. Error message: SDK-ERR-0064 Installation of Xcelerator failed: SDK-ERR-0148 Process ex...