Arul's.TEG Blog

What are the possible reasons why an output of type CSV, PDF or MHT could take extremely long to download over the network between the Cognos report server and client computer? Solution There are a few important factors that will influence the download time of output files. Here are some of the most important considerations when troubleshooting download speeds: 1) All of the components in the network make up the path between the server and the client. This means that the slowest link in the chain will be the maximum speed of the network. For instance, if there is a 100 Mb/s LAN connection between the client PC and the network Hub, then the Hub is most likely connected to another Hub or Switch, and follows a path of connectivity all the way back to the server.  In short, if a 100 Mb/s hub has 8 ports, then the 100 Mb/s traffic is shared equally over all 8 ports, which in effect gives only 12 Mb/s per connection. This will allow a maximum of 1.5 Mb/s downloads in between two PC's co...

You can disable selection-based interactivity for an HTML report that is viewed in Cognos Viewer to shorten the time that it takes the report to run. After you disable this functionality, you cannot:     drill up and down in a report     drill through to other reports     use Cognos Search     use conditional report delivery     use agent notification If selection-based interactivity is enabled in IBM Cognos Connection, a user can perform drill up and down and drill-through actions in Report Viewer or Query Studio. If selection-based interactivity is disabled in IBM Cognos Connection, the ability to perform drill up and down and drill-through are disabled regardless of how the drill through definitions and settings are authored in Report Studio and IBM Cognos Connection. Selection-based interactivity is enabled by default. Tip: You can instead enable or disable selection-based interactivity for the current run ...

Database server administrators can log and analyze the dynamic SQL workload generated by IBM Cognos 8. As an IBM Cognos 8 administrator, you can define a custom string that includes application context that is added as a comment marker within SQL generated by the application. You can use literals, macros, and session variables, such as a user name, server name, qualified report path, and so on, to customize the comment generated by Cognos 8. By using the applicable session variables, you can configure the format of the string for specific tools and products that can extract comments from dynamic SQL. IBM Cognos 8 includes the comments within any dynamic SQL it generates to a Relational Database Management System (RDBMS) if the vendor supports this functionality. Use the CQEConfig.xml.sample file included with the product to customize the string specifications. The macro in this file shows the default entries that IBM Cognos 8 uses for generating the comments. However, you can add oth...

Besides the difference in size of addressable memory space, what are the other considerations of running a 32-bit vs 64-bit report server? Why is a "QFS-ERR-0141: This report service is configured as 64-bit and only supports packages published with the dynamic query mode" error message being returned when trying to run a report with a 64-bit report service? Answer - A 64-bit Application Tier install of 10.1.1 (RP1) will by default be running a 32-bit report server. - A 64-bit install of 10.1.1 (RP1) running a 32-bit report server will launch a 64-bit java process for Dynamic Query Mode (DQM) enabled packages and will also launch a 32-bit BIBUS processes for CQM packages. - A 64-bit install of 10.1.1 (RP1) running a 64-bit report server can only launch a DQM java process. It cannot launch BIBUS processes hence it is only to be used with DQM packages and not CQM packages. - If an environment has a 64-bit report server and Compatible Query Mode (CQM) p...

In order to create a user experience that takes advantage of standard touch interface interactions, the swiping gesture can be implemented on Decks or Data Decks. This functionality is complemented by the Iterator control, which can be configured to appear as page dots to indicate the current selection. The following high-level procedure can be followed to enable swiping and obtain the corresponding page indicator dot look and feel for the Iterator control: •    Ensure that the Iterator and the Deck are driven by the same values •    Create a variable to be used to control the selection •    Configure the Interactive Behaviour of both the Iterator and the Deck so that each control sets (Set Variable Values) and is selected by (Container Select) the same variable •    Enable the desired Slide Animation Direction effect on the Deck •    For the Iterator control, ensure that the Iterator First, Iterator Previous, ...

Cognos 10 marks a significant improvement in a new charting engine. Charts are without a doubt, a very powerful tool to deliver information. The chart enhancements made in IBM Cognos 10 focus on improving the effectiveness of this communication. This article discusses the Bullet Chart.   Bullet charts are variation of bar charts. They compare a featured measure to a targeted measure. A bullet chart features a single primary measure, such as current revenue. It compares that measure to one or more other measures, such as the target or planned revenue, and displays it in the context of a qualitative range of performance, such as poor, satisfactory, or good. A Bullet Chart Contains: A bullet measure, which appears by default as a blue bar in the chart. A target measure, which appears as a dash in the chart. The color ranges, which help to describe the qualitative state of the featured measure. Labels identifying measures and numeric scale. Let’...