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.

You want to see the log of transport connection. What t-code would you use? List the steps.

925

---

What are the combined tests?

1785

---

What are the steps to create DB connect?

1929

---

Where to check the log for warning messages appearing in activation of transfer rules?

933

---

What is web template.

898

---

What are the steps to load non cumulative cube?

2392

---

What are the important aggregation usage indicators?

2030

---

How do you do Currency translation in SAP BW ?What are the settings that needs to be done?

1089

---

Can you convert an infopackage group into a process chain?

1054

---

In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow.

1547

---

How would you measure the size of a infocube?

890

---

What is the use of db connection in sap bw data acquisition?

933

---

What is the alpha check execution program?

2175

---

What is the structure of infocube?

917

---

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

822

---