Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
IBM Cognos 8 Report Studio Cookbook
IBM Cognos 8 Report Studio Cookbook

IBM Cognos 8 Report Studio Cookbook: Over 80 great recipes for taking control of Cognos 8 Report Studio

Arrow left icon
Profile Icon Abhishek Sanghani
Arrow right icon
zł59.99 zł203.99
Full star icon Full star icon Full star icon Empty star icon Empty star icon 3 (3 Ratings)
eBook Jun 2010 272 pages 1st Edition
eBook
zł59.99 zł203.99
Paperback
zł254.99
Subscription
Free Trial
Arrow left icon
Profile Icon Abhishek Sanghani
Arrow right icon
zł59.99 zł203.99
Full star icon Full star icon Full star icon Empty star icon Empty star icon 3 (3 Ratings)
eBook Jun 2010 272 pages 1st Edition
eBook
zł59.99 zł203.99
Paperback
zł254.99
Subscription
Free Trial
eBook
zł59.99 zł203.99
Paperback
zł254.99
Subscription
Free Trial

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Table of content icon View table of contents Preview book icon Preview Book

IBM Cognos 8 Report Studio Cookbook

Chapter 1. Report Authoring Basic Concepts

In this chapter, we will cover the following:

  • The summary filter and detail filter

  • Sorting options

  • Aggregation and rollup aggregation

  • Implementing IF THEN ELSE in filtering

  • Data formatting options

  • Creating sections

  • Hiding columns in crosstab

  • Examining display value and use value for prompts

Introduction


In this chapter, we will cover some fundamental techniques which will be used in your day-to-day life as a Report Studio author. In each recipe, we will take a real life example and see how it can be accomplished. At the end of the chapter, you will have learnt several concepts and ideas which you can mix-n-match to build complex reports.

Though this chapter is called 'Basic Concepts', it is not a beginner's guide or a manual. It expects the following:

  • You are familiar with the Report Studio environment, components, and terminologies

  • You know how to add items on the report page and open various explorers and panes

  • You can locate the properties window and know how to test run the report

Based on my personal experience, I will suggest this chapter to new developers with two days to two months of experience. If you have larger experience with Report Studio, you might want to jump to the next chapter.

In the most raw terminology, a report is a bunch of rows and columns. The aim is to extract the right rows and columns from database and present them to the users. The selection of columns drive what information is shown in the report, and the selection of rows narrows the report to a specific purpose and makes it meaningful. The selection of rows is controlled by 'Filters'. Report Studio provides three types of filtering: Detail, Summary, and Slicer. Slicers are used with dimensional models and will be covered in later chapter (Chapter 7, Working with Dimensional Models). In the first recipe, we will cover when and why to use the Detail and Summary filter.

Once we get the correct set of rows by applying the filters, the next step is to present the rows in the most business-friendly manner. Grouping and ordering plays an important role in this. The second recipe will introduce you to the sorting technique for grouped reports.

With grouped reports, we often need to produce sub-totals and totals. There are various types of aggregation possible. For example, average, total, count, and so on. Sometimes the nature of business demands complex aggregation as well. In the third recipe, you will learn how to introduce aggregation without increasing the length of query. It will also show you how to achieve different aggregation for sub-totals and totals.

The fourth recipe will build upon the filtering concept you will have learnt earlier. It will talk about implementing IF THEN ELSE logic in filters. Then, we will see some techniques around data formatting, creating sections in a report, and hiding a column in crosstab.

Finally, the eighth and last recipe of this chapter will show you how to use prompt's Use Value and Display Value properties to achieve better performing queries.

The examples used in all the recipes are based on the GO Data Warehouse (Query) package which is supplied with Cognos 8.4 installation. These recipe samples can be downloaded from the Packt Publishing website. They use the relational schema from Sales and Marketing | Sales (query) namespace.

This is similar to Database Layer of the traditional GOSales package supplied with Cognos 8.2.

Please note that though there might be slight variations to scripts or features available in different versions of Report Studio, all the recipes mentioned in this book are applicable for all versions of Cognos 8 (8.1 through 8.4).

The screenshots used throughout this book are based on version 8.4. With versions 8.3 and 8.4, you need to choose Professional Authoring Mode from the View menu.

