TM1 Forum

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.

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...

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...

You could joining text strings and using Char(39), for example 'SomeText' | Char(39) | 's String'

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...

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...

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 ...

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.

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...

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...

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',...

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.

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...

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...

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.

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...