Search found 117 matches

by yyi
Wed Feb 23, 2011 3:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating TM1 Objects in C# and ASP.NET
Replies: 20
Views: 10864

Re: Creating TM1 Objects in C# and ASP.NET

I'm having some trouble retrieving elements from a subset; it seem to work okay until a subset has aliases or attributes for the elements and i get this error:- "Cannot create attribute value for "Alias1" attribute, parameter is ERROR." TM1SubsetCollection sSubsets = server.Dimensions["Entity"].Priv...
by yyi
Thu Feb 17, 2011 12:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web shrinking action buttons
Replies: 1
Views: 1325

TM1Web shrinking action buttons

been having mixed results with *.png images with hyperlinks in websheets (ie: not displaying or not rendering as expected) so i tried action buttons. this works well for rebuild/open workbook in apps folder but the button seem to re-size itself when the same page opens for the 2nd time. did i miss s...
by yyi
Wed Feb 16, 2011 11:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web private subset overridden by public
Replies: 1
Views: 897

TM1Web private subset overridden by public

I have a worksheet with =SUBNM("dimname", "Default", 1) where users have private default subsets. the xls template was designed to display a cost centre list applicable to the user security group. so when the sheet/page is opened, it displays the 1st cost centre from a small list(their own private d...
by yyi
Wed Feb 09, 2011 11:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI ascii datasource - getTimeStamp(?)
Replies: 3
Views: 1896

Re: TI ascii datasource - getTimeStamp(?)

thanks guys for the feedback. Steve, the del then 'fileExists' function's a good idea - actually the source file is gl balances and it get's picked up by sql svr ssis before it gets read in by tm1, so i didn't want to remove it. Lotsa, how do you know me :o maybe if executeCommand can get return val...
by yyi
Wed Feb 09, 2011 5:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI ascii datasource - getTimeStamp(?)
Replies: 3
Views: 1896

TI ascii datasource - getTimeStamp(?)

hi Everyone, I was looking for a function to read the time-stamp on a source file that's used to update a cube several times during the day. If the chore 'looks' at the file and sees that it's late - ie: skipped a drop file, then send an email alert to admin user. Couldn't find any DateTimeStamp fun...
by yyi
Tue Feb 08, 2011 11:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web x64 is rendering fuzzy graphics
Replies: 2
Views: 1164

Re: TM1Web x64 is rendering fuzzy graphics

the screen shot is from one client machine running IE 7, pointing to two intranet addresses;
1st one 32-bit server, 2nd addr to 64-bit server.

published file is XL 2003 file. have also tried using XL 2007 with same result..
by yyi
Mon Feb 07, 2011 11:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web x64 is rendering fuzzy graphics
Replies: 2
Views: 1164

TM1Web x64 is rendering fuzzy graphics

hi Everyone, I have saved to \applications, a sheet with several text boxes which were pasted back as *.png files. on the 32-bit machine, it renders exactly the same picture - but on another 64-bit machine, the same sheet is displaying a fuzzy/blurry image.. x64_Fuzzy.gif has anyone encountered this...
by yyi
Thu Jan 20, 2011 4:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating Hyperlinks to Uploaded Files
Replies: 5
Views: 1647

Re: Creating Hyperlinks to Uploaded Files

TM1://ServerName/blob/PUBLIC/.\}Externals\TM1_Filename
thanks for the link, i was trying to use action butttons on worksheets to open other excel templates. :)
instead, this enables me to paste pictures and add hyperlinks to xl templates in the applications folder.
by yyi
Mon Jan 17, 2011 3:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1web - select locked cells (disable)
Replies: 4
Views: 1617

Re: tm1web - select locked cells (disable)

I see, maybe I'll try a custom page - the activecell moving to titles and heading doesn't look very good.
Having a look at .net api at the moment - so far, been able to make a connection and thats about it ..
by yyi
Fri Jan 14, 2011 5:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What are these blb files all about?
Replies: 11
Views: 8766

Re: What are these blb files all about?

I also have a few hundred <awkward> *.blb files </awkward> in the data directory for ver 9.1

