Avg function in awm

M.Fazlollahi

hello

I'm using database 12.2.0.2 and the latest release of awm.

I've wanted to make a cube with 2 dimension with avg summarize.

but when I maintain the mentioned cube avg change to sum!!!

What's happened?

Ken Chin OLAP Option-Oracle

Hi M.Fazlollahi,

I have a couple questions about the aggregation which will hopefully help narrow down the issue.

1) Is your cube using compressed composites (which is the default)?

2) Are you varying aggregation by dimension?

3) If you are not using compressed composites, are you varying aggregation by measure?

4) If you are setting the cube aggregation method in AWM, are you able to re-enter AWM and see your change?

thanks,

Ken

Rajneesh S-Oracle

Hi M.Fazlollahi,

If you use an aggregation operator other than Sum, the order in which the dimensions are aggregated can make a difference in the results. It is important that aggregations occur in the order specified. When aggregating across multiple dimensions, you must keep in mind that numbers may not appear to add up the way you look at two-dimensional spreadsheets. This is especially true when aggregation types are different for each dimension. Be aware of this when you start reviewing the results. It may be necessary to change the order of aggregation to achieve the desired results.

https://oracle-patches.com/en/data-science/3234-building-an-oracle-olap-analytic-workspace

M.Fazlollahi

Thanks for reply

1-No

2- I could not understand what you mean??

3-No

4-No!!!!

Ken Chin OLAP Option-Oracle

Hi M. Fazlollahi,

Would you be able to please send a screenshot of the AWM Cube tab settings (i.e. General, Aggregation, Partitioning...)?

thanks,

Ken