TM1 Forum

I had a chance to try it in Citrix and saw that I missed one line in the declares. It worked fine then. 'ENABLE THE CODE TO USE THE EXCEL TM1 HANDLE - SAVES LOGGING IN AGAIN '(This function does not appear in the standard tm1api module supplied ' by Applix / Cognos / IBM. Added by Alan Kirk, 15-Jan-...

Try this: Dim hUser As Long Dim hPool As Long Dim vServerName As Long Dim vStringLength As Long Dim hServer As Long TM1APIInitialize hUser = TM1_API2HAN TM1SystemAdminHostSet hUser, "YourAdminHost" hPool = TM1ValPoolCreate(hUser) vStringLength = TM1ValIndex(hPool, 10) vServerName = TM1ValS...

Also Scan() is case-sensitive, if you want to use that as a search mechanism.

Oh wow! that code I posted is more than 3 years old now. Since then looks like we did a number of changes, especially SSL updates. However, the error looks like your AdminServer is looking at the v2 certificate, while the java packages might be using the "standard" certificate. I haven't d...

As a practice I usually use the MetaData tab to scan the file and find the intersections in the source file to determine what sections should be used for ZeroOut. However, you would need to relay on some assumptions and a contract between the Source System sending the file because it is not very eff...

Yes, we use Pulse heavily in our day-to-day work. Specifically for 1. Monitoring - Alerts, TM1Top actions and Instance restarts 2. User/Thread management - Basically replacing TM1Top 3. Development - Moving code from Dev to Test to Prod (Source control, with some limitations, but still very useful) ...

Interestingly the packages are called
* IBM TM1 2.0 Microsoft Windows Multilingual
* IBM TM1 Client 32-bit/64-bit 2.0 Microsoft Windows Multilingual

We are back to v2

Hi all, I've got a question on the SSL fix that IBM has released. We've used it successfully and have no issues with it. However, my question is: Since the fix is only available from FC, does that mean any user who doesn't have the IBM maintenance agreement cannot use the fix? Is their only option n...

Have you looked to see if you have any Anti Virus Software or any specialized logging software? I know its not TM1 but we had an issue with IBM Watson Content Analytics where some kind of logging program would get triggered when we crawled data for a collection and the server would attempt to build...

Yes Brian... Storages are in SAN, and we have done diagnostics on Prod and Dev. During the freeze no connections are available to the server, unfortunately.

Hi all, We've got this very strange behaviour in our Windows Prod box, which is not apparent in the Dev box. Prod: Windows Server 2012, TM1 10.2.2.4, 1.5Tb RAM, 2Tb D:\, 32Cores Dev: Windows Server 2012, TM1 10.2.2.4, 512Gb RAM, 1Tb D:\, 16Cores (x2 threads) TM1 Models uses about 450-490Gb of RAM. C...

Ahh... what a coincidence, our PMR has also been made a APAR...

lotsaram wrote:Hmmm. So a temp subset does work but a temp view can't be assigned as a data source ....
... so a temp view does exactly what then? (Answer seems to be "NOTHING")

Just wondering, is there any other use-case for temp views? I find it useless since dynamic data source isn't supported.

Bummer... I can confirm that, cCube = 'System Info'; cSubset = 'TM1_Temp_Objects'; cView = cSubset; cTemp = 1; # View ViewCreate(cCube, cView, cTemp); vDim = 'System Parameters'; SubsetCreatebyMDX(cSubset, '{TM1SORT( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [' | vDim | '] )}, 0)}, ASC)}', cTemp); vDim = 'S...

Well this works fine. cSubset = 'TM1_Temp_Objects'; vDim = 'Year'; SubsetCreatebyMDX(cSubset, '{TM1SORT( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [' | vDim | '] )}, 0)}, ASC)}', 1); i = SubsetGetSize(vDim, cSubset); while (i > 0); AsciiOutput('D:\Temp\out.txt', SubsetGetElementName(vDim, cSubset, i)); i = ...

I use these two lines... SubsetCreatebyMDX(cSubset, '{{[' | vDim | '].MEMBERS.ITEM(0)}, {TM1SORT( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [' | vDim | '] )}, 0)}, ASC)}}'); SubsetElementDelete(vDim, cSubset, 1); vDim is the Dimension and cSubset is the subset you create. {TM1SORT( {TM1FILTERBYLEVEL( {TM1SU...

Hi Matt, We had a similar issue very recently. In our case the time difference between our CUB file and CUB$ file was about 3 weeks. We just didn't notice issue. :o Anyway the best approach to aviod data loss was to use Process Explorer to unlik the CUB$ file from the TM1S process and then delete th...

As a practise I always use Apache DS to browse LDAP services before using ETLDAP. This will ensure you have all the parameters and credentials confirmed for a correct connection.

TM1 does not have the optimization that only evaluates the right of a logical expression if needs to. It is stack based and it evaluates both sides, putting their results on the stack, before it sees that they are being combined with an "&". Ahh... if that's how this cookie crumbles, ...

Thanks for the reply Robin In your first example - IF ( A & B ) then B has the issue so you get the error. Both clauses are evaluated because they are in the same statement. What I was expecting was; since A = FALSE there is no need to evaluate B (i.e. only one FALSE is enough to make an AND to ...