Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

automatic generation of cube

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
suppose there are two types of tables A and B. there is one table of type A and B for every day of the month. that means for any given month we have A1....A30 and B1...B30. A and B are related using foreign keys. so A1 corresponds with B1 and so on...
there is a cube for each of A1 and B1. now i want to extend this cube to all the other As and Bs. that means A1..A30 in one single cube and B1..B30 in another, such that the relationship between the two is still maintained.
is there a way for automatic generation of 30 cubes of the same type and on tables of hte same design ??
or should i just link the tables somehow ? or maybe add an extra counting attribute ??
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top