Can you create aggregate on ODS or multi provider?
Answers were Sorted based on User's Feedback
Answer / mahesh
NO. AGGREAGTES CAN BE CREATED ONLY ON INFOCUBES
Is This Answer Correct ? | 17 Yes | 4 No |
Answer / 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.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / peggy
Hi Lam Nguyen
you seem very knowledgeable with this function module. Have
you ever encountered this issue? We perform a read of a
multicube using this function module thru a generic
extractor. The selection criteria in the infopackage
automatically calculates the fiscal period to select. When
it rolled over to 001/2011 this year, it stopped pulling
data from the 2011 cube in the multicube (contains 5 cubes,
one for each year). when you use the extractor checker
(RSA2)you get data, but the infopackage doesn't. Any help
is appreciated
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ram
It is not possible, this is due to aggreagates are build
based on munlti dimenstional model.where as DSO is flat
stracutre model. So as per my concern this is not possilbe
to build aggregates on DSO
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / haritha
On a DSO no, On a Multiprovider yes but only if all the infoproviders part of it support the concept of aggregates
Is This Answer Correct ? | 0 Yes | 0 No |
Define a process chain?
if we want to design an info cube,what are the pre-requisites u have to take in real time?
What steps do you take when you add a new company code to the already running delta datasource ? The datasource is already extracting specific company code delta data , so how will add new company code without disturbing delta
How would you do the optimizing the dimensions
How do you use print settings?
What is the RRI. what is the sructure of RRI.any conditions for RRI.
What is a content extraction?
Give the variable types?
What are the limitations of line item dimension?
How is multi provider different from info set?
What is the alpha check execution program?
What are the options available in update rule?