Summary filter and detail filter


Business owners need to see the sales quantity of their product lines to plan their strategy. They want to concentrate only on the highest selling product for each product line. They would also like the facility to select only those orders that are shipped in a particular month, for this analysis.

In this recipe, we will create a list report with product line, product name, and quantity as columns. We will create optional filter on Shipment Month Key. Also, we will apply correct filtering to bring only the highest sold product per product line.

Getting ready

Create a new list report based on GO Data Warehouse (query) package. From the Sales (query) namespace, bring Product | Product Line, Product | Product Name, and Sales fact | Quantity as columns.

How to do it...

  1. We will start with adding the optional filter on shipment month. To do that, click anywhere on the list report on Report Page. Select Filters from the toolbox.

  2. In the Filters dialog box, add a new detail filter. Define filter as:

    [Sales (query)].[Time (ship date)].[Month key (ship date)] = ?ShipMonth?
  3. Set the usage to Optional.

  4. Now we will add a filter to bring only highest sold Product per Product line. To achieve this, select Product line and Product name (Ctrl+select) and click on the Group button from toolbox.

    This will create grouping shown as follows:

  5. Now select the list and click on Filter button again. This time go to the Summary filters tab and add a new filter.

  6. Define the filter as: [Quantity] = maximum([Quantity] for [Product line]).

  7. Set usage to Required and set the scope to Product name.

  8. Now run the report to test the functionality. You can enter 200401 as Month Key as that has data in the Cognos supplied sample.

How it works...

Report Studio allows you to define two types of filters. Both work at different grain and hence have different applications.

Detail filter

The detail filter works at the lowest level of granularity in selected cluster of objects. In our example, this grain is the 'Sales entries' stored in the 'Sales fact'. By putting a detail filter on shipment month, we are making sure that only those sales entries which fall within the selected month are pulled out.

Summary filter

In order to achieve the highest sold product per product line, we need to consider the aggregated sales quantity for the products.

If we put a detail filter on quantity, it will work at sales entry level. You can try putting a detail filter of [Quantity] = maximum([Quantity] for [Product line]) and you will see that it gives incorrect results.

So, we need to put a summary filter here. In order to let the query engine know that we are interested in filtering sales aggregated at product level, we need to set the SCOPE to Product name. This makes the query engine calculate [Quantity] at product name level and then allows only those product names where the value matches maximum([Quantity] for [Product line]).

There's more...

When you define multiple levels of grouping, you can easily change the scope of summary filters to decide the grain of filtering.

For example, if you need to show only those products whose sales are more than 1000 and only those product lines whose sales are more than 25000, you can quickly put two summary filters for [Quantity] with the correct Scope setting.

Before/After aggregation

The detail filter can also be set to apply after aggregation (by changing the application property). However, I think this kills the logic of detail filter. Also, there is no control on the grain at which the filter will apply. Hence, Cognos sets it to before aggregation by default, which is the most natural usage of the detail filter.

See also

Please read the "Implementing IF THEN ELSE in filtering" recipe in this chapter.

Sorting grouped values


The output of the previous recipe brings the right information back to the screen. It filters the rows correctly and shows highest selling product per product line for selected shipment month.

For better representation and to highlight the best selling product lines, we need to sort the product lines in descending order of quantity.

Getting ready

Open the report created in the previous recipe in Cognos Report Studio for further amendments.

How to do it...

  1. Open the report in Cognos Report Studio.

  2. Select the Quantity column.

  3. Click on the Sort button from toolbar and choose Sort Descending.

  4. Run the report to check if sorting is working. You will notice that sorting is not working.

  5. Now go back to Report Studio, select Quantity, and click the Sort button again. This time choose Advanced Sorting.

  6. Expand the tree for Product line. Drag Quantity from Detail Sort List to Sort List under Product line.

  7. Click the OK button and test the report. This time the rows are sorted in descending order of Quantity as required.

How it works...

The Sort option by default works at the detailed level. This means the non-grouped items are sorted by the specified criteria within their own groups.

Here we want to sort the product lines which are grouped (not detailed items). In order to sort the Groups, we need to define the advanced sorting option as shown in this recipe.

