I need some opinion, first of all, i have a big sales data (daily by store by product),
which makes me really need to use ASO for fast aggregation.
But in some case there's account that will be wrong if i get the aggregated result, since if i use BSO i can load the value to the parent level or do calculation. I've heard about partitioning between BSO and ASO but i haven't get a clear idea about how this apply to my issue, did anybody ever experience this issue and how you solve this?
You can refer to the standardized guide for creating partitioned ASO.
Also in the following link, you can find a similar example.
http://www.oracle.com/webfolder/technet ... e-1112.htm