BusinessObjects Board

MDX vs Database Delegated

general discussion
#1

Hi all,

When we use any aggregation function, the micro cube deal with the aggregation and I thought if I use database delegated the behavior would be the same.
My database is SAP BW and when we refresh the report, the universe create a MDX and send it to BW.

My question is: When the universe create a MDX with database delegated, it create many MDX or only one (I have many blocks)?
How universe can deal with this situation and when he do a aggregation?
In this situation the micro cube take care of the aggregation?

Thank you very much.
Gustavo

defaro :brazil: (BOB member since 2006-09-01)

#2

Please, start here: SQL Aggregates

Essentially, the same applies to MDX based data sources.

Andreas :de: (BOB member since 2002-06-20)