There's more...

You can define it so for the whole list report from the Advanced Sorting dialog box. You can use different items and ordering for different groups and details.

You can also choose to sort certain groups by the data items that are not shown in the report. You need only bring those items from Source (model) to the Query, and you will be able to pick it in the sorting dialog.

Aggregation and rollup aggregation


Business owners want to see the unit cost of every product. They also want the entries to be grouped by product line and see the highest unit cost for each product line. At the end of the report, they want to see the average unit cost for the whole range.

Getting ready

Create a simple list report with Product | Product line, Product | Product name and Sales Fact | Unit Cost as columns.

How to do it...

  1. We will start by examining the Unit Cost column. Click on this column and check the Aggregate Function property.

  2. Set this property to Average.

  3. Add grouping for Product line and Product names, by selecting those columns and hitting the GROUP button from toolbar.

  4. Click on the Unit Cost column and click on the Aggregate button from toolbox. Select Aggregate option from the list.

  5. Now click again on the Aggregate button and choose Average option.

  6. This will create footers shown as follows:

  7. Now delete the line with Average (Unit cost) measure for Product line. Similarly, delete the line with <Unit cost> measure from Summary. The report should look like this:

  8. Click on the Unit cost column and change its rollup aggregate function to Maximum.

  9. Run the report to test it.

How it works...

In this recipe, we have seen two properties of the data items related to aggregation of the values.

Aggregation property

We first examined the aggregation property of unit cost and ensured that it is set to average. Remember that the unit cost here comes from the sales table. The grain of this table is sales entries or orders. This means there will be many entries for each product and their unit cost will repeat.

We want to show only one entry for each product and the unit cost needs to be rolled up correctly. The aggregation property determines what value is shown for unit cost when calculated at product level. If it is set to TOTAL, it will wrongly add up the unit costs for each sales entry. Hence, we are setting it to AVERAGE. It can be set to MINIMUM or MAXIMUM depending on business requirements.

Rollup aggregation

In order to show the MAXIMUM unit cost for product type, we create an 'Aggregate' type of footer in step 4 and set the Rollup Aggregation to Maximum in step 8.

Note

Here we could have directly selected MAXIMUM from the 'Aggregate' drop-down toolbox. But that creates a new data item called Maximum (Unit Cost). Instead, we ask Cognos to aggregate the number in footer and drive the type by rollup aggregation property. This will reduce one data item in the Query Subject and Native SQL.

Multiple aggregations

We also need to show the overall average at the bottom. For this we have to create a new data item. So, we selected unit cost and created an 'Average' type of aggregation in step 5. This calculates the Average (Unit Cost) and places it on the product line and in the overall footer.

We then deleted the aggregations that are not required in step 7.

There's more...

The rollup aggregation of any item is important only when you create the aggregation of 'Aggregate' type. When it is set to automatic, Cognos will decide the function based on data type which is not preferred.

It is good practice to always set the aggregation and rollup aggregation to meaning function than leaving as 'automatic'.

Implementing IF THEN ELSE in filters


Business owners want to see the sales quantity by order methods. However, for the 'Sales Visit' type of order method, they want a facility to select the retailer.

Therefore, the report should show quantity by order methods. For the order methods other than 'Sales Visit', the report should consider all the retailers. For 'Sales Visit' orders, it should filter on the selected retailer.

Getting ready

Create a simple list report with Order Method | Order Method and Sales Fact | Sales Quantity as columns. Group by order method to get one row per method and set the aggregation for quantity to TOTAL.

How to do it...

  1. Here we need to apply the retailer filter only if Order Method is 'Sales Visit'. So, we start with adding a new detail filter.

  2. Define the filter as: if ([Order method]='Sales visit') then ([Sales (query)].[Retailer site].[Retailer name] = ?SalesVisitRetailer?)

  3. Validate the report. You will find multiple error messages.

  4. Now change filter definition to this: (([Order method]='Sales visit') and ([Sales (query)].[Retailer site].[Retailer name] = ?SalesVisitRetailer?)) or ([Order method]<>'Sales visit')

  5. Validate the report and it will be successful.

  6. Run the report and test the data.

How it works...

