Define the technique behind and benefits of standardizing prompt conventions in Report Studio.
Report authors can easily create automatically generated prompt page prompts for data items in a report using the question mark syntax, as shown below: Read more
Three methodologies for documenting Report Studio reports.
Reporting tools like IBM Cognos Report Studio do not naturally provide a means of documenting and commenting procedures like traditional programming languages do. As a result, once a report has been created, it may be difficult to follow the logic and design of the original report, modify it, or reverse-engineer how it works. Additionally, the lack of documentation makes it difficult to determine how and why a report was built and what specific techniques were used to create it. Read more
Using Cognos we can generate reports in Excel, Microsoft Word and Power Point. In this article we will see what components we need to produce these reports in Microsoft Office.
Required Components and Installations:
1. You need to have Cognos environment ready and useable for generating reports, as shown below.
2. You have to install Microsoft Office in all the destination systems or client machines where we are going to access Cognos reports using Microsoft Office components. Read more
As channels of social media penetrate people’s daily life more extensively and intensively, bad reviews and negative opinions travel faster than ever before. Research and surveys have shown that people are far more likely to spread the word about bad experience than a favorable one . Social media, by providing numerous opportunities for word-spreading, escalates this process. It is in the best interest of businesses to monitor comments on social media in real time. Read more
Security in Cognos is extremely robust, permitting or denying very precise access to data elements in a package, data source, or even to row level access in a database. Read & Execute permissions are usually applied to a report allowing certain Groups or Roles the ability to run a report. However, you can also allow or deny access to a report to only let it execute within specific hours of the day. Read more
Difficulty: Easy
Required Ingredients: Prompt macros and static values within a prompt parameter.
You have some existing reports that prompt on Year and Month.
Users would like a better experience by having default selections provided for them. For scheduling purposes you’d also like to set relative time so the report can run based on current month and current year. You can accomplish this using macros. Read more
Difficulty: Easy
Required Ingredients: Report Studio, List Object, PDF Viewer
A report that you expected to be viewed exclusively in HTML will need to be printed. In order to do this, you switch the output to PDF to create a printable report and find that the columns span across multiple pages, making the report more difficult to understand.
You’ll need to make some minor modifications in order for the printable report to remain effective. Read more
Difficulty: Medium
Required Ingredients: Two or more crosstabs, Report Studio, report formatting
You have two or more crosstabs on a Report Studio report. All of the crosstabs should have the same report formatting, which differs from the Cognos default. Read more
Continuing with our Report Studio Cookbook series, today we will look at the new Report Studio JavaScript prompt API available in IBM Cognos 10.2. Since the very first release of the web based Report Studio, report authors have been asked often to use JavaScript in a report to achieve some common web application functionality, such as dynamically show/hide certain objects on page based on a user’s selection or changing a page’s color theme by data values. Ironside has published several articles illustrating how to use JavaScript in Report Studio; however undocumented JavaScript APIs and difficulties in migrating JavaScript after a Cognos upgrade have prevented many report developers from exploring this area. Read more
Ironside is a data, analytics, and AI consulting and technology implementation company. We work with clients to understand their business objectives and day-to-day challenges, then employ our deep expertise in data strategy, architecture and engineering, integration, business intelligence, AI, and generative AI. We create technical solutions and practical approaches designed to drive smarter, data-driven decisions across a company and help it move further and faster toward its business goals.