摘要：In order to build analytic reports for Decision Support Systems (DSS) in an organization we can choose to do it by using Business Intelligence techniques such as OLAP and data warehousing or by using traditional reports based on SQL queries. The cost and developing time for BI tools is greater than those for SQL Reports and these factors are important in taking decision on what type of techniques we used for DSS. But some of the requirements of DSS such as prediction or roll-up can make SQL reports development a difficult job. This paper presents some of the analytic functions that are involved in developing SQL reports.
关键词：Decision Support Systems (DSS); Structured Query Language (SQL); aggregate;functions; analytic functions.