The IF ELSE construct works fine when it is used in data expression. However, when we use it in a filter, Cognos often doesn't like it. It is strange because the filter is parsed and validated fine in the expression window and IF ELSE is a valid construct.

The workaround for this problem is to use the pair of AND..OR as shown in this recipe. The IF condition and corresponding action item are joined with AND clause. The ELSE part is taken care by OR operations with the reverse condition (in our example, Order Method <> 'Sales Visit').

There's more...

You need not use both AND and OR clauses all the time. The filtering in this example can also be achieved by this expression:

([Sales (query)].[Retailer site].[Retailer name] = ?SalesVisitRetailer?)

or

([Order method]<>'Sales visit')

Depending on the requirement, you need to use only OR, only AND, or the combination of AND..OR.

Make sure that you cover all the possibilities.

Data formatting options: Dates, numbers, and percentages


Virtually all the reports involve displaying numerical information. It is very important to correctly format the numbers. In this recipe, we will create a report which formats dates, numbers, and percentages.

Date transformation and formatting are important in business reports. We will see two ways of displaying MONTH-YEAR from the 'Shipment Date Key'. We will apply some formatting to a numeric column and will also configure a ratio to be displayed as percentage.

Getting ready

Create a simple list report with Product | Product line, Product | Product type and Time (Ship date) | Day key (Ship date) as columns from the Sales (query) namespace.

Also add Quantity, Unit Price, and Unit Cost from the Sales Fact Query Subject.

Create grouping on Product line and Product type.

How to do it...

  1. We will start by adding a new calculation to convert the Shipment Day Key into a date and show in MONTH-YEAR format. So, add a new Query Calculation to the report from the toolbox.

  2. Define the calculation as: cast([Sales (query)].[Time (ship date)].[Day key (ship date)], date).

  3. Select this new column for the calculation and open Data Format from Properties pane. Open the Data Format dialog by clicking on the browse button next to Data Format property.

  4. Choose the format type Date, set Date Style to Medium, and set Display Days to No.

  5. Now select the Quantity column on the report. Choose Data Format from property and open the dialog again.

  6. This time pick 'Number' as the type and set different properties as required. In our example recipe, we will set the number of decimal points to 2, and use brackets () as a negative sign symbol.

  7. Finally, we will add the ratio calculation to report. For that, add a new query calculation and define it as: [Unit price]/[Unit cost].

  8. Select this column and from Data Format property dialog, set it as Percent. Choose % as the percent symbol and set the number of decimal places to 2. Also set the Divide by Zero Characters to N/A.

  9. Run the report to test it.

How it works...

In this recipe, we are trying multiple techniques. We are using the CAST function to convert a number to date. Also, we are checking how dates can be formatted to hide certain details (for example, days) and how to change the separator. Finally, we have tested formatting options for numbers and percentage.

CAST function

The CAST function is used to convert data from one format to another. We specify the target format in second argument. Here, we are converting to date. It converts the date key which is in YYYYMMDD format to a date.

Later, we are setting the data format for this column as date for display purpose. We have set the display days to No as we only want to display MONTH-YEAR.

Numerical format

This is straightforward. The quantity column is displayed with two decimal points and negative numbers are displayed in brackets as this is what we have set the data formatting to.

% Margin

The ratio of unit price to unit cost is calculated by this item. Without formatting, the value is simply the result of division operation. By setting the data format to Percent, Cognos automatically multiplies the ratio by 100 and displays it as percentage.

There's more...

Please note that ideally the warehouse stores a calendar table with a 'Date' type of field , or this is made available through Framework Model. So, we need not cast the key to date every time. However, this recipe is meant to show you the technique and introduce you to the casting function.

Also, we are assuming here that business needs to see the shipment month. So, they want to see MONTH YEAR format only and we are hiding the days.

Another way of achieving this is explained as follows:

Let us change the expression for Shipment Day Key column to this: [Sales (query)].[Time (ship date)].[Day key (ship date)]/10000

Now set the Data Format to Number, with the following options:

  • No of decimal places = 2

  • Decimal separator = hyphen (-)

  • Use thousand separator = No

Run the report to examine the output. You will see that we have gotten rid of the last two digits from the day key and the year part is separated from month part by a hyphen. This is not truly converted to MONTH YEAR but conveys the information.

