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

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

Hi Sachin ,

This is object in the Universe not in my report .

I am trying to create an Object In unverse with the Above definition .

Avg=((DAte1- Date2)*24)/Count (Ids)

I am getting this error while parsing this Object in Universe

Regardless of Whether this ID object belong to same or different table , I have checked Both the problem persist.

Regarsd

Swapnil

Edited by: swapnil_taz on Nov 18, 2010 9:55 AM

[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

[Former Member]

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

[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