Search found 21 matches
- Tue Sep 19, 2017 2:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Configuring AD/CAM/Cognos group with ADMIN privileges
- Replies: 1
- Views: 2440
Configuring AD/CAM/Cognos group with ADMIN privileges
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...
- Fri Nov 13, 2015 7:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PMPSVC - The planning service parameter was not specified
- Replies: 3
- Views: 6738
Re: PMPSVC - The planning service parameter was not specified
The actual machine name used in the URL is defined in External Server URI in TM1 Application Server section of Cognos Configuration.
- Tue Apr 22, 2014 3:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Execute Process from VBA
- Replies: 7
- Views: 8456
Re: Execute Process from VBA
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...
- Mon Apr 21, 2014 8:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Execute Process from VBA
- Replies: 7
- Views: 8456
Re: Execute Process from VBA
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...
- Fri Feb 07, 2014 5:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Websheets in TM1 Web
- Replies: 3
- Views: 5892
Re: Websheets in TM1 Web
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 ...
- Fri Feb 07, 2014 4:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cannot start TM1 Application Server
- Replies: 8
- Views: 16090
Re: Cannot start TM1 Application Server
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 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
- Tue Dec 17, 2013 4:42 pm
- Forum: Useful code, tips and tricks
- Topic: Another TM1 TOP
- Replies: 53
- Views: 68679
Re: Another TM1 TOP
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.
- Thu Dec 12, 2013 8:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ISLEAF Function for TI
- Replies: 15
- Views: 9606
Re: ISLEAF Function for TI
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
Using ELLEV seems to be faster than CellIsUpdateable()
Good to know that this is the way to do it.
Thanks
- Thu Dec 12, 2013 7:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ISLEAF Function for TI
- Replies: 15
- Views: 9606
ISLEAF Function for TI
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)); ?
- Thu Dec 12, 2013 7:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Attempting to ExecuteCommand() a PS1 Powershell Script
- Replies: 5
- Views: 6248
Re: Attempting to ExecuteCommand() a PS1 Powershell Script
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...
- Thu Dec 12, 2013 7:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Attempting to ExecuteCommand() a PS1 Powershell Script
- Replies: 5
- Views: 6248
Re: Attempting to ExecuteCommand() a PS1 Powershell Script
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...
- Thu Dec 12, 2013 6:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Attempting to ExecuteCommand() a PS1 Powershell Script
- Replies: 5
- Views: 6248
Attempting to ExecuteCommand() a PS1 Powershell Script
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...
- Tue Dec 10, 2013 8:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web Websheet - Hide .xls path in browser title
- Replies: 4
- Views: 3935
Re: TM1Web Websheet - Hide .xls path in browser title
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...
- Tue Dec 10, 2013 8:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web Websheet - Hide .xls path in browser title
- Replies: 4
- Views: 3935
Re: TM1Web Websheet - Hide .xls path in browser title
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...
- Tue Dec 10, 2013 8:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web Websheet - Hide .xls path in browser title
- Replies: 4
- Views: 3935
TM1Web Websheet - Hide .xls path in browser title
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" ...
- Wed Nov 20, 2013 8:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Replication not Copying Data
- Replies: 4
- Views: 4422
Replication not Copying Data
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...
- Wed Nov 20, 2013 4:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Consolidate instead of Feeding / Feeders
- Replies: 15
- Views: 9007
Re: Consolidate instead of Feeding / Feeders
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 ...
- Tue Nov 19, 2013 9:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Consolidate instead of Feeding / Feeders
- Replies: 15
- Views: 9007
Re: Consolidate instead of Feeding / Feeders
Thanks Jim.
- Tue Nov 19, 2013 7:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Consolidate instead of Feeding / Feeders
- Replies: 15
- Views: 9007
Re: Consolidate instead of Feeding / Feeders
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?
Re: TM1 Memes
Why you not responding?!
This can't be right...