just started ver 9.4.1.3 on dev svr and the BLB Files have already started accumulating :!: :roll:
by yyi
Fri Jan 14, 2011 4:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1web - select locked cells (disable)
Replies: 4
Views: 1617

Re: tm1web - select locked cells (disable)

webclip01.gif
webclip01.gif (40.4 KiB) Viewed 1582 times
trying to fix the cell pointer to move only within unprotected cells (ie: coloured blocks in yellow, not white or purple) :cry:
by yyi
Sun Jan 09, 2011 9:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1web - select locked cells (disable)
Replies: 4
Views: 1617

tm1web - select locked cells (disable)

hi Everyone,

Does anyone know if the web sheet can be made to select only unprotected cells, like you can in excel?



Thanks
by yyi
Thu Jan 06, 2011 1:02 am
Forum: Useful code, tips and tricks
Topic: Connecting to TM1 Using VB.Net and the .Net API
Replies: 6
Views: 10557

Re: Connecting to TM1 Using VB.Net and the .Net API

I wished I saw this post a little earlier - as I'm also more familiar with VB/VBA. anyway, ended up using the poorly documented C# example and got it to work :? Still having trouble with VS2008 C# IDE with CSS, Positioning ... If anyone has any good aspx VS tutorials - would appreciate it :mrgreen: ...
by yyi
Tue Dec 28, 2010 11:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web install problem - No Display
Replies: 1
Views: 672

Re: TM1Web install problem - No Display

well, being a web newbie - i only had research to rely on.
anyway, after putting on FP1 and serveral combinations of folder permissions, anonymous login, web.config ...
it think the real problem was just opening the wrong page :oops:

~..\TM1Web\TM1WebLogin.aspx
by yyi
Mon Dec 20, 2010 6:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web install problem - No Display
Replies: 1
Views: 672

TM1Web install problem - No Display

While testing install of TM1 9.4 MR1, all seem to go well until iexplorer tried opening http://localhost/TM1Seb/TM1WebMain.aspx O/S = XP 2002 SP2 XL = 2003 SP3 Browser = IE 7 IIS = 5.1 ASP.NET = 2.0 .Net Framework = 2.0 TM1 Server = planning sample Server & Perspectives run fine. TM1Web opens a pop-...
by yyi
Mon Dec 13, 2010 1:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: memory under-usage problem
Replies: 3
Views: 1397

Re: memory under-usage problem

Thanks Alan,

I guess then it's time to hand over to Finance Dept and negotiations with IBM...
by yyi
Sun Dec 12, 2010 11:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: memory under-usage problem
Replies: 3
Views: 1397

memory under-usage problem

Hi Everyone We have a virtual server environment running on 64bit hardware & 64bit windows 2003 standard edition. TM1 is 32bit. Assigned resource on the server is 2cores with 6Gb memory. When TM1(tm1sd.exe) nears the 2Gb mark, it seems to run very very slow and most times crash out. If windows is me...
by yyi
Thu Dec 02, 2010 12:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Access Level to TM1 box
Replies: 2
Views: 941

Re: Access Level to TM1 box

Thanks for your reply,

I don't have any reservations - It's just that I.T. is sitting on the fence because with group policy, to disable only the windows re-boot for my profile is either proving to be difficult or politically not sound :?
by yyi
Wed Dec 01, 2010 3:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Access Level to TM1 box
Replies: 2
Views: 941

Access Level to TM1 box

Since I have moved into the Finance dept (Once upon a time I used to be in I.T.), I.T. would like to give my domain account just enough security to RDP to the TM1 server and:- - restart tm1 services - restart IIS - see tm1sd.exe in task mgr - set folder permissions - edit scripts ie: *.bat, *.vbs fo...
by yyi
Tue Jul 27, 2010 12:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset and Contol Cube
Replies: 2
Views: 1005

Re: Dynamic Subset and Contol Cube

haven't found a solution, but had a few goes.. using record expression 'filter by wildcard', this returns just 1 date:- {TM1FILTERBYPATTERN( {TM1SUBSETALL( [vDate] )},[Control].([CtlVar].[Start Range],[CtlMeasures].[CtlStr]))} using t.i. to run a chore to create the subset:- SubsetCreateByMdx( vSubN...