Hi Again,
I've managed to get my schema and build the relationships by hand for
some tables. Then I clicked on "build dataset" and chose all tables I
wanted and built it.
The datasets relationships seems to be all right but the primary key for
each table is bogus:
DESCRIPTION_ID_1054_KEY_KEY_KEY_KEY
COMMENT_BLOCK_ID_105_KEY_KEY_KEY_KEY
etc...
I've closed the builder, edited the XML by hand removing the repetitive
_KEY occurrences and rerun martbuilder but the names got back to bogus
again.
Nevertheless, I've clicked on the "build mart" button and the program
warned me that there wasn't any field on that table with "_KEY" at the
end for each one of the relationships and didn't build the mart.
Besides, every time I change something on the dataset it appends another
"_KEY" at the end...
thanks,
--renato
--
Reclaim your digital rights, eliminate DRM, learn more at
http://www.defectivebydesign.org/what_is_drm