Search found 8 matches

by andersknudsen
Thu Jun 25, 2015 9:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hide Subset Editor Button in TM1 Web?
Replies: 4
Views: 4397

Re: Hide Subset Editor Button in TM1 Web?

If the purpose is to restrict the user to select only the elements that you want then you can make another dimension containing only those elements. In your worksheet you can use the new “smaller” dimension to reference the original dimension.
by andersknudsen
Wed Jul 03, 2013 10:24 pm
Forum: Useful code, tips and tricks
Topic: Connecting to TM1 Using VB.Net and the .Net API
Replies: 6
Views: 19788

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

Thanks for a usefull .net api starter guide - I think it is most needed :shock: I have been working a bit further, and I hope someone cane explain why this is ok a = server.Processes.Item(0).Name a = server.Cubes.Item(0).Name but a = server.Dimensions.Item(0).Name retuns [NullReferenceException: Obj...
by andersknudsen
Fri Dec 14, 2012 11:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot hide the Administration Node on Tm1 Web
Replies: 4
Views: 4602

Re: Cannot hide the Administration Node on Tm1 Web

Hello,

I'm having the same problem in version 9.5.1 - not being able to hide the administration node although NavTreeDisplayAdministration="N" - has anyone come up with a workaround?

thanks in advance

Anders
by andersknudsen
Wed May 16, 2012 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User specific URL in tm1web
Replies: 1
Views: 1690

User specific URL in tm1web

Hi,

Is it possible to add a URL in tm1web that opens a page that is specific for the logged in user?

Hopefully there is an alternative to adding a URL pr user and assign viewing rights to the relevant user/URL

Hope to hear from you :-)

/Anders
by andersknudsen
Fri Mar 30, 2012 12:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1web login via url?
Replies: 6
Views: 18217

Re: Tm1web login via url?

... if anyone wants the code: <%@ Page Language="VB" %> <html> <body onload="document.form1.submit()"> <form name="form1" method="post" action="tm1webloginhandler.aspx?redirect=http://localhost/tm1web"> <input name="AdminHost" id="Admi...
by andersknudsen
Thu Mar 29, 2012 7:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1web login via url?
Replies: 6
Views: 18217

Re: Tm1web login via url?

Thanks for your posts and help :-)

Especially the link to TM1Web URL API was helpful. Using the API, I have managed to make a aspx file which takes username and password as parameters and login to tm1web.
by andersknudsen
Wed Mar 28, 2012 11:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1web login via url?
Replies: 6
Views: 18217

Tm1web login via url?

Hi, In my current tm1web environment v8.4 I have modified the login page so that the asp page takes 2 parameters, username and password (e.g. http://tm1web/login.asp?user=XXX&password=YYY). In that way I can simulate to login as different users without having to remember their passwords. I have ...
by andersknudsen
Thu May 07, 2009 2:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Delete in TI by current year
Replies: 1
Views: 2148

Delete in TI by current year

Hi I would like to delete from a cube but only data from current year. I can't find a function returning current year (v8.4). I have tried something like this: ----------------------------------------------- ODBCOpen('STAMDB', '', ''); SubsetCreate('YEAR', 'NU'); a=ODBCOutput('STAMDB', 'select year(...