Creating a parameterized query in Excel

This capability was removed in v2.0.8, documentation provided for customers on v2.0.7 and prior. You can create a parameterized query in Excel that can later be run from TM1® Web. For more information about parameterized queries in Excel, see the Microsoft Excel documentation.

1. Follow the steps in the following web page:

   http://msdn.microsoft.com/en-us/office2010developertrainingcourse_vbalab_topic3.aspx (http://msdn.microsoft.com/en-us/office2010developertrainingcourse_vbalab_topic3.aspx).

2. If the link above does not work, go to the Microsoft web site (http://www.microsoft.com) and enter the search string "Creating a parameterized query in Excel".

   Db2 Note 1:

   When you apply a parameterized query in Db2, the following error may appear:

   Function sequence error

   To work around this issue, see the following technote:

   http://www.ibm.com/support/docview.wss?uid=swg21628120 (http://www.ibm.com/support/docview.wss?uid=swg21628120).

   Db2 Note 2:

   If you try to connect to a Db2 database using Microsoft Query, the OLE driver's connection string does not contain the hostname. An error message then appears saying that the connection failed. To fix this issue, you must add the following argument to the connection string:

   location=<hostname>;

   In addition, you must cancel out of any attempts that Excel makes to reconnect to the database, as that will reset the connection string.