TM1 Forum

Depending on where you are at and if you haven't found a workaround yet.

I would export the data from a text file into a csv file with and then load into oracle using SQLLoader or External Tables.

This would be a lot faster in terms of performance then a ODBC load via a TI.

Oops !! Apologies to everybody !!

A quick google search comes up with this. http://support.microsoft.com/kb/2556002 The fact that the PMR hasn't been updated and you are on TM1 9.4.1. chances of a resolution are remote. How about a simple .aspx page stopping the TM1Web Service and seeing whether memory increases ? This would isolate...

Highly Speculative but worth a shot !! I am not sure but have a look at this document http://www-01.ibm.com/support/docview.wss?uid=swg21460595 "Internal testing comparing like tests comparing TM1 9.5.1 to TM1 9.5.2 with PI have shown the TM1 9.5.2 Server to allocate between 10 – 30% more RAM t...

I think you are more likely to use the VIEW statement !!

The export to CSV and back in was faster then the original because of locks. More documentation is below. http://publib.boulder.ibm.com/infocenter/ctm1/v9r5m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.tm1_op.9.5.2.doc%2Ftm1_op_id7949ViewingandUnderstandingtheTM1TopDisplay_N1.html Have you checked the...

OK Take the "new" SQL and put into a new TI and do a preview and compare the timings !!

"Rules - my recollection is that FAP rebuilds its cubes every time it is run. How will that work?" In Controller 8.5.1x onwards FAP is not rebuilt every time. But timestamps slow changing dimensions (SCD) which presents its own sets of challenges. Also it would also be worth considering th...

TRIM is not a SQL Server Function is it a UDF that you are using ?

How about testing it with a single where clause ? Oracle to SQL server 2008 is not a easy one. Have you created the appropriate indexes ?

Create a Cube that suits your reporting requirements i.e. appropriate dimensions and then use the rules or TI.

Please could you use the parameter IPVersion=ipv6 !!

Have you got Dynamic Subsets in any of the Websheets ??

By Chance have you noticed something like R<#> IX<#> W<#> in TM1Top ? This would indicate locking. Have you enabled Parallel Interaction ?

Have a client working on Microsoft Application Virtualization (also known as App-V) and TM1 works like a charm.

The documentation was never quite clear on whether a restart of TM1 was required post a ViewConstruct ? Does one need to restart TM1 services post a ViewConstruct ?

I suspect its a LDAP issue rather than TM1 one.

http://support.microsoft.com/kb/218185

LDAP_INVALID_DN_SYNTAX "0x22 The distinguished name has an invalid syntax."

Resolution is here

http://world.episerver.com/modules/foru ... x?id=12176

Cheers

Any errors ?? What does the error log say ?

I have installed TM1 10 and its all working well although I am not using it with LDAP. Have you tried at looking at the below settings to help you ? ## Optional LDAP Settings # PasswordSource # Determines the source of authentication # Type: Optional, Static # Two options: # * TM1 (default) - Compar...