TM1 Forum

Hi Mackenzie, You are right that the qualified name can be in different colomn! The reason to consider this approach is that I had only read permission from the source server. I am not sure if TI from target server could control the objects in source server. I did an alternative way by slicing the v...

Hello, Try to get data cross the tm1 client servers via ODBO by MDX, and had the problem. When I use ON ROWS statement for leaf element, say, account, I would expect account elements appears in one column. However, It a bit anoying that all parents also appear in multiple columns. It does not presen...

Hi, Years ago, I could write MDX query from VBA for Excel report from TM1. When I now try to replicate the codes for current client, it shrows out the message saying "Provider cannot be found". I checked the connection inside TM1 explorer in TI pad, the connection works. So the TM1 OLEDB p...

How about this idea: Create 2 cubes, one fact cube with partition dimension, the other lookup cube with partition, productID with string data product description. While fact cube is reporting, the productID and PartisionID jointly populate product description in one spreadsheet report. Similar to re...

I would consider the dynamic subset (driven by MDX) in student ID dimension with creteria as load >0.

Hi Shock, Years ago when I tested Dundas Chart with TM1, and got similar issue. What I found is that you can get into TM1 when running MDX statement and counts you once connected, however, the connection stays there even you get off tm1 by codes. So you can get such message after a few tests. I reme...

Hi Jim, I haven't had a chance to test out what you're trying to do here and in your other thread/post yet, but one thing you should be aware of if you're developing in a .NET environment with the C/VB TM1 API is that you may not be able to copy the TM1 API VB declarations, for example, without som...

Just a quick note on DLL registering and some of the issues you bring up (Sorry I can't respond to more of this post right now, but will try to find more time over the next few days if you're still stuck): Registering DLLs is only necessary for COM DLLs, which the TM1 API DLLs are not. A really rou...

Hi Martin,

I have installed axnet service in following your guide. I think the problem caused at begining is that I foggot to disable x32 admin host which caused the conflict with the original x64 server.

Thank you very much for that.

Regards

Jim

Hi all, I found the function TM1SystenOpen getting too many digits which might be the cause for the error "Attempted to read or write protected memory". It gives me 19 digits rather than 9 in normal. The error stopped at the statement vUserName = TM1ValString(pPoolHandle, sUser, vStingLen...

Hi Martin, No issue for x64 server itself. I did a try to install axnet from 32 bit but it caused the server could not restart for no reason. Then I have to unstall all of them but I could not intall them back as it kept rolling back. Finally the server was back but I would not ask your guys before ...

Hi all, I found the function TM1SystenOpen getting too many digits which might be the cause for the error "Attempted to read or write protected memory". It gives me 19 digits rather than 9 in normal. The error stopped at the statement vUserName = TM1ValString(pPoolHandle, sUser, vStingLeng...

Hi, For 64 bit version TM1 server to be able to connect to 32 bit external database via ODBC, axnet has to be installed also, as far as I know. However, there is not axnet component with 64 bit intallation files (9.1 SP2), instead, it can be found in 32 bit file. Anybody can tell me what is correct ...