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

 

Report Studio Generating SQL with sum(xxxxxx) over (partition by yyyyy, zzzzz)

Started by pdaprem, 23 Mar 2012 01:11:28 PM

Previous topic - Next topic

pdaprem

What in the Framework Model would cause Cognos Report Studio to generate a sum(Table2.Amount) over (partition by nnnnn, mmmm, etc) where the data field referencing folloing the 'partition by' are essentially all of the other data elements (113) in the report. The data element Table2.Amount is a dollar amount field which comes directly from on of my tables on my data source. The Table2 table is on the 1:1 side of the relationship with my main table, Table1, while Table1 is 0:n to Table2.  Table1 is either 0:n or 1:n with all the other tables to which it has relationships.

Don't know how to determine what impact this is having on my Report performance but my gut says it isn't positive.

Any insights would be appreciated!!

blom0344

1:1 side should normally not store facts. Cognos however can cope with this scenario, but only with the proper determinant(s) set.  The 1:1 side should have an unique determinant defined