This section includes updates to documentation for the following components in the Cognos Impromptu group:
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 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 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 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 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.