Search found 16 matches
- Wed Apr 18, 2012 3:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ClassFactory error in Excel
- Replies: 5
- Views: 5603
Re: ClassFactory error in Excel
It's Vista. I finally got it to work after reinstalling Excel and TM1 and then copying in MSComCtl.ocx. I had tried that before, but I guess I just needed to do a clean install first.
- Tue Apr 17, 2012 2:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ClassFactory error in Excel
- Replies: 5
- Views: 5603
Re: ClassFactory error in Excel
I wanted to check and see if anyone has come up with a solution for this. Everything was working fine and when working with an embedded excel file in powerpoint (no TM1 references, but I did have another workbook open with TM1) it crashed and from that point on I get the reference error message. I'v...
- Wed Nov 10, 2010 2:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Applications folder + Excel 2007
- Replies: 0
- Views: 1487
Applications folder + Excel 2007
I was wondering if anyone has found a solution for the following. I've been working on converting a number of our reports to Excel 2007 for use with 9.5.1. Many of these have macros so they must be saved with the xlsm extenstion if I also want to keep some of the features unique to 2007 such as ifer...
- Wed Sep 29, 2010 9:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Single Quote in Element Name
- Replies: 5
- Views: 4850
Re: Single Quote in Element Name
You could joining text strings and using Char(39), for example 'SomeText' | Char(39) | 's String'
- Fri Sep 24, 2010 1:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Multiple Versions on Same Computer
- Replies: 13
- Views: 7655
Re: Multiple Versions on Same Computer
I never was successful in getting this to work. I tried the following steps today in an attempt to have both 8.43 and 9.5.1 on the same machine. Some notes: Laptop has both Excel 2003 and Excel 2007 installed (OS is Vista). Goal is to temporarily use 2003 with 8.43 and 2007 with 9.5.1 I'm in the pro...
- Fri Jun 11, 2010 7:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - StrToMember
- Replies: 2
- Views: 6624
Re: MDX - StrToMember
Thanks for the replay Mike. Using a dimension attribute works. I believe you are correct that when you reference a cube it expects to return a value instead of a string (and I don't see a way to differentiate what the intended result is). I took the sample in the MDX Primer guide and build a cube wh...
- Thu Jun 10, 2010 7:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - StrToMember
- Replies: 2
- Views: 6624
MDX - StrToMember
I'm trying to create an MDX subset which sorts the members of dimension based on their values for a particular month the value of which is contained in a separate cube. The following is the MDX expression I've developed, which is accepted as a valid expression however the result is not sorted based ...
- Thu Apr 29, 2010 3:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Totals for Dynamic Subsets
- Replies: 5
- Views: 4810
Re: Totals for Dynamic Subsets
Thank you. That seems to work. I had no idea that you could reference a named subset in a DBR formula. Guess I completely missed that in the manual.
- Wed Apr 28, 2010 1:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Totals for Dynamic Subsets
- Replies: 5
- Views: 4810
Totals for Dynamic Subsets
I have a cube used for supplier information such as sales and inventory. I've created a dynamic subset which uses parameters (pulled from another cube) to generate a listing of suppliers with inventory turns < 4 based on the parameters specified which are division and time. Currently I get the total...
- Sun Feb 07, 2010 8:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Multiple Versions on Same Computer
- Replies: 13
- Views: 7655
Multiple Versions on Same Computer
I'm trying to install TM1 perspectives 9.4 on my laptop for testing purposes. I'm currently using 9.1 and want to keep that version. When I run the install of 9.4 it seems to automatically uninstall 9.1 even though I'm pointing to a different directory on the install. Has anyone installed multiple v...
- Thu Oct 22, 2009 2:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SCAN not working
- Replies: 8
- Views: 9269
SCAN not working
I'm not sure what I'm missing here, but I'm using the following to filter out a listing of accounts: # Get principle element name instead of using alias sTM1Acct = GetPrincipleElementName('All_IS_Account', v4) ; # Filter out non general ledger accounts # Scan(substring, string) If (Scan('Case Sale',...
- Fri May 15, 2009 2:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Except Function
- Replies: 3
- Views: 13345
Re: MDX Except Function
Thanks Marcus. That was one of the alternative methods I tried, but I get the same results. Accrued Bonuses is still included in the returned subset.
- Fri May 15, 2009 1:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Except Function
- Replies: 3
- Views: 13345
MDX Except Function
I'm having a little problem in using the Except statement to return a MDX subset. I want to return the children of an element (Accrued Expenses) with the parent (Accrued Expenses) and one of the children (Accrued Bonuses) excluded from the result. I tried the following and while it does exclude Accr...
- Fri Aug 08, 2008 6:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Neophyte
- Replies: 1
- Views: 2769
MDX Neophyte
I'm having a problem coming up with the right syntax for retrieving a value as part of a MDX query. The following works fine: {TOPCOUNT( {EXCEPT({DRILLDOWNMEMBER({[Corporate Suppliers].[All Suppliers]},{ [Corporate Suppliers].[ALL SUPPLIERS]})}, {[Corporate Suppliers].[ALL SUPPLIERS]})}, 25, [Corpor...
- Wed Jul 02, 2008 12:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Copy & Paste into DBRW
- Replies: 1
- Views: 3108
Copy & Paste into DBRW
In the old forum, Ben Hill was kind enough to post some code that enabled copy & paste into DBRW formulas. Ben, if you don't mind could you please post that to this forum as well since we weren't able to bring over all the attachments from the old forum. Thank you.
- Thu Jun 19, 2008 7:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: IncSight Engine
- Replies: 7
- Views: 5201
Re: IncSight Engine
I believe this was written by Charles Kyd. It had a lot of neat little tools and utilities such as being able to parse a formula and convert all TM1 formulas to values. However, unlike alot of the other functions that I've seen posted I believe it relied on VBA and not the TM1 API to perform this. I...