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@xxxxxxxxx>: > Hi Artacus > > 2008/9/4 Artacus <artacus@xxxxxxxxxxx>: >> 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 > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
