Search found 21 matches

by Kingsley
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: 495

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...
by Kingsley
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: 3627

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.
by Kingsley
Tue Apr 22, 2014 3:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Execute Process from VBA
Replies: 7
Views: 4545

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...
by Kingsley
Mon Apr 21, 2014 8:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Execute Process from VBA
Replies: 7
Views: 4545

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...
by Kingsley
Fri Feb 07, 2014 5:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Websheets in TM1 Web
Replies: 3
Views: 3094

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 ...
by Kingsley
Fri Feb 07, 2014 4:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot start TM1 Application Server
Replies: 8
Views: 10008

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
by Kingsley
Tue Dec 17, 2013 4:42 pm
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 34030

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.
by Kingsley
Thu Dec 12, 2013 8:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ISLEAF Function for TI
Replies: 15
Views: 3660

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
by Kingsley
Thu Dec 12, 2013 7:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ISLEAF Function for TI
Replies: 15
Views: 3660

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:

Code: Select all

IF((ELLEV('Dim1',vDim1) = 0) & (ELLEV('Dim2',vDim2) = 0) & (ELLEV('Dim3',vDim3) = 0));
?
by Kingsley
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: 2970

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...
by Kingsley
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: 2970

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...
by Kingsley
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: 2970

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...
by Kingsley
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: 1395

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...
by Kingsley
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: 1395

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 navigate to subse...
by Kingsley
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: 1395

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" Tested in Firefox as...
by Kingsley
Wed Nov 20, 2013 8:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replication not Copying Data
Replies: 4
Views: 2042

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...
by Kingsley
Wed Nov 20, 2013 4:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidate instead of Feeding / Feeders
Replies: 15
Views: 3307

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 ...
by Kingsley
Tue Nov 19, 2013 7:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidate instead of Feeding / Feeders
Replies: 15
Views: 3307

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?
by Kingsley
Tue Nov 19, 2013 7:31 pm
Forum: General
Topic: TM1 Memes
Replies: 2
Views: 2929

Re: TM1 Memes

Why you not responding?!
not-sure-if-m3es8s.jpg
not-sure-if-m3es8s.jpg (38.79 KiB) Viewed 2386 times
This can't be right...
process-completed-successfully.jpg
process-completed-successfully.jpg (39.88 KiB) Viewed 2386 times
cubes-y-u.jpg
cubes-y-u.jpg (27.2 KiB) Viewed 2386 times