If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Need to add a column to a prompted report

Started by ezgrand, 14 Apr 2008 10:18:42 PM

Previous topic - Next topic

ezgrand

Hello Everyone :),

I have a reported that can be prompted using day date name--say from Jan 1 to Jan 16, 2008.  The columns, sales, plan for the period, last year's sale for the period are properly filtered by the date prompt parameter.

Users need to look at the full month's plan .  For example , for january 2008, they want to see the plan for the period AND the Plan for the whole month.

THe date parameter filters all columns--including the Plan for the Month.

If you prompt it less than a full month, plan for the month also shows just the inclusive days of the prompt.

What is the best way to add the full month plan--without being affected by the prompt filter?

Thanks!


Suraj

Create a separate query that doesn't have the prompt filter.
Then have a list or crosstab from this query that is unaffected by the prompt selection.

almeids

To expand on Suraj's suggestion: in the separate Plan query, add a filter which uses the month portion of your prompt dates.  You didn't mention whether the report can be run for a range which spans multiple months, but if so you'll need to consider that in creating the filter expression for the new query.
Presumably you want the full-month plan data reported along with the rest, so you may want to union the new query with the existing one to include both sets of data in your existing list or crosstab rather than adding another.
Another possible approach would be to read the entire month from the database and conditionally calculate the non-Plan measures based on the prompt date range.  The viability of this approach depends on the structure of your source(s), and there may be performance implications since you're reading more data.