COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: dxwallace on 30 May 2007 04:45:08 PM

Title: What does XSUM, XMIN do
Post by: dxwallace on 30 May 2007 04:45:08 PM
Can someone tell me what XSUM and XMIN do in SQL? I cannor find them defined in the documentation.

thanks
Title: Re: What does XSUM, XMIN do
Post by: larsonr on 30 May 2007 08:43:32 PM
The X stands for extended.  Your report is probably doing some arithmetic on the application outside of the database that is generating these xsums and xmins.  If they are hinderance, then try rewriting the report to push the calcs onto the database.