The advantage here is that the numerical operation is faster than CAST to DATE. We can use similar techniques to cosmetically achieve the required result.

Creating sections


Users want to see the details of Orders. They would like to see the Order number and the details (product name, promotion, quantity, and unit sell price).

Getting ready

Create a simple list report with Sales order | Order number, Product | Product name, Sales fact | Quantity, and Sales fact | Unit sale price as columns.

How to do it...

  1. Click on the Order number column. Hit the section button on the toolbar.

  2. You will see that Report Studio automatically creates a header for Order number and moves it out of the list.

  3. Notice that the Order number field is now grouped.

  4. Run the report to test it.

How it works...

The information we are trying to show in this report can also be achieved by normally grouping on order number. That will bring all the related records together. We can also set appropriate group/level span and sorting for better appearance.

However, in this recipe, I want to introduce another feature of Report Studio called Section.

When you create a section on a column, Report Studio automatically does the following:

  1. It creates a new list object and moves the current report object (in our case, the existing list) inside that. This is report nesting. Both the inner and outer objects use the same query.

  2. It creates grouping on the column selected for section, which is Order Number here. Creates a Group Header for that item and removes it from the inner list.

  3. It formats to outer list appropriately. For example, hiding the column title.

There's more...

Some of the advantages of creating sections are as follows:

  1. As mentioned above, Report Studio does a lot of the work for you and gives a report that looks more presentable. It makes the information more readable by clearly differentiating different entities, in our case, different orders.

  2. As the outer and inner queries are same, there is no maintenance overhead.

See also

If you create a section for a crosstab or chart report, you need to explicitly define the master-detail relationship. Chapter 2 defines the master-detail relationship.

Hiding column in crosstab


Users want to see sales figures by periods and order method. We need to show monthly sales and year's totals. The year should be shown in the Year total row and not as a separate column.

Getting ready

Create a crosstab report with Sales fact | Quantity as a measure. Drag Time dimension | Current year and Month on rows, Order method | Order method on column as shown in the following screenshot. Create aggregation on measure.

Define appropriate sorting.

How to do it...

  1. First, let's identify the issue. If you run the report as it is, you will notice that the year is shown to the left of the months. This consumes one extra column. Also, the yearly total doesn't have user friendly title.

  2. We will start by updating the title for yearly total row. Select <Total(Month)> crosstab node. Change its Source type to Data item value and choose Current year as the Data item.

  3. Run the report and check that the yearly total is shown with the appropriate year.

  4. Now, we need to get rid of the year column on left edge. For that, click the Unlock button on Report Studio toolbar. The icon should change to an open lock (unlocked).
  5. Now select the <#Current Year#> text item and delete it.

  6. Select the empty crosstab node left after deleting the text. Change its padding to 0 pixels and font to 0.001 pt size.

  7. Run the report.

As you can see the year column on the left is now successfully hidden.

How it works...

When we want to hide an object in Report Studio, we often set its Box Type property to None. However, in this case, that was not possible.

Try setting the box type of year column to None and run the report. It will look like the following screenshot:

As you can see, the cells have shifted to the left leaving the titles out of sync. This is most often the problem when Report Studio creates some merged cells (in our case, for the aggregations).

The solution to this is to format the column in such a way that it is hidden in the report.

There's more...

This solution works best in HTML output. The excel output still has a column on the left with no data in it.

You might need to define the background colour and bordering as well, so as to blend the empty column with either the page background on left or the month column on right.

Prompts: Display value versus use value


In order to achieve the best performance with our queries, we need to perform filtering on the numerical key columns. However, the display values in the prompts need to be textual and user friendly.

In this recipe, we will create a filter that displays the product line list (textual values) but actually filters on the numerical codes.

Getting ready

Create a simple list report with Product | Product name and Sales fact | Quantity as columns.

