Tip or Technique
Multiple Aligned Column Headers in Lists and Crosstabs
Product(s): IBM Cognos 8
Area of Interest: Report Design
Multiple Aligned Column Headers in Lists and Crosstabs
2
Copyright
Copyright © 2008 Cognos ULC (formerly Cognos Incorporated). Cognos ULC is an IBM Company. While every attempt has been made to ensure that the information in this document is accurate and complete, some typographical errors or technical inaccuracies may exist. Cognos does not accept responsibility for any kind of loss resulting from the use of information contained in this document. This document shows the publication date. The information contained in this document is subject to change without notice.
Any improvements or
…show more content…
The issue with list reports is that the existing column titles does not allow for additional rows to be added.
The techniques described below will allow a report author to add header items such as “Product Per Unit” and “Product Sales” to list reports as in the following: IBM Cognos Proprietary Information
Multiple Aligned Column Headers in Lists and Crosstabs
A similar technique will be presented for crosstabs to incorporate elements into the crosstab structure such as “Order Method Quantity” and “Product
Sales” as in the crosstab image below:
3 Layout and Design
3.1
List Report
Open Report Studio using the ‘GO Sales and Retailers’ sample package and create a new list report.
Drag in right: •
•
•
•
•
•
•
•
•
the following columns into the list in the order below from left to
[gosales_goretailers].[Products].[Product line]
[gosales_goretailers].[Products].[Product type]
[gosales_goretailers].[Products].[Product name]
[gosales_goretailers].[Orders].[Unit cost]
[gosales_goretailers].[Orders].[Unit price]
[gosales_goretailers].[Orders].[Unit sale price]
[gosales_goretailers].[Orders].[Quantity]
[gosales_goretailers].[Orders].[Revenue]
[gosales_goretailers].[Orders].[Gross profit]
Group the [Product line] and [Product type] columns.
Click on the ‘List Headers & Footers’ icon
‘List page header’.
IBM Cognos Proprietary Information
in the
(Click on the Save a Copy button on the panel above to save your report)
It is usually presented in the form of a report in tables, charts, statistics, and graphs or on spread sheets etc. This data may be used to arrive at important decisions within the organisation or with external organisations. So the data report has to be produced in such a way that it meets the aims and
(Click on the Save a Copy button on the panel above to save your report)
(Click on the Save a Copy button on the panel above to save your report)
Within the Flexible Budget Performance Report for Year 9, we begin with units sold and net sales.
In this project, you will modify a workbook for the HSP Computer Superstore to track the sales totals for 2011. You will use functions to calculate total sales, average sales, and median, minimum, and maximum sales values. Additionally, you will create a summary worksheet using values from the other spreadsheets in the workbook.
They offer the topic being discussed as well as professionalism to the report as a whole. Also provides information as to who or what the report belongs to.
At Anthem part of my job is to put together reports to provide a view point that for my teams that reflects the amount of hours and the financial outlook for all the projects that are being worked on. The problem that I and others are facing is that there too many different types of reports. This is a problem because each report is a little different and provides a different view depending on the filters built into the report. With the different filters everyone who has the reports has a different view of the numbers really look like. When I make a report for a Vice President the information is correct but, it could be a set of different numbers than a report someone else gave him using the same filters. In order to get one view, I must utilize
Other users can include suppliers, customers and future investors that want stewardship reporting to calculate performance measurement and evaluation of the company’s current position.
To help the readers understand the report I would use pie charts for each period with the different sales segments in corresponding colours.
With a bi-annual sales report there are usually 3 ways that you can present the information. First one is to present it in a pie graph where it is divided into different sections that have spent the most money. Second is to present it in a bar graph representing again how much each department has spent but in this graph it is simple enough to follow the graph rather than a pie one. Third option is to display in an excel format would can clearly outline each department, expenditure and annual sales etc.
Sales reports - last periods figures Outgoings such as purchases, marketing, loan repayments, etc Staff costs Capital such as stock on hand and cash
The determination of these values requires you to add columns to the Inventory Analysis worksheet. Mr. Milligan asks you to use the worksheet provided. As Mr. Milligan will use the Inventory Analysis worksheet during a presentation, he wants the worksheet to have a professional appearance. To enhance the worksheet’s appearance, you include an appropriate header and format to the worksheet, column, and row labels. The header should display the name of the business, the name of the worksheet, and the current date. As you construct the worksheet, you use the currency format for all columns containing dollar values. Also, for any column that contains a percentage, you
The financial reports are in the business tools (such as Boston Matrix and Ratio Analysis) to evaluate the firm and to decide a course of action. Non- financial tools such as the SWOT and marketing and promotion mix were also used.