BusinessObjects Board

Aggregation on synchronized queries

Let’s say I have one dataprovider with person and income.
Another universe gives me person and company.

I make two queries with person as merged dimension.

Now I want a report with total income per company, but I don’t want to see individual persons in my report.

Can any of you explain me how to build this?


Karel duran (BOB member since 2009-06-26)

You can build this. Your unlinked dimension needs to be changed to a detail and associated with the linked dimension. Do this by creating a variable.

You can get a doc that explains this here:

http://www.noscentia.com/reference/

or here:

You may need to use the multi provider function if the aggregation doesn’t look right. But I suspect that’s been fixed.


SteveBickerton :canada: (BOB member since 2002-08-15)