working on access

[Satya]

hi this is satya new to this group

i have to create cube from ms access.is it possible each individual table could be trated as a separate data base.

i have transaction colume in one table and account code and account deccrption in one more table

is it possible bring thess three in one form like transaction as dimension and account code and account descrption as level b'coz in that two tables there is no common relation between them.

need reply ASAP.

REGARDS
SATYA

[GoWestGw]

You can load separate tables directly from MS-Access, but you must have a link between the two.

Say you have a sales table and a salesperson table.  To link the two within Transformer the sales table needs a foreign(surrogate) key to the salesperson table.

Sales Table
Date
SalesRepID
SalesValue


SalesPerson Table
SalesRepID
SalesRepName
DivisionName
RegionName

The link between the two would be SalesRepID and Transformer would be OK.