Answer Posted / lam nguyen

I am inclined to say "yes". If you have an aggregate on an
InfoCube that is
an Involved InfoProvider in a MultiProvider, the aggregate
will be used if
you query on the MultiProvider.

Now, I know we're not in a "court of law" here, so if
anyone sees a flaw or
an error in my explanation, please feel free to correct
me. :-)

I am basing my answer only on my experience debugging the
SAP function
module RSDRI_INFOPROV_READ. This API contains many
parameters, including a
Boolean called "i_use_aggr_cubes" which automatically
defaults to TRUE.
Another parameter in this API is i_cubetype. If you have a
Basic cube the
value is 'B', if it's a MultiProvider the value is 'M'.

When RSDRI_INFOPROV_READ is called for i_cubetype = 'M',
the following
sequence will (or should) take place:

- Function RSDRI_INFOPROV_READ (i_cubetype = 'M',
i_use_aggr_cubes = TRUE).
- Function RSDRC_CUBE_DATA_GET.
- Form DATA_GET --> There is a "CASE i_cubetype" statement
here!
- Function RSDRC_MULTI_CUBE_DATA_GET --> because of the
CASE statement
above.
- Function RSDRC_MULTI_CUBE_DATA_GET_PARA (if parallel
processing is
allowed).
- Form GET_MULTICUBE_INFO --> This determines the Involved
InfoProviders and
which of these need to "participate" in the query.

At this point, there is a LOOP on the Participating
InfoProviders and a call
to Form ADJUST_INPUT_FOR_MULTICUBE for each of the
Participating
InfoProviders. If there is an aggregate on the Basic
InfoCube it should find
it and use it.

Explain customization?

963

---

what is the data model and how it is use ?

1995

---

What is the use of multi-provider in the sap?

953

---

Give an example for this URL command?

2129

---

explain return tables. How do start routine and return table synchronize with each other?

1097

---

Is the user exit common for all data sources?

1879

---

When you can use the process chain in the data warehouse?

855

---

What is a dashboard in sap bw?

1046

---

What is the advantage of CO-PA?

1945

---

How to create condition and exceptions in bi.7.0?

914

---

How do you debug user exit?

1858

---

what are the drawbacks of cubes?

1029

---

What are tickets.

945

---

Where the data is extracted during init of delta and during delta updates?

1992

---

Explain the structure of direct update dso?

1048

---