TM1 Forum

My understanding is that if the parameter within tm1s.cfg called AuditLogOn=T then TM1 Server writes into a temp file called tm1rawstore.<Timestamp>, created under the database directory. The entry in this log file are then moved to the final Audit log

Hello All, I am installing TM1 on Windows 2008 R2 and need clarifications on the various Port numbers that need to be opened and for my understanding how they communicate between TM1 Admin, TM1 Database and TM1 Web. I have drafted a diagram for you to take a look. Page 1 of the pdf is simple basic a...

I get it. Thanks David. Appreciate your time to assist me.

David, Thank you for your quick response. FEEDERS did help; however with reference to your note on an "efficient design to set A to be B+C in a consolidation" when I use the ['A']=C:['B']+['C']; with FEEDERS per your suggestion, Calc Measure does not show again with Suppress Zeroes. Howeve...

Hello All, I have a Calculated Measure A = B+C being calculated using cube rules When I have the Suppress Zeroes 'ON' I do not see this measure even if I have data being calculated for this measure. Is this normal to TM1? Can I incorporate a function within my rule to show me Calculated Measure even...

CSJean,


Sorry! I rolled back to my backup version which had only Excel 2003, since I have some urgent deliverable and couldn't wait to find a fix. I can test this on my laptop which only has Excel 2007 and get back to you as I still see the issue out there.

Thanks

Hello All, I am on TM1 9.5.2 and have both Excel 2003 and 2007 installed on the web server. Once the excel files are published on the Application folder Excel 2003 open up as Websheets but Excel 2007 does not open up as websheet; It prompts to open the sheet on Excel even though it's on the Internet...

Thank you all for your quick response. Its working ...

Thank you again for your help. This forum rocks.... =D

Hello All, I am trying to copy data from a 10 dimension cube to a 5 dimension cube using TI process. Since I loose out unique slices due to less number of dimensions within my second cube the TI process over writes / replaces similar records while loading resulting in only a portion of records/slice...

I have not worked with Express 9.5 but this may help.

Till you get an Express expert to assist you from the group try to set TM1s.cfg parameter IntegratedSecurityMode=4. You may need to re-start the service.

=D

Steve,

Got it. Thank you.

Regards,

Hello All, I am doing large data dumps > 25 million records using ASCIIOutput within TI Advance Data tab. The .txt file being generated as output has ' " ' on the dimension elements and values. I have to remove them before loading them into relational table. Is there a way to avoid ' " ' b...

Thank you for your responses. I have enough testing scenarios to work upon. I am going to test on another server to see if it's related to memory, i/o issue on which the table is located. Kyro, I like your recommendation and shall be testing once I have DBA create another test table for me. Thank yo...

Hello David, Thanks for your response. Following are the responses to your questions: a. I have already extracted data to a flat file using Asciioutput. b. I have only used '0' Dimension elements avoiding the need for C level suppression. Also the flat file output does not show any zeros confirming ...

Hello All, I am doing a Data Extraction from TM1 to Relational Table using the TI Advanced tab 'Prolog' 'Data' and 'Epilog' with ODBCOpen, ODBCOutput, ODBCClose feature. The performance is really slow. < million records an hour. Is this a normal performance issue due to which I believe it's recommen...

I found the issue. I tried to use the various skins other than default within the TM1 Web.cfg file. The default skin is "TM1CustomStyles.css" which is blank and does not do anything. However if this is changed with Modern.css or any other styles as stated within TM1 Operations guide under ...

Hello All, I am having an issue with TM1 Web version 9.5.2 and Internet Explorer version 8 & 9. I have been using Firefox web browser without any issues to spread data using TM1 views on Web. However since my client has only IE web browser within Production, and when I try to right click on a co...

Right click on dimension and select 'Set Elements Order'

Under 'Select one of the sort orders' section select "Automatic"

Under the section 'Automatic Sort by" select "Hierarchy". Click on 'OK'

Try to reopen and see if this fixes your issue.

Regards,

Ashwin

Users shall be using the Web cube browser views with the "Right Click menu" for data spreading methods

Regards,

Ashwin

Hello All,

My goal is to hide some of the Data Spread Methods from the Menu so that my users only have limited Data Spread Method option.

Has anyone tried this. I checked in the .cfg file but couldn't find any settings.

I am on TM1 version 9.5.2

Thanks & Regards,

Ashwin