COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Query Studio => Topic started by: mantooth on 02 Oct 2013 09:24:50 AM

Title: Best Practices - setting up big reports
Post by: mantooth on 02 Oct 2013 09:24:50 AM
Hello

I am new to QueryStudio and was hoping to get some tips on setting up big reports to run overnight.

I am trying to set up a report with 5 columns of data: 2 business dimensions at their lowest level, 1 year of data by month, 1 sales column, 1 revenue column.

The problem I have is when adding the sales/revenue columns, it seems like the report tries to actually run (which takes several hours).

But what I want is to set up the definition of the report, and have the numbers run overnight.

Are there any settings to prevent the report from calculating when setting it up, or perhaps a better way to accomplish my task?
Title: Re: Best Practices - setting up big reports
Post by: mantooth on 02 Oct 2013 10:27:06 AM
Nevermind I figured it out... ::)

Manage File > My Preferences > Preview With No Data