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

Query adding over() to an average column

Started by dbanas, 19 May 2016 08:49:46 AM

Previous topic - Next topic

dbanas

I've run into a problem calculating a price column in a report. This column is defined to be an average when aggregated. It changes based on date so pulling it for a day should result in the price on that date.  The table this column exists in is joined to a fact table using a left outer join with a 0 to 1 relationship.  When I include this column in a report is sets the calculation to:

, sum("T0"."C20") over ()/nullif(sum("T0"."C21") over (), 0) "Contract___Delivered_Price"

(entire query is attached)

This is causing every row in the report to be the same number instead of an average of each row.  The report worked previously.  I don't understand what is causing it to do an average over().  We've applied a couple patches to our Cognos 10.2.1 environment but I didn't see any bugs related to this problem.