How to do it...

  1. Open Page Explorer and click on the Prompt Pages folder. Drag a new page from Insertable Objects under Prompt Pages.

  2. Double click on the newly created prompt page to open it for editing.

  3. From Insertable Objects, drag Value Prompt to the prompt page. This will open a wizard.

  4. Set the prompt name to ProductLine, and then click Next.

  5. Keep the Createa parameterized filter option checked. For package item, choose Sales (query) | Product | Product line code. Click Next.

  6. Keep Create new query option checked. Give the query name as promptProductLine.

  7. Under Value to display select Sales (query) | Product | Product line .

  8. Click the Finish button. Run the report to test it.

How it works...

When you drag a prompt object from insertable objects, Report Studio launches the prompt wizard.

In the first step, you choose the parameter to be connected to the prompt. It might be an existing parameter (defined in query filter or framework model) or a new one. In this recipe, we chose to create a new one.

Then, you are asked whether you want to create a filter. If there is already a filter defined, you can uncheck this option. In our example, we are choosing this option and creating a filter on Product line code. Please note that we have chosen the numerical key column here. Filtering on a numerical key column is standard practice in data warehousing as it improves the performance of the query and uses the index.

In next step, Report Studio asks where you want to create a new query for prompt. This is the query that will be fired on database to retrieve prompt values. Here we have the option to choose a different column for display value.

In our recipe, we chose Product line as display value. Product line is the textual or descriptive column that is user friendly. It has one to one mapping with the Product line code. For example, Camping Equipment has Product Line Code of 2101.

Hence, when we run the report, we see that the prompt is populated by Product line names, which makes sense to the users. Whereas if you examine the actual query fired on the database, you will see that filtering happens on the key column, that is, Product line code.

There's more...

You can also check the 'Generated SQL' from Report Studio.

For that, select the Tools | Show Generated SQL/MDX option from the menu.

It will prompt you to enter a value for the product line code (which is proof that it will be filtering on the code).

Enter any dummy number and examine the query generated for the report. You will see that the product line code (key column) is being filtered for the value you entered.

So, now you know how the 'Prompt display values' and 'Use values' work.

If you ever need to capture the prompt value selected by the user in expressions (which you will often need for conditional styling or drill-throughs), you can use the following two functions.

  • ParamDisplayValue (parameter name): This function returns the textual value which represents the display value of the prompt. In our example, it will be the product line that was selected by the user.

  • ParamValue(parameter name): This function returns the numeric value which represents the use value of the prompt. In our example, it will be the Product Line Code for the Product Line selected by the user.

Left arrow icon Right arrow icon

Key benefits

  • Learn advanced techniques to produce real-life reports that meet business demands
  • Tricks and hacks for speedy and effortless report development and to overcome tool-based limitations
  • Peek into the best practices used in industry and discern ways to work like a pro
  • Part of Packt's Cookbook series-each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible

Description

Cognos Report Studio is widely used for creating and managing business reports in medium to large companies. It is simple enough for any business analyst, power user, or developer to pick up and start developing basic reports. However, when it comes to developing more sophisticated, fully functional business reports for wider audiences, report authors will need guidance. This book helps you understand and use all the features provided by Report Studio to generate impressive deliverables. It will take you from being a beginner to a professional report author. It bridges the gap between basic training provided by manuals or trainers and the practical techniques learned over years of practice. This book covers all the basic and advanced features of Report Authoring. It begins by bringing readers on the same platform and introducing the fundamental features useful across any level of reporting. Then it ascends to advanced techniques and tricks to overcome Studio limitations.Develop excellent reports using dimensional data sources by following best practices that development work requires in Report Studio. You will also learn about editing the report outside the Studio by directly editing the XML specifications. Provide richness to the user interface by adding JavaScript and HTML tags. The main focus is on the practical use of various powerful features that Report Studio has to offer to suit your business requirements.

Who is this book for?

If you are a Business Intelligence or MIS Developer (programmer) working on Cognos Report Studio who wants to author impressive reports by putting to use what this tool has to offer, this book is for you. You could also be a Business Analyst or Power User who authors his own reports and wants to look beyond the conventional features of Report Studio 8. This book assumes that you can do basic authoring, are aware of the Cognos architecture, and are familiar with Studio.

