TM1 Forum

I have heard, that it will take several month until we get back Integrated Login for Web 10.2. Integrated Login for TM1 Web 10.2 should already work. That is why I am trying to configure it. However single sign on (SSO) does not work (you have to type your Windows username and password). Seems to m...

Thanks for the reply! I would definitely go for CAM if Cognos BI is also used, but we have a number of clients that are currently running TM1 10.1 without BI. We also have some custom processes and websheets for security administration, which would have to be rebuilt if we would go for CAM security ...

Hi, As TM1 Web 10.2 was rebuilt and is now a Java application, single sign-on (SSO) in IntegratedSecurityMode 2/3 is no longer supported. Integrated Login by typing in your Windows user name and password is however supposed to work in mode 2/3 ( TM1 Web 10.2 FAQ ). There was a security issue in 10.2...

Hi, I found something interesting on Amazon: http://www.amazon.com/IBM-Cognos-TM1-Official-Guide/dp/0071765697 . From the description: Based on the newest release, TM1 10 , this official guide offers an advanced tutorial for TM1 concepts from a technical and a business point of view. The release dat...

Ok, just solved this myself. It was a simple case of the TM1 servcie account not having access to the AS-cube I was trying to connect to.

Thus changing the variable DataSourceODBOCatalog in the Prolog-tab to switch between cubes work just fine!

Cheers!

Martin

Hi, I am creating a process for loading a TM1 cube and dimensions from MS Analysis Services. For this I am using TI with ODBO source and MDX query to extract the data and elements of the AS-cube and -dimensions. So far so good. Now I am trying to figure out a way to have the AS-database as a paramet...

Thank you very much for the suggestions! I solved it using the DBRA-method.

I would like to create an Excel-template where the user can select one or more elements in a dimension. These elements are then passed to a TI-process triggered by an action button (the process is used for exporting the selected data to a text file). The tricky part is when the user want to select m...

The script is in the Data tab. I have tried checking the values of i (and n from the previous post) using TextOutput, and everything looks normal. I am using the latest release patched with FixPack1.

Ok, now I am very confused again. Even though the described solution above worked for that very simple case, it did not when more complexity was added. I played around a bit and found the following: This code runs in a few seconds: i=1; while(i <= 12); A = SubsetGetElementName(...); B = CellGetN(......

Sorry that I am totally spamming this thread, but I have narrowed down the problem and it is quite interesting: This code runs forever as described above: i = 1; n = SubsetGetSize(...); WHILE(i <= n); CellPutN(...); i = i + 1; END; However, this code runs in a few seconds: i = 1; WHILE(i <= 12); Cel...

Another update: I am trying to create a custom script with a while-loop looping over one of the dimensions. Everything works great until I use the CellPutN command somewhere in my script. The script runs through in perhaps 10 seconds using TextOutput to export the data, but with CellPutN writing dir...

lotsaram: didn't see your message, but I realise now that even a moderately sized cube contain lots and lots of cells.

Hi Steve, I found the function myself (you can use the ViewExtractSkipZeroesSet function), and realised just as quickly that the cube I am loading from contains far too many cells to go through them all. Actually I do not want to go through all cells, but all members of one of the dimensions. What I...

An update on my progress with this issue: I created the rule and it worked perfectly. The only thing was that, as expected, the performance was quite bad. I have now started to create a TI script for the same task and I have again run into some problems. I am using a cube view as data source for the...

Aah, I think I am starting to understand now. I have also considered TI for this task but a rule would be better for the users. My plan is to try with a rule first and see if performance is ok (the server specs are quite ok here). If it gets too slow then TI it is. I'll give it a try and come back w...

Thanks for the fast reply! However I am not sure I understand the rule. Since Dimension 3 does not exist in Cube 1, what does the third argument in the DB-function (the nested DB-function) do? Does it somehow define the area even though it is in the function part of the calculation? (I don't have a ...

Hello, I am developing a TM1-solution where I have come across a bit of a tricky problem with moving data between cubes. I have two cubes with different sets of dimension, as in the simplified model below: Cube 1: Dimension 1 Dimension 2 Cube2: Dimension 1 Dimension 2 Dimension 3 I want to load data...

Ok, that's why it doesn't work then. Too bad - it would have made our user administration simpler.

Thanks for your fast reply, David!

Hello, I am setting up integrated login on a TM1 server for the first time. It works very well for single users where I set UniqueID to user@domain in the }ClientProperties cube (I am not using the ETLDAP utility). My question is if you, instead of a single user, can map a client in TM1 to a user gr...