Arul's.TEG Blog

By default, only the queue length metric for job, task, and SMTP queue metrics is enabled. The following metrics are also available for each but are set to zero and do not appear in the user interface unless you enable them: Time in queue high water mark Time in queue low water mark Time in queue Number of queue requests Queue length high water mark Queue length low water mark For more information about these metrics, see System Performance Metrics . Note that enabling these settings may affect performance. You must have the required permissions to access IBM Cognos Administration functionality. See Secured Functions and Features . Steps Start IBM ® Cognos ® Connection. In the upper-right corner, click Launch , IBM Cognos Administration . On the Status tab, click System . Click the arrow next to System to display the Actions menu, and then click Set Properties . Click the Settings tab. For the Environment category, next to Advanced settings , cl

If your organization uses the IBM ® InfoSphere ™ Business Glossary, you can also access the Glossary in IBM Cognos ® software from IBM Cognos Viewer , and from the metadata tree in Report Studio, Query Studio, and Analysis Studio. To access IBM Business Glossary, you must specify the URI of the Glossary Web page. By default, the Glossary search results in IBM Cognos software return all terms that contain the keyword specified in the search. To access the Glossary, users must have permissions for the Glossary capability. For more information, see Secured Functions and Features , and Object Capabilities . Steps In IBM Cognos Connection, click Launch , IBM Cognos Administration . On the Status tab, click System . Click the arrow next to System to display the Actions menu, and then click Set Properties . Click the Settings tab. For the Environment category, IBM Business Glossary URI , type the following URI: http:// server_name : port_number /bg/popup/popupSear

If you are familiar with databases, you will know that your first preference will be to filter on the clustered index, then on any non-clustered indexes. Any other filtering will force a table scan - a potentially costly operation. But did you know that there are rules for filtering on indexed fields? For example, assuming order date was indexed, this: (current_date,[Order date]) < 30 is less efficient than: [Order date] > (current_date - 30) even though they mean the same thing. The difference is that the first performs an index scan (it looks at every row, performs the calculation, then determines if the row should be included), while the second performs a seek (it positions directly on the first row where the order date is greater than or equal to 30 days ago). The second option has to read far fewer records so it is more efficient. A general rule of thumb is to know your indexed fields, and, if possible, do not perform calculations on those fields. Apply the

Enhancements to Business Insight Advanced 10.1.1 ·          Custom groups You can create custom groups of existing data items based on elements that you define and that are meaningful to you. ·          Creating sections You can now create sections to show a separate list, chart, or crosstab for a data item. ·          Filtering directly from the data tree When using IBM® Cognos® Business Insight Advanced with relational data sources , you can now filter using measures and query items in the source tree. This allows you to create a filter based on a data item that is not included in your report. ·          Names for lists, crosstab, and chart objects A new Name property for lists, crosstabs, and charts allows you to give these report objects a meaningful business name. These names allow business users to easily recognize the lists, crosstabs, or charts when they add them into an IBM Cognos Business Insight workspace. ·          New startup options A new Start page view option

While you are working with IBM® Cognos® Mobile on your device, you can use a number of shortcuts for navigation and to perform other actions.  

You may be prompted for your data source credentials when you perform the following actions: view, run, or open an entry use a schedule or a job select the data sources that can be used to create a package You may also be prompted for data source credentials when you use Framework Manager (see the Framework Manager User Guide). You can save your data source credentials so that you are not prompted for them every time. You can also view and delete your data source credentials. If you are an administrator, you can also create or modify data source signons , but if you have a lot of users, it can be unwieldy for data source configurations that require each user to have their own signon since the credentials for each user must be done individually. You can also view the data source credentials for other users. Note that credentials are checked in the following order: first, the signons that you create as an administrator are checked if no credentials are found for the use