Group by fonctionnalty in BO universes

[Former Member]

Hi experts,

I created a BO univers, using IDT 4.1 on a table that contains the following colums:

Operation_ID      |     Company     |     Operation_Status     |     Region     |     Activity type     ...

I need to count the number of Operation by Company and Operation status. The SQL statement is like:

Select (Distinct(Operation_ID))

From my table

Group by Company, Operation_Statut

How can I use Group by in BO univer?

Thank's a lot for your help.

Abdess

[Former Member · Accepted solution]

Hi Abdess,

You dont have to write a custom query for using Grouyp by function in BO designer.

You can create a measure object as Count(object_id) in universe.

In the report, what ever dimensions you are selecting along with this measure will be grouped by automatically.

You also have an option of creating derive table to create your custom query.

For you above requirement you can just drag all the objects in the query and can set the query property as 'do not retrieve duplicate rows'

Thanks

[Former Member · Accepted solution]

Hi Gaurav,

You right, I created a mesure 'NbrOperation' objects as Count(distinct(Operation_ID)), and on the report I created a request on the univers by draging: Company, Operation_Status and the measure NbrOperation. So like you said, the grouping is automatically performed using the dragged dimension objects...

Thank's a lot.

Abdess,