This section includes updates to documentation for the following components in the IBM Cognos Impromptu group:
Note: This corrected topic will appear in the New Features Guide in a future release.
Use of the Impromptu Type Library (ImpClient.tlb) by VB.Net applications using late-binding syntax is supported in Series 7 Version 4 MR2.
For example, in a VB.Net application, the following late-binding syntax will work:
Dim ImpObj As Object
ImpObj = New ImpromptuClient.ImpromptuApplicationClass
MessageBox.Show(ImpObj.GetPID())
However, the following early-binding syntax will not work in a VB.Net application:
Dim ImpObj As New ImpromptuClient.ImpromptuApplicationClass
MessageBox.Show(ImpObj.GetPID())
In addition, you can browse through the details of the automation objects and interfaces that are exposed by Impromptu.
Note: This topic will include the following additions in a future release of the Impromptu User Reference.
Dim ImpObj As Object
ImpObj = New ImpromptuClient.ImpromptuApplicationClass
MessageBox.Show(ImpObj.GetPID())
Dim ImpObj As New ImpromptuClient.ImpromptuApplicationClass
MessageBox.Show(ImpObj.GetPID())
8. In the Workspace, click File Viewer to view the object definitions in the ImpClient.h file.
8. In the Workspace, click File Viewer to view the object definitions in the ImpClient.h file.
Note: This topic will include the following note in a future release of the Impromptu Administration Guide.
Note: Use of the Impromptu Type Library (ImpClient.tlb) by VB.Net applications using late-binding syntax is supported.
Dim ImpObj As Object
ImpObj = New ImpromptuClient.ImpromptuApplicationClass
MessageBox.Show(ImpObj.GetPID())
Dim ImpObj As New ImpromptuClient.ImpromptuApplicationClass
MessageBox.Show(ImpObj.GetPID())
Note: This corrected topic will appear in Mastering Impromptu Reports in a future release.
A locked catalog restricts access to the Creator user class. When a member of the catalog Creator user class attempts to open a locked catalog, they must provide password authentication to unlock the catalog before opening it. A catalog lock is specified by the administrator and exists in addition to the common logon authentication required by IBM Cognos products and the catalog logon authentication. If a user, who is not a member of the Creator user class, attempts to open a locked catalog, they are prompted for the usual catalog logon credentials only.
By default, the Creator user class has unrestricted access to a catalog and can restrict access to other user classes. Typically, this is how you want catalog access to be managed. However, there may be certain occasions when you want to restrict access even to members of the Creator user class. You can lock a catalog to further restrict its access to the catalog Creator user class. This added security will prevent all members of the Creator User Class in the Access Manager namespace from accessing this catalog. This security is important where you have multiple catalogs, each with different users who are Creators, and all users are members of the Creator User Class in the same Access Manager namespace.
Note: The table in this topic will include the following corrections in the next version of Impromptu User Reference.
Each IBM Cognos product exports data to delimited text format in the same manner, as shown below:
For the export of date and time data, dates are exported in one of the following formats:
Note: In PowerPlay, the date is defined in the Transformer model and is exported as text.
Note: This topic will include the following subtopic in the next version of Impromptu User Reference.
The following .ini files provide Impromptu with information about its supported databases.
Note: These topics will include the following corrections in the next version of the Impromptu Macro Help.
The examples in the ActiveDocument Property topic and the ExportExcelWithFormat Method topic should show Set objImpApp = GetObject("CognosImpromptu.Application"), not Set objImpApp = CreateObject("CognosImpromptu.Application").
This example returns the name of the active report in a message box. To run this macro you must first open a report.
Sub Main()
Dim objImpApp As Object
Dim objImpRep As Object
Set objImpApp = GetObject("CognosImpromptu.Application")Set objImpRep = objImpApp.ActiveDocument
MsgBox objImpRep.Name
Set objImpRep = Nothing
Set objImpApp = Nothing
End Sub
This example exports the active report as a Microsoft Excel file. The new file will have the same name as the active report with an Microsoft Excel file extension (.xls). To run this macro, you must first open a report.
Sub Main()
Dim objImpApp As Object
Dim objImpRep As Object
Dim strExcelFileName As String
Set objImpApp = GetObject("CognosImpromptu.Application")Set objImpRep = objImpApp.ActiveDocument
strExcelFileName = Left$(objImpRep.FullName, Len _
(objImpRep.FullName) - 4)
objImpRep.ExportExcelWithFormat strExcelFileName & ".xls"
Set objImpRep = Nothing
Set objImpApp = Nothing
End Sub
Note: This topic will include the following corrections in the next version of the Impromptu Macro Help.
x_excel.flt = Excel is incorrectly listed as an acceptable value for the ExportFilter parameter. To create an Microsoft Excel files from Impromptu reports, use the PublishExcel object.
Note: This topic will include the following deletion in the next version of the Impromptu Administration Guide.
Note: This topic will include the following deletion in the next version of the Impromptu Administration Guide.
In the "Limitations" section, the following paragraph will be removed:
If you use the characters, '|' or ',' as prompts when opening a report, the report will fail. If you want to use these characters in prompts, precede them with the '%' character, for example, '%|' or '%,'.
Note: This correction will appear in the Expression Editor documentation installed with each component. Please note that the Expression Editor documentation is included with several other Series 7 components, including PowerPlay Transformer.
The spacing in the example included for the spread function will be corrected to read as follows:
spread ('ABC')Returns the result: A B C
Note: This topic will include the following corrections in the next version of the IBM Cognos Web Portal User Guide.
Note: This topic will include the following correction in the next version of the Impromptu Web Reports Administrator Guide.
Currently, this topic incorrectly states that users with execute privileges can enable and disable the governor setting. Only users with write or owner privileges can enable or disable the governor setting.