ISA Logo

ISA Consulting on Facebook

March 11th, 2010 by gpodio

ISA Consulting has joined Facebook, become a fan and keep up with the latest from ISA:

http://www.facebook.com/pages/ISA-Consulting/334682629513

Posted in Uncategorized having no comments »

Analysis Studio Tip – How to hide & unhide columns, rows or totals

March 10th, 2010 by gpodio

How to hide & unhide columns, rows or totals

To create a bar chart that compares products for 2005, 2006 and 2007 it requires that you hide 2004, the Time summary and the More & Hidden columns.

Right-click and hide 2004:

10Q1_AS1

Hide More & Hidden and Time Column:

10Q1_AS2

Bringing back 2004 data, Click on the Properties icon:

10Q1_AS3

Click on link to Time link:

10Q1_AS4

Click on down arrow by Hidden items and select Unhide 2004:

10Q1_AS5

Click on Subtotals link:

10Q1_AS6

Put a check mark next to Overall total and click on Save:

10Q1_AS7

The report with no hidden columns:

10Q1_AS8

Posted in Cognos Tips and Tricks having no comments »

Query Studio Tip – Setting Page Breaks

August 25th, 2009 by gpodio

Setting Page Breaks

Creating sections in a report allows you to then create page breaks off of those sections.

To create a section:

1.      Highlight the column you would like to use as the section.

2.      Click on the Section icon.

Query Studio Page Break

To create the Page Breaks:

1. Highlight the sectioned report item

2. Change Layout \ Set Page Breaks

Query Studio Page Break

To see the page breaks:

1. Run Report

2. View as PDF

Note: The PDF file will show a page break after all the products for each retailer listed.

Query Studio Page Break

In this example there is a section on Retailer and Product Line.  Use Page down to see how the report pages break after each product for a retailer.

querystudio_pagebreaks4

Posted in Cognos Tips and Tricks having no comments »