1468684 - BI Analytic Functions Have No Groupby

• Errors creating statistical functions such as Variance  (VAR) and Standard Deviation (STDDEV) in reporting
• Statistical objects parse in in the universe tool but errors in refreshing the query
• Query error in syntax using incorrect Group By
• The variance or standard deviation alone returns a result, but when select with a dimension object it throws..an error.

• SAP BusinessObjects Business Intelligence platform
• Universe Design Tool (UDT)
• Information Design Tool (IDT)
• Web Intelligence (WEBI)

Analytic functions,RANK,SUM,AVG,COUNT,MIN,MAX,RATIO_TO_REPORT,CUME_DIST,CORR,DENSE_RANK,FIRST_VALUE,LAST_VALUE,LAG,LEAD,NTILE,PERCENT_RANK,PERCENTILE_CONT,PERCENTILE_DISC,ROW_NUMBER,CORR,COVAR_POP,COVAR_SAMP,REGR_SLOPE,REGR_INTERCEPT,REGR_COUNT,REGR_R2,REGR_AVGX,REGR_AVGY,REGR_SXX,REGR_SYY,REGR_SXY,STDDEV,STDDEV_POP,STDDEV_SAMP,VAR_POP,VAR_SAMP,VARIANCE , KBA , BI-BIP-UDT , Universe Design Tool , BI-BIP-IDT , Information design tool , Problem