String Aggregation in OBIEE

Hello All,

There was a requirement of aggregating multiple row values to one row. This is a requirement of summarizing the data which is easily achievable using SQL. However this article will provide you information on how to do it in OBIEE.

 

Problem

Here there are different employees in different department .

243

 

And you  would want to see it as below.

 

string aggregation

 

For this you would have to use the EVALUATE Function.

EVALUATE_AGGR(‘LISTAGG(%1,%2) WITHIN GROUP (ORDER BY %3 DESC)’,”Dim – Campaign “.”Employee_Name”,’,’,”Dim – Campaign “.”Employee_Name”)

 

The separator is ‘,’ which can be modified based on your requirement .

 

Thanks

Jethin Abraham

 

Advertisements

One thought on “String Aggregation in OBIEE

  1. I desperately want this to work, however, it doesn’t. I get a syntax error. I’m using this in the presentation layer.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s