TM1 Forum

well if i could get in to the old forums i'd say thanks to Mike for all his hard work and putting up with us lot, but i can't :evil: As for the community pages, i'm not touching them until my privacy is protected. Slow connections i can deal with but having my email address openly published without ...

I've got a situation where i'd like to be able to use some formulae in Excel that only work on the element name, but i might have values that are aliases of those elements. I know TI has DimensionElementPrincipalName, but does anyone know of a way to get the same kind of functionality within Excel?

Not had a response from either Applix or Cognos email addresses yet, but i'm suspecting some mixup where they think i'm no longer responsible for TM1 here. We've had a change in the licenising here and i've been nervous that our IT mob haven't been on the ball where payments and responsibilities are...

What the hell??

Can anyone else get in to the old forum OK? i'm trying to login and it says "user unknown" despite the fact that when i asked it to remind me of my user id and password, it returned them in an email fine!!! i think someone is trying to tell me something...

the webserver will require Excel loaded on it too

cross-post from the soon to be deceased Applix forum :o Troublesome Characters -------------------------------------------------------------------------------- No, not Mr Kirk :lol: but the wonderful non-alphanumeric characters that if you are not careful will cause all sorts of problems. If someone...

damn, i can't post the TM1pedia and pass it off as my own work now!!

(only kidding Duncan) nice to see you back in the land of OLAP

Orrrr you could use the addin i created and demo'd at the "TM1 User Conference of the North" last year :D This puts a drop down box in to the menu bar with 2 options, calc suppress ON and OFF. ON will ensure any new or opened wb will have calculation turned to manual. OFF will make it auto...

...and why am i not surprised by that?

Good Mornin' Vietnaaaaaaaaaam!