-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Will Spooner wrote: > On Tue, 27 Feb 2007, Arek Kasprzyk wrote: > For the dimension named 'foo', the main table has the following > attributes; > foo_count - the number of corresponding records in foo__dm > foo_dmlist - the list of names of the corresponding foos, e.g. > 'foo1 | foo2 | foo3 > foo_dminfo - the list of summaries of the corresponding foos, e.g. > '[foo1] first foo | [foo2] another foo | [foo3] more foo' > > In addition, the dimension table has the the following attributes; > foo - The name of the foo record, e.g. 'foo1' > info - The summary of the foo record, e.g. '[foo1] first foo' MartBuilder will be able to do the above from the 0.6 release (the capability is already present in the head branch of CVS), but it has to put the dmlist and dminfo columns into a separate dimension each. So you'd end up with the main table, the dimension foo, and two further dimensions foo_dmlist and foo_dminfo. The method to do this is a combination of the new Replicate Dimension feature and the existing Concat Relation feature. Otherwise, an identical result. cheers, Richard -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFF5EeE4C5LeMEKA/QRAq0YAJ4kErlOUWYJPVhIU5AeRkCuafLhvwCcDyx7 6Q+r8YrqKYIkoaVc/x9RYRs= =VqyB -----END PGP SIGNATURE-----
