>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of Mark Johnson
>Sent: Monday, 19 April 2004 2:07 PM
>To: U2 Users Discussion List
>Subject: Re: GUI from Mv code Re: Crystal Reports
>Thanks Dawn! You have enlightened me in quite a few ways.
>BTW, the most extreme example of a multi-part primary key that I've ever
>seen was for a security monitoring client. It looked like this:
This key then corresponds to 7 dimensions, and the overall approach is classified as
The "fun" starts with ROLAP when you need a query that was, say,
DATE-TIME-ZONE-SIGNAL-INCIDENTNUMBER-ACCOUNT-RECEIVER, as these would correspond to
different key structures.
If my math memory serves me correctly, for you to be able to keep EVERY possible
combination you need to have 2^7 = 128 'summary' records for each source transaction.
Increase your dimensions to 14, and you end up with 16,384 - you had better have lots
of storage & time on your hands. Short of reducing the number of dimensions to a
subset of pre-defined views, one solution to this problem is MOLAP
(http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci882493,00.html) .... but
I fear I'm getting WAY to far OT here
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
u2-users mailing list