Hi All,
Have just upgraded to 9.4 on 64 bit 2003 Server.
We used to be able to run this VBA Excel Macro before the upgrade ...
TM1ReturnValueDef = Application.Run("QUDEFINEEX", "spatium:intercompany", "Jnl_Query", Range("CO4:CX4"), -2000000000, 2000000000, True, True, True)
...but now cannot run it - any ideas anyone???
Thanks Carlos
QUDEFINEEX
-
Carlos
- Posts: 4
- Joined: Wed Jan 27, 2010 4:30 pm
- OLAP Product: TM1 Cognos
- Version: 9.4
- Excel Version: 2003
Re: QUDEFINEEX
I have found that in 9.4 QUDEFINE and QUDEFINEEX macros are broken and the do not work as well as the QUEXPORT
Have upgrade however to 9.4 MR1 FP2 and even added the Hotfix 16 but found that the performance is still terribly slow – we have updated the server resources which has made no difference at all.
The QUDEFINE and QUDEFINEEX macros have been fixed in 9.4 MR1 FP2 but QUEXPORT still does not workk.
Also now every time someone F9’s a spreadsheet with links into TM1 it asks for a password???
Arrgghh! What now? roll back? seems so familiar......
Have upgrade however to 9.4 MR1 FP2 and even added the Hotfix 16 but found that the performance is still terribly slow – we have updated the server resources which has made no difference at all.
The QUDEFINE and QUDEFINEEX macros have been fixed in 9.4 MR1 FP2 but QUEXPORT still does not workk.
Also now every time someone F9’s a spreadsheet with links into TM1 it asks for a password???
Arrgghh! What now? roll back? seems so familiar......