TM1 Forum

Hi Everyone, I Just had a lapse of memory and forgot how to grab a date string from a control cube to insert into subset expression. eg: {[DateDim].[04/06/2010]:[DateDim].[09/06/2010]} and replace hard coded date with cell references Thought it was DB('Control', 'Date1', 'Date Measure') but it must ...

don't know if everyone's tried this already, but i was using a cube slice which had several repeated elements on rows that was later merged. before the cells on rows are merged, it was copied -> then paste special 'formulas' back onto the merged cells. dbrw's can then reference the row relative cell...

Does anyone know if there is a function to run a T.I. as soon as TM1 server re-boots.
I'm trying to kick off some initialisation routines if the server goes down then re-starts (through services), and it can't
be a chore that runs periodically.

the server was running 9.0 and the clients were on 8.1.8. we have a dev' box which was upgraded to 9.4 FP1 from 9.0 (SP3). when the client was being installed, the dialog box for uid/pwd for admin came up on FP1. i just put in mine and it worked fine. (unnecessary i thought..) booting up on 9.4 FP1 ...

Hi, Does anyone have an install guide with some screen shots that I.T. can use to upgrade client/perspectives? 1 odd thing i noticed was for FP1 upgrade (after installing MR1), it asks for domain/user id, pwd !?! and if 'tm1p' was previously in the addin list in excel, it complains until you manuall...

Thanks for your views ;) If that was the case, i imagine other contributing factors could be that when i ran process monitor, server mem was at 1.3Gb and it total is 2Gb (don't have the extra 1Gb switch put in by i.t. yet). largest dimension worksheet has 36,000 lines of elements and hierarchies wit...

hi,

does 494 views create a problem? [156public, 338private]
i don't know if it's a coincidence, but when i'm logged in as me(most number of private views) - i noticed a server crash after logout.
i've since created a different username and so far so good...

many thanks

is there something built in to adomd that checks if a query returns nothing?
similar to:- if rs.recordcount = 0 then ...

and if it has values, then drop into excel quickly like:- cells(1,1).copyfromrecordset()

thanks

formula in excel :- get user id currently logged in (< v9.1)
not in TM1 help files, just found it on a sheet somewhere.

=getusernamefromserver("server name") for poor guys like me stuck on an old version.

total is about 12mins, what i don't understand is why the brakes go on after the first 3 seconds when it's already loaded most of the cubes in memory

had this going before then got sidetracked, lost the .pro (while cleaning the data\dir on dev), lost my memory. all i can recall is a .vue then a odbcoutput(dsn, sql ..)
it'd be great if someone can post a working sample with |pipes, string/num handler..

my citrix view is that users complain about the speed believing they're logging into tm1 when it's actually taking 10 minutes running the citrix login script. other times, they get a dud machine on the farm that's even slower. when they're lucky to get a good machine on the rotation and the keystrok...

server boot sequence begin fast then once the commit charge reach a few hundred mbs, the rest of the cubes seem to load about 10k p/hr . does anyone have any tune up tips like multi thread load, mem tweaks or cube/feeder arrangements
spec = win2003svr, 9.1sp3 x86, 8Gbs.

thanks all for the ideas and suggestions. 1st attempted the repair in the tm1 setup option but failed on "could not stop service().." [didn't give name of the service so couldn't work out which one to stop] and was logged in xp with admin rights at the time. eventually looked in application event lo...

it was win xp pro sp2. tm1p is 9.1 sp3. 429 is right for the active-x error. the 2nd one is (same o/s spec) runs a window installer when the tm1p addin in excel is checked and okayed. :| then asks for a nero - burning rom.msi, although when the esc key is pressed several times it cancels and loads p...

some anomalies when adding perspectives in excel occurs, a dialog box appears with "active x cannot create object" and in another instance, windows installer dialog appears - i'm wondering if it has anything to do with automation [servers] that are missing some files.. has anyone come across somethi...