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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

one table, more dimension 1

Status
Not open for further replies.

slimanov

Programmer
Mar 10, 2006
4
DZ
a table can be used by more dimension in one cube ..????
 
yes.

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright
 
If I understand your question is Can a table be used to populate more than One Dimension. As john said the answer is yes however I suggest that you assign Table aliases in the Dimensions that reference that table. I have seen where in the cube model a single reference has messed up the cube or performance of the build based upon the multiple joins back to the fact table.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top