Skip to Content
avatar image
Former Member

Error : Not a single group function while creating and Object in Universe

Hi BO Users ,

I have a requirement of creating a object in Universe with following definition :

Avg= ((Date1-Date2)*24) /Count(IDs)

After creating this object at Universe its throwing :* Error Not a Single group function *

Can anybody pls help me how I can achieve this Avg object in Universe .

Regards

Swapnil

Edited by: swapnil_taz on Nov 18, 2010 6:00 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 19, 2010 at 01:48 PM

    create a Measure object of type Count (in the select have ID)

    Create an Dimension object which holds your formula/(measure object you created)

    Thanks,

    ganesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 18, 2010 at 07:46 AM

    Please let us know your universe is pointing to which database(Oracle,SQL Server .. etc)

    Also try to generate SQL using Tools->Query Panel Utility in designer.

    This will be posible if you save this object though the object could not parse.

    This will help you to identify the incorrect syntax in the query itself.

    Thanks,

    Sachin Dalal

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sachin ,

      I am using Oracle as my DB .

      There is no problem with the Syntax even if you try to do this through sysdate and dual you would get the same error .

      Regards

      Swapnil

  • avatar image
    Former Member
    Nov 18, 2010 at 08:48 AM

    Hi Swapnil,

    When you are using a count function there should be group by clause so i guess you are not adding any dimension to your query and with the information provided we cannot help you a lot on this.

    is the ID column from same table or different table?

    Regards

    Kunal

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Swapnil,

      Keep the object Avg=((DAte1- Date2)*24)/Count (Ids) as it is and ignore the error when parsing this object.

      In addition, create two new universe objects for Date1 and Date2 (saperate) as Dimension.

      Include Date1 and Date2 objects in the data set (query) whenever you add Avg object in the report.

      The idea is, when you select Date1 and Date2 objects as dimension object, BO will automatically include them in GROUP BY clause of the query.

      I am sure this will resolve your problem.

      Thanks,

      Sachin Dalal