Search found 117 matches

by yyi
Fri Jun 22, 2012 1:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hide Sandbox - TM1Web
Replies: 3
Views: 1742

Re: Hide Sandbox - TM1Web

you're right! 'Deny' a security group in 'capabilities' disables sandbox for users in that group when DisableSandboxing=F or omitted in tm1s.cfg, but Admin group can't be denied access even when "use sandbox" capabilities are denied. (had integrated login so had to test using someone else's machine)
by yyi
Thu Jun 21, 2012 11:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 API _VB functions in VWD2010
Replies: 6
Views: 1470

Re: TM1 API _VB functions in VWD2010

Oh, sorry I only tried the C# syntax for looping thru server names using Applix.TM1.API.dll reference.
You should give it a go, it's a lot simpler and you can always change language setting to VB.net if you prefer.
by yyi
Thu Jun 21, 2012 2:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hide Sandbox - TM1Web
Replies: 3
Views: 1742

Re: Hide Sandbox - TM1Web

the global;
# DisableSandboxing=T
in the server config works well, and was hoping to switch on for some groups
but it's not working for me..
capabilities.png
capabilities.png (8.82 KiB) Viewed 1734 times
by yyi
Thu Jun 21, 2012 2:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 API _VB functions in VWD2010
Replies: 6
Views: 1470

Re: TM1 API _VB functions in VWD2010

VS2010 is .net, it also comes with VWD but i just used 'create new web app' which opens a new project using *.aspx
by yyi
Thu Jun 21, 2012 12:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 API _VB functions in VWD2010
Replies: 6
Views: 1470

Re: TM1 API _VB functions in VWD2010

There's a good tutorial in the 'Useful code, tips and tricks' section; http://www.tm1forum.com/viewtopic.php?f=21&t=3819
by Alan.

I found it easier using VS2010 with C#
by yyi
Thu Jun 21, 2012 12:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hide Sandbox - TM1Web
Replies: 3
Views: 1742

Hide Sandbox - TM1Web

Does anyone know how to set tm1web not to show the sandbox?
there was a hide websheet toolbar in }ClientSettings but users need the other functions like slice and recalc.
webToolbar.png
webToolbar.png (22.72 KiB) Viewed 1742 times
and what this setting means; user style, allow overwrite ?
clientSetting.png
clientSetting.png (9.8 KiB) Viewed 1742 times
Thanks!
by yyi
Wed Jun 13, 2012 5:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ghost of text attributes past
Replies: 1
Views: 695

Ghost of text attributes past

The Scenario; 01. 2 new text attributes added to a dimension 02. an unrelated requirement to replace files in data directory from previous day backup 03. [server restarted with backed up data dir] 04. ... 05. the 2 attributes are subsequently added back 06. attrs() in t.i. and =dbra() in worksheet c...
by yyi
Tue May 29, 2012 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RemoveClientFromGroup - All ?
Replies: 8
Views: 1728

Re: RemoveClientFromGroup - All ?

Just realised a quick method;

Code: Select all

ViewZeroOut('}ClientGroups', 'All_Groups');
This should work fine in prolog I'm thinking..
by yyi
Tue May 29, 2012 12:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RemoveClientFromGroup - All ?
Replies: 8
Views: 1728

RemoveClientFromGroup - All ?

Hi All, Is there a way to do this cleanly in one go rather than
inspecting each group per client with any changes :?:

Since there is always more removal than assigning to do, so
to assign after 1st removing all..


Thanks
by yyi
Sun Apr 22, 2012 7:26 pm
Forum: Useful code, tips and tricks
Topic: Connecting to TM1 Using VB.Net and the .Net API
Replies: 6
Views: 10565

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

been a while since i had looked at this but recently looking at it using 9.5, found an unusual error when accessing cube data. it didn't recognise (not all) just some of the elements of a dimension. eg: string[] iDimEl = new string[2]; iDimEl[0] = "2012"; iDimEl[1] = "Actual"; iCell = xCube.Cells[iD...
by yyi
Sun Apr 03, 2011 2:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Run External Application from TM1Web Workbook
Replies: 6
Views: 2068

Re: Run External Application from TM1Web Workbook

