TM1 Forum

@rmackenzie, I have several rules, this tiny rule does not add additional noticable response time in my case. Probably because it is not the biggerst cube in the world. @sachin, I need to have this solution in cube not in report. End-users can create new report and this "zero" problem shou...

@Wim Gielis, thats it! Thanks a lot, so solution is: ['Measure type']=UNDEF; This is more readable (comparing to my dummy mathematical formula division by zero), becasue everyone can read the UDEF definition from TM1 Reference Guide. @gstager, adding additional comment as you suggested is also addit...

First of all, thanks a lot for your replies and thoughts. I really appreciate. @deepakjain2020, this formula does not work. I have a consolidation member and I don't want to lose hiearchy. Beside this problem, a year ago I have created some string member and Cognos BI only supports numbers as measur...

Ahhhh.... I remember I have set 15 minutes time limit of report execution on Cognos BI server to prevent queries from hell that never ends - execute for very long time, most probably because of some stupidity of requesting very very very detailed data from a lot of dimensions. This settings is proba...

Hi, using Cognos 10.1.1 fixpack 2 on Windows 2008 R2. I have created a cube in TM1 Architect. I have a dimension Measure type if I double click (Subset Editor opens) and click on Hiearchy Sort I get the following structure: Measure type ==> kilograms ==> square meters ==> number of items ==> ... (ma...

Hi,
I am using Cognos BI 10.2.1 login authentication, so using IntegratedSecurityMode=4.
I have pasted whole TM1 file to: http://pastebin.com/QxpYjLUe (for privacy reasons I just changed my company domain name with "myserver.mycompany.com").
Thanks

Hi, using Cognos TM1 10.1.1 fixpack 2 on Windows 2008 RC2. On Windows server I have also installed TM1 Architect and from my PC using Windows Remote Desktop I am accessing Windows server and running TM1 Architect remotly on server. Login into Architect works fine. I can work for about 5 to 10 minute...

I was asking a question on http://www.tm1forum.com/viewtopic.php?f=3&t=10042 on how to use multiple processors and was given advice by David to start tuning with ViewConstruct. To follow one topic per forum thread, I opened a new thread. 1. I created very simple report in Cognos BI (one column a...

Hi, using Cognos TM1 10.1.1 fixpack 2 on Windows 2008 R2. The data are accessed from Cognos BI reports. Some of the reports takes a lot of time to display. Looking at Windows Task Manager I see 25% of CPU is occupied that is exactly one single core out of 4 CPU cores that computer has. Is there a wa...

Hi, using Cognos BI 10.2 accessing using TM1 10.1.1 cube using Dynamic Query Mode on the same Windows 2008 R2. I have a the following report in Cognos BI in columns there are measures, but in rows there is a level MarketBuyer from Market dimension. Market dimension has the following hierarchy: top M...

Hi, using Cognos BI 10.2.1 accessing Cognos TM1 10.1.1 cube both on the same Windows 2008 RC2 server. For one cube I am making performance tests I created some views in TM1. I also configured tm1top to see the time reports are executed. Is there any way to see if Cognos BI is using particular TM1 vi...

Hi, Cognos TM1 10.1.1 is installed server. On official IBM web page: http://pic.dhe.ibm.com/infocenter/cbi/v10r2m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.tm1_inst.10.1.1.doc%2Fc_tm1_inst_installingtm1serveronunixorlinux.html it is written To view and interact with the data stored in a Cognos TM1 s...

Hi, I have tested CAM version and I am facing with multiple problems. 1. There is no config file in this rar file, so I have copied the config file from first post of this thread and save the file in the same directory as exe file. 2. I selected the CAM in Properties window and I just missed the &qu...

qml, I have tried your suggestion but when logging into TM1 it still reports the same problem. As I see in Untrusted Certificates there were two Verising certificates, but I am using StartCom certificates - so this is not the problem. It must be something else.

Hi, this is exactly what I was thinking and it is not working in my case it produces magnitude of bigger values. It looks like my production cube is way more complicated (multiple calculations), so this simple sample was not the best way to present my problem. To solve my production cube problem I h...

Hi, using TM1 v9.5.2 I have a cube with several dimensions, but two of them are important (measures and organization_unit). Measure3 is calculated in the following way: if organization_unit is unit1 then measure3 = measure1 - measure2 for all other organization units measure3 = measure1. See attache...

Hi, I have installed TM1 server 10.1.1 on Windows 2008 RC2 (server computer). I have installed TM1 Architect on Windows XP (client computer). To login into TM1 I have set to use Cognos BI (version 10.2) as log-in mechanism (so CAM authentication). Web browser is connecting to web server using http s...

Hi,
I installed as you have recommended and problem is solved.

Don't really understand why application does not report that this additional software is required when TM1 Architect is started without success...
Regards

Hi, I have installed Cognos TM1 10.1.1 on Windows 2008 RC2 (server computer) without a problem. I can start Cognos TM1 Architect and everything is working fine. Now I have installed Cognos TM1 Architect on my client Windows XP computer from: IBM_Cognos_TM1_Client_10.1.1_Microsoft_Windows_Multilingua...

Both of my TM1 servers (test and production) are using Cognos BI integrated security. So is there a plan to support CAM in this application?