Aggregation in Cube

[Former Member]

HI,'

Am loading flat file to info cube with delta update say

Customer     product     Category     Qty      Price

c001               p01             Cat1     10          1000

c001               p02               Cat2     20          2000

and perform a full load the the same replicates in cube and then i edit the flat file and run the info package and DTP with delta say am loading

C001    p01   cat1 20 2000

so now the records should be aggregated right? tell me if am wrong am not getting the concept right make it clear to me

i expected the data in cube would be

c001               p01             Cat1     30         3000

c001               p02               Cat2     20          2000

But the result was

c001               p01             Cat1     10          1000

c001               p02             Cat2     20          2000

C001              p01             cat1      20           2000

am really confused so make it clear when does aggregation happen but i found another thing that if i have data like

c001               p01             Cat1     10          1000

c001               p02             Cat2     20          2000

C001              p01             cat1      20           2000

initially in the flat file and if am loading the above 3 records for the first time into cube then the records are getting aggregated and result appears as

c001               p01             Cat1     30         3000

c001               p02               Cat2     20          2000

am really not getting the concept please help me out

Thanks,

Madhu Nair.

[former_member182998]

Hello Madhusudan,

Asn Suggested by Ramesh, the data in the Infocube F table is shown or displayed request wise. This is why you get that behaviour . I think you aggregated the records as per the key fields. that is basically aggregation.. a concept that is used for optimizing the Query performance.

Please refer below link, which is on Aggregates., and refresh your concept on that

Performance Tuning for Queries with Aggregates:... | SCN

It has similar type of Example as you mention above I( Country Vs Sales)

Hope this Helps...!

Regards

YN

[Former Member]

Hi Both,

Please i think u are moving away from the topic what i really need is about Aggregation that happens in CUBE and not regarding Aggregates .

As in DSO data gets overwritten and like wise in Cube it gets aggregated i wanted information about this aggreation that occurs in CUBE rather than the aggregates CONCEPT.

thanks,

Madhu

[Former Member]

hi madhusundhan,

                              we have only concept called aggreates in infocube, there is nothing like aggregation happens infocube, when data loading. it only summerizes the data. There is lot difference between summerization and aggreagation.

Thanks,

Ramesh.

[Former Member]

Hi Ramesh,

yea i wanted the same to know about the summerization of data in CUBE when where and how it happens

Thanks,

Madhu

[Former Member]

hello madhusudhan,

1) if you load data into infocube the data will be stored in F fact table. Since F fact table is partitioned based on Request ID , the data is summerized automatically during data load .

2)  Next if the data is loaded again the data will not be summrized in the cube, But when u report on the cube, the data in the report is summerized  ( This is done by OLAP processor).

3) if you wanna summerize all the data , you need to compress the cube (compression transfers the data from F fact table to E fact table (on E fact Table you can manually partion using 0calmonth, 0fiscvar) ) and it deletes all the request's and summerizes the data and saves it E fact table.

4) If you report on cube after compression, the data will be summerized data due to compression (Here no olap process is used).

5) Hence Burden on OLAP processor is reduced using compression (In ordr to summerize the data)

Thanks,

Ramesh.

[Former Member]

Hi Ramesh,

Thank u so much for ur explaination.

Madhu

[Former Member]

hi madhisudhan,

                         it the above answers you find correct, Click which one you think is the correct answer, so that it can be helpfull to others .

thanks,

ramesh.