Search found 117 matches

by yyi
Fri Jul 23, 2010 4:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset and Contol Cube
Replies: 2
Views: 1007

Dynamic Subset and Contol Cube

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 ...
by yyi
Tue Nov 17, 2009 4:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW to merged cells
Replies: 0
Views: 557

DBRW to merged cells

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...
by yyi
Thu Nov 12, 2009 12:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ?TM1 Service > Startup T.I. (Not A Chore)
Replies: 3
Views: 2048

?TM1 Service > Startup T.I. (Not A Chore)

:?: 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.
by yyi
Mon Nov 09, 2009 12:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 9.0 to 9.4 FP1 install procedures
Replies: 3
Views: 953

Re: 9.0 to 9.4 FP1 install procedures

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 ...
by yyi
Thu Nov 05, 2009 4:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 9.0 to 9.4 FP1 install procedures
Replies: 3
Views: 953

9.0 to 9.4 FP1 install procedures

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...
by yyi
Mon Aug 17, 2009 12:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ? too many views
Replies: 2
Views: 733

Re: ? too many views

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...
by yyi
Fri Aug 14, 2009 6:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ? too many views
Replies: 2
Views: 733

? too many views

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) :oops: - i noticed a server crash after logout.
i've since created a different username and so far so good...

many thanks
by yyi
Thu Jun 04, 2009 4:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: empty cellset
Replies: 0
Views: 546

empty cellset

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
by yyi
Thu Jun 04, 2009 4:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: how to get login username
Replies: 5
Views: 1675

Re: how to get login username

formula in excel :- get user id currently logged in (< v9.1)
not in TM1 help files, just found it on a sheet somewhere.
by yyi
Thu Jun 04, 2009 3:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: how to get login username
Replies: 5
Views: 1675

Re: how to get login username

=getusernamefromserver("server name") for poor guys like me stuck on an old version. :roll:
by yyi
Fri Oct 17, 2008 5:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1s.exe - load time
Replies: 6
Views: 3265

Re: tm1s.exe - load time

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 :?
by yyi
Fri Oct 17, 2008 5:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Publishing Data from TM1 to an ODBC source
Replies: 13
Views: 10092

Re: Publishing Data from TM1 to an ODBC source

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..
by yyi
Fri Oct 17, 2008 4:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How many people use TM1 with Citrix?
Replies: 10
Views: 4721

Re: How many people use TM1 with Citrix?

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...
by yyi
Fri Oct 17, 2008 4:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1s.exe - load time
Replies: 6
Views: 3265

tm1s.exe - load time

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.
by yyi
Wed Oct 15, 2008 2:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: addin - tm1p error!
Replies: 7
Views: 3671

Re: addin - tm1p error!

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...
by yyi
Tue Oct 14, 2008 8:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: addin - tm1p error!
Replies: 7
Views: 3671

Re: addin - tm1p error!

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...
by yyi
Mon Oct 13, 2008 11:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: addin - tm1p error!
Replies: 7
Views: 3671

addin - tm1p error!

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