Hi gays! Can anybody help me to resolve next task? I need to open xls-file from TM1Web WorkSheet by MS Excel as external application. Thanks for your advice. I'm sorry but personally i'd like to be gay the way mrs brady describes it. :D [in brady sequel] Sub xlObj0(xlCG As Boolean) If xlCG Then '} ...
by yyi
Sat Apr 02, 2011 12:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 and Javascript
Replies: 6
Views: 2223

Re: TM1 and Javascript

if you're not feeling sleepy one night, you could try this; Login.aspx.cs protected int tm1Main() { String adminHost, tm1Svr, tm1Uid, tm1Pwd; adminHost = TextBox1.Text; tm1Svr = TextBox2.Text; tm1Uid = TextBox3.Text; tm1Pwd = TextBox4.Text; int nRtn = 0; // Start by creating an Admin Server object T...
by yyi
Fri Mar 18, 2011 1:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Migrating to TM1 v9.5.1 or TM1 v9.5.2?
Replies: 24
Views: 88498

Re: Migrating to TM1 v9.5.1 or TM1 v9.5.2?

what ibm presented at the forum today if i can recall is (didn't take notes):- cube locking removed = PI = paralell interface of some sort ... (no queues in writing except new metadata) security on [] reserve = prevent others overwriting data while you're writing cpu core utilisation up = many users...
by yyi
Tue Mar 15, 2011 11:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Design: Cube Viewer as Widget
Replies: 12
Views: 3256

Re: Design: Cube Viewer as Widget

the compiler created a lot of extraneous files so the proj folder is zipped. file to open is *.vbproj if you can't open, the form1.vb can be opened with any text editor. it's a simple 1 form app; you can add more like mdi form with gridview with code explained in Alan's post: "Connecting to TM1 Usin...
by yyi
Tue Mar 15, 2011 4:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Design: Cube Viewer as Widget
Replies: 12
Views: 3256

Re: Design: Cube Viewer as Widget

this is just a weekend project made using vb.net - that can give you some ideas for "widget" the console app was compiled using tm1 .net api v9.4.1 (probably works for anything higher too) to run, you can drop it under your ~/tm1/bin directory and rename as *.exe if you're interested, i can post the...
by yyi
Sat Mar 05, 2011 8:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ? TM1Cell.Value {get; set} problem
Replies: 3
Views: 948

Re: ? TM1Cell.Value {get; set} problem

thanks for the suggestion, i tried it out but still didn't work. after trying a multitude of debug, test, rewrites and even rebuilding using plain win form apps; finally got it to work :P the code started to get really long and can't recall all the different things i tried while half asleep, but i t...
by yyi
Fri Mar 04, 2011 3:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ? TM1Cell.Value {get; set} problem
Replies: 3
Views: 948

Re: ? TM1Cell.Value {get; set} problem

the code actually works on a different set of elements on the same cube !!
so either the api is buggy or the cube/dimension has some internal addressing issues maybe..

can someone offer any theories on this?


thanks
by yyi
Thu Mar 03, 2011 9:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ? TM1Cell.Value {get; set} problem
Replies: 3
Views: 948

? TM1Cell.Value {get; set} problem

hi Everyone, trying to use the value propery of TM1Cell class and running into a problem with passing the string[] parameter for dimension elements. ie: [element1, element2 ...element(n)] it seem to find the element names okay as long as there's no hierarchy and the dimension element are all top nod...
by yyi
Sat Feb 26, 2011 2:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting Attribute and Allias value in a dimension
Replies: 2
Views: 2308

Re: Getting Attribute and Allias value in a dimension

see control cube for attribute list and find index i
vDimensionElement[0].Attributes.Value.ToString()

have you come across a subset list where the code breaks and the message is:-
Cannot create attribute value for "my attr-01" attribute, parameter is ERROR.
by yyi
Wed Feb 23, 2011 1:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating TM1 Objects in C# and ASP.NET
Replies: 20
Views: 10873

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

i had put in "Alias1" in the example as the attribute to highlight that it was an alias and not a text or string attribute. the error i found was actually around the alias name because it contained a character that the code could not resolve, ie: had an ampersand like "code & description". once it w...