1704565 - IDT Creating Custom Functions with Oracle

• Group by incorrectly generates in SQL when using custom aggregate Oracle Functions
• Exception: DBD, ORA-00934: group function is not allowed here
• Exception: DBD, ORA-00937: not a single-group function state:N/A
  
  

• SAP BusinessObjects Business Intelligence platform
• Universe Design Tool (UDT)
• Information Desgin Tool (IDT)
• Oracle

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-IDT , Information design tool , BI-BIP-UDT , Universe Design Tool , Problem