TM1 Forum

Thanks. That was stupid of me.

Thanks Michel for replying.

I have bad data coming in with values like 'N/A', '0', 'ASDF', which I want to avoid.

When the data is not in ('N/A', '0', 'ASDF'), I want my if to work else, nothing.

Hope I am clear.

Thanks,
Paul.

Hi Gurus, I am stumped on a simple if condition which fails miserably. I am reading data from a csv file. The first condition to check for blank works and fails checking 'N/A', <>0 and ='N'. Can someone tell me where I am going wrong? the condition translates to if Proj_code is not blank or proj_cod...

Hi All, We want to create a share point page to display how long it takes to start a TM1 server. As we all know the process (TM1SD.exe) starts but server actually ready after loading all the cubes into memory. Can anyone suggest a way to record the process start time into a database table? I don't w...

I have added the below lines and it worked. Lines were provided by IBM. This will help others who are stuck here. System is on 10.2.2 FP6; windows, Oracle JRE. System.setProperty("com.ibm.jsse2.overrideDefaultProtocol", "TLSv1.2"); System.setProperty("javax.net.ssl.trustStor...

Thanks gtonkin for the reply. sorry, took a longer to reply on this. I have another question. The view built to copy data uses MTQ to retrieve, but the copy is single threaded (I think it's writing a row each time.) Is there multi-threaded copy? We are on TM1 10.2.2 FP4. Answers are below. -Have you...

Hi Brian,
Thanks for the reply. we use Oracle JRE.

Thanks,
Paul.

Hi Upali, Thanks for the response. There was a certificate expiry late last year and we did the change. Otherwise it's a working system. I was able pass the error with the below code but the server does not get connected. System.setProperty("com.ibm.jsse2.overrideDefaultProtocol", "TL...

Hi, I get an error when I write similar code as above. I am trying to connect to TM1. TM1 version - 10.2.2 FP4. using Eclipse IDE. Can someone help me with the exception error? Any help is good. ----------code-------- package FirstPackage; import com.applix.tm1.*; import com.applix.tm1.TM1Bean; impo...

Hi All,
I am trying to write a TI process to copy from a planning cube to a reporting Cube. Both are large cubes and am looking for best ways for performance.
we are using 10.2.2.

Thanks,
Paul.

Thanks Tomok and Gtonkin for the answers. Port numbers are different and only one tm1admsd.exe is running. We have Cognos BI reports running against TM1 cubes and both the users are non intersecting with different packages. Meaning one group does not access the other package or the contributor appli...

Hi All, I have two TM1 server instances running under a TM1 admin server on the same VM. Most of the activity is on one server and the second TM1 server is for minor reporting. I see that users logging into the first server are showing up as logged into the second instance. Most users do not have ac...

Thanks Nidhi. I will check.

Hi, We are planning on implementing TM1 scorecards and want to know if they be consumed? I have used Insight a little and looking for other ways. Report studio or Analysis studio is a better tool for us. Has anyone used them? What are the other possible ways? We use TM1 10.2.2 and Cognos 10.2. Thank...

Hi, I am having an issue with Performance Modeler setting Weighted Average to a Consolidated level on a dimension (pic attached). we are using TM1 10.2.2. When I tried to set "weighted average" at consolidated level, it errors "Items Not recognised". This is a built-in function a...

Hi All,
Probably a simple thing on Scorecards within Performance modeler - V.10.2.2 - fix pack4.

I was trying to create new metric indicator dimension and the icon 'Create Metric Indicator Subset' is grayed out. Any idea on how to enable?

Thanks in advance,
Paul.

Thank you. That did the trick.

Hi, I have created a new TM1 server instance and that is not available on the list of available 'TM1 servers' dropdown as attached in the drop down. We are on 10.2.2 FP4. Older TM1 server instances that we created are available in the drop down. Is there something that has to be done before it's ava...

Hi all, I need some help configuring our TM1 portal URL to be made public. We have a public url for TM1 portal. I have verified that when I type in "http://tm1.PublicURL.com/" it resolved to "http://tm1.PublicURL.com/pmpsvc" and further and fails after reaching our webserver for ...

Thanks for your ideas babytiger and qml.
I see a way through Performance modeller.

Thanks again.
Paul.