There is some my publications about SART AML System, where is more
detailed described all this things (and more) that I wrote below.
http://www.analyticsql.org/documentation.html
Regards,
Blazej Oleszkiewicz
2008/9/4 Blazej <bl.oleszkiewicz@gmail.com>:
> Hi Artacus
>
> 2008/9/4 Artacus <artacus@comcast.net>:
>> Oh, as I was writing a CUBE query today and realized that I forgot to
>> mention this. And unlike most gripes, like MERGE INTO or CTE's which are
>> really convenience things, this is key piece of functionality that you just
>> can't reproduce in Postgres.
>>
>
> It is not true. First look at this:
> http://www.analyticsql.org/
>
> In atachment is two snapshots from production system (Analytic SQL
> Server based on PostgreSQL 8.3):
>
> Picture: non_uniform_dimension.JPG
>
> Heterogeneous data warehouse dimensions where each class of dimension:
> Chart of Account (PK), Synthetic Account (KS), Analytical Account (KA)
> may have a heterogeneous structure of the hierarchy (~60 000 items in
> hierarchy, max depth 9).
>
> For example, on picture marked heterogeneity of the hierarchy:
> -- Green: [PK, KS "operations involving cash and interbank
> operations," KS "Kasa," KS "Cash / banknotes and coins /" KA "Cash in
> hand GBP"]
> -- Red: [PK, KS "operations involving cash and interbank operations,"
> KS "Kasa," KS "bankers' cheques," KS "foreign bankers' cheques," KS
> "bankers' cheques, foreign currency," KA "bankers' cheques in USD "]
>
> Hence, we can see that both hierarchical structure:
> -- [PK, KS, KS, KS, KA] for a KA "Cash in hand GBP (ID: 339 in column KNT_ID);
> -- [PK, KS, KS, KS, KS, KS, KA] for a KA "foreign bankers' cheques in
> U.S. dollars" (ID: 363 in column KNT_ID)
>
> are different from each other in terms of the structure of the hierarchy.
>
> Picture:olap_raport_non_uniform_dimension.JPG - example of OLAP raport
> based on Chart of Account.
>
> so it is much more then "OLAP" ORACLE extensions like CUBE etc.
>
> Regards,
> Blazej Oleszkiewicz
>