What you will learn

  • Learn basic and advanced options around sorting, filtering, and aggregation of data
  • Explore the powerful features of Report Studio—Conditional Formatting, Cascaded Prompts, Master-Detailed queries, and more
  • Achieve real business demands such as dynamic drill-though links, showing tooltips, minimum column width, prompt manipulation, and merged cells
  • Learn to edit reports outside Report Studio using XML editing
  • Develop sophisticated printer friendly reports
  • Overcome tool limitations such as row level formatting, timing report execution, handling missing images, and so on
  • Learn tips on report development time
  • Introduce best practices such as inserting comments, regression testing, and version controlling in your reports
  • Enhance the features of Report Studio by using macros
  • Work with dimensional models (DMRs and Cubes)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Jun 01, 2010
Length: 272 pages
Edition : 1st
Language : English
ISBN-13 : 9781849680356
Vendor :
IBM
Category :

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Publication date : Jun 01, 2010
Length: 272 pages
Edition : 1st
Language : English
ISBN-13 : 9781849680356
Vendor :
IBM
Category :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just zł20 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just zł20 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 659.97
IBM Cognos 10 Framework Manager
zł157.99
IBM Cognos 8 Report Studio Cookbook
zł254.99
IBM Rational Team Concert 2 Essentials
zł246.99
Total 659.97 Stars icon

Table of Contents

11 Chapters
Report Authoring Basic Concepts Chevron down icon Chevron up icon
Advanced Report Authoring Chevron down icon Chevron up icon
Tips and Tricks: JavaScripts Chevron down icon Chevron up icon
Tips and Tricks: Report Page Chevron down icon Chevron up icon
XML Editing Chevron down icon Chevron up icon
Writing Printable Reports Chevron down icon Chevron up icon
Working with Dimensional Models Chevron down icon Chevron up icon
Macros Chevron down icon Chevron up icon
Using Report Studio Better Chevron down icon Chevron up icon
Some More Useful Recipes Chevron down icon Chevron up icon
Best Practices Chevron down icon Chevron up icon

Customer reviews

Rating distribution
Full star icon Full star icon Full star icon Empty star icon Empty star icon 3
(3 Ratings)
5 star 33.3%
4 star 0%
3 star 33.3%
2 star 0%
1 star 33.3%
Duane A. Rochelle Jul 02, 2010
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I would definitely recommend this book to anyone looking for ideas to overcome some of many challenges encountered while trying to learn Cognos Report Studio.I work for a company which has recently made a decision to use the Cognos software platform for its performance reporting and data analysis activities. This encouraged me to attended training classes and read numerous technical books\articles on using Report Studio.For the last few months, I have been struggling to master some techniques needed to produce exceptional business reports using Report Studio. Most of the technical guides that I have read contained long drawn-out explanations that were difficult to understand.Within 1 week after purchasing the "IBM Cognos 8 Report Studio Cookbook", I was able to use 3 techniques to overcome some challenges I was having in developing some reports.The author of this book describes his techniques in a simple but effective form using "Getting Ready", "How to do it...", "How it works..." and "There's more...". This makes it easy for readers to easily interpret how to apply the technique being described. I really like the section describing "How it works..." because this is usually not included in most technical guides.This is an excellent book and well worth the price.
Amazon Verified review Amazon
Vic Oct 06, 2010
Full star icon Full star icon Full star icon Empty star icon Empty star icon 3
There are a number of helpful hints and tips here. Some are dead on the money. However, trying to correlate his partial explanations of his examples, to actually applying it to closely related real world issues, is a no go. On one of the pages, he refers you back to IBM's documentation, that has no explanation of the code, and worse, he uses newer code and refers back to old code that won't work on other versions.I'm surprised they didn't edit the book for grammatical errors. Someone else posted on it. For the price, its really sad.
Amazon Verified review Amazon
rvfizher995 Jul 22, 2015
Full star icon Empty star icon Empty star icon Empty star icon Empty star icon 1
Pure Garbage !! Never buy it please !!
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How do I buy and download an eBook? Chevron down icon Chevron up icon

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else
How can I make a purchase on your website? Chevron down icon Chevron up icon

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)
Where can I access support around an eBook? Chevron down icon Chevron up icon
  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us
What eBook formats do Packt support? Chevron down icon Chevron up icon

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks? Chevron down icon Chevron up icon
  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space
What is an eBook? Chevron down icon Chevron up icon

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.