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
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.