TM1 Formulas not returning values on macro enabled excels

[anoops81]

Hi All ,

We are facing an issue in macro enabled tm1 excel templates. The problem is tm1 formulas sometimes are not returning any value . For ex:
the following macro has DIMIX & DTYPE formula .

Code: Select all

If Application.Run("DIMIX", dimensionName, Sheets("Cover").Range("Z" & i)) = 0 Then
         Error_Count.Add CellHeader & " - " & Sheets("Cover").Range("Z" & i)
         Error_Str.Add "Element doesn't exist in Dimension"
      Else
         If Application.Run("DTYPE", dimensionName, Sheets("Cover").Range("Z" & i)) = "C" Then
            Error_Count.Add CellHeader & " - " & Sheets("Cover").Range("Z" & i)
            Error_Str.Add "Data cannot be loaded to the Consolidated Element"
         End If
      End If

The above code is working fine for almost 90% of runs but it is failing for the rest 10% . There is no error message from TM1 . We are unable to give this to client because of this 10 % fails.


I appreciate your response .

We are using tm1 9.5.1 & ecxel 2003 .

Thanks & Regards
Anoop

[anoops81]

Hi All ,

I am missing any information here ? Please feel free to respond .

It seems TM1 forum also doesnt return any response sometimes


Regards,
Anoop

[Paul Segal]

Hi All ,

I am missing any information here ? Please feel free to respond .

It seems TM1 forum also doesnt return any response sometimes


Regards,
Anoop

You do need to bear in mind that this is all voluntary, and that getting your solution released to your client may not be our top priority.

Also, it would be useful to know what you have done to help yourself figure this out. Have you done a watch to see what's happening, or taken any other debugging measures? I'd be surprised if there is a problem with the TM1 functions themselves.

For example, what happens if the server is under heavy load - will the code wait for a response or just march on?

[anoops81]

Hi Paul ,

We will check on the debugging options for this error .

Thanks for the reply ..

Regards,
Anoop