TM1 Forum

Hi fellow Gurus, I have an AD\TM1 Admin group I want to maintain outside of TM1. How should I go abouts to automatically granting these users TM1 Admin access? I've tried setting a security cube rule to grant ADMIN to AD\TM1 Admin users but noticed it doesn't take effect when they login for the firs...

The actual machine name used in the URL is defined in External Server URI in TM1 Application Server section of Cognos Configuration.

I have a command button (ActiveX) control on a spreadsheet and am trying to figure out the VBA code on how to get it to run a TI Process. Did you look at the alternative of using an action button? Using an action button would eliminate the need to write any VBA to run a TI process. I am actually tr...

Hi All, I need a little help on this topic. I have a command button (ActiveX) control on a spreadsheet and am trying to figure out the VBA code on how to get it to run a TI Process. I need a little clarification on where/how to declare the function and connection to my TM1 server. As a startup, I've...

Has anyone found the cause of this symptom? TM1web prompts to save the file regardless of the excel format. (XLS or XLSX) I've attempted to upload the file multiple ways. Through the upload function in perspective as well as adding file in the application folder through Architech. The following IBM ...

Any updates?

I also can't get the TM1 Application Server back up.
"C:\Program Files\ibm\cognos\tm1_64\tomcat\bin\tomcat6.exe" //RS//pmpsvc

TM1 version 10.2

I have noticed that the application hangs/does not refresh after period of time(a day or two). I will need to relaunch the program or reconnect to the server.

The datasource is a text file export of a cube. Error occurs on non-leaf cells when trying to input the data back into the cube via CellPutN().

Using ELLEV seems to be faster than CellIsUpdateable()
Good to know that this is the way to do it.

Thanks

Is there a function for TI equivalent to the ISLEAF rule function? If I needed to check in the Metadata/Data tab whether the referenced cell is a leaf level cell or not, is there a more pratical way than: IF((ELLEV('Dim1',vDim1) = 0) & (ELLEV('Dim2',vDim2) = 0) & (ELLEV('Dim3',vDim3) = 0)); ?

Turned out that my main TM1 server had execution of scripts disabled. Changed Execution Policy on the server and I was set. Execute Policy on my client machine was fine. That's why it worked when i ran the script not through TM1. Set-ExecutionPolicy RemoteSigned http://technet.microsoft.com/en-us/li...

What server os are you running? Have you had any problems with running processes remotely when the data source contains a UNC path? The reason I ask is that I've seen windows server 2008 have issues resolving DNS names if they are setup in a certain way. Have you tried using a physical address on t...

I am writing a process that calls a script to send out some emails. The script is written in Powershell and uses the built in $smtp.Send() function. http://www.howtogeek.com/120011/stupid-geek-tricks-how-to-send-email-from-the-command-line-in-windows-without-extra-software/ (Trying to avoid 3rd part...

I see what you mean but this Home.xls is my default page where it launches automatically when users log into TM1Web. This Websheet then have multiple hyperlinks used to navigate to other Websheets. These sheets show friendly names on the title bar with no problems. If it's a huge issue you could al...

Never something I've actively tried to do but as a by product of something else I was doing I have found that if you navigate to a websheet using a hyperlink() formula it will display the tab as the "friendly name". So depending on whether you have a menu sheet and how you wish to navigat...

Hello, Is there a way to configure in Web.config to have the title in Internet Explorer show something other than the path to the file. Currently: "Websheet - //MYSERVER/ExcelTemplates/Home.xls - Windows Internet Explorer" Preferred: "Websheet - Home - Windows Internet Explorer" ...

I have a cube that has 7 dimensions and all its dimension are flat and carries only children elements. The cube carries quite some data and sizes to about 3.8GB (3,800,000 KB). I have 2 instances setup on the same server. One is the main, the other is fresh and has replication linked to the main. Wh...

When a calculated value consolidates and it isn't fed then there is no flag in place to tell the consolidation that the value is there. What your suggesting effectively flips this. Your making the calculated element a consolidation. This means as a consolidation it's children retain their flags as ...

Thanks Jim.

Our cube goes through a lot of heavy calculations and we are trying to minimize feeding in hopes to improve performance. You are right about the model being very confusing, but could this be a workaround/improvement in terms of speed?

Why you not responding?! This can't be right...