Best Practice: two Cube share one Dimension?

View previous topic View next topic Go down

Best Practice: two Cube share one Dimension?

Post  kepb on Thu Jun 09, 2011 3:46 pm

Hi everyone

im doubt in this: i got two dimensional model one for sales and other for bills so each model has the document dimension table.
so i use sql server for each model i get one cube . So which better create one dimension document and share it in the two cubes (like the model)
or create one dimension documentesells to one and documentsbills to the other

thanks
avatar
kepb

Posts : 8
Join date : 2011-05-05
Age : 32
Location : PERU

View user profile

Back to top Go down

Re: Best Practice: two Cube share one Dimension?

Post  hang on Sat Jun 11, 2011 8:04 pm

If they share the same set of dimension attributes and attribute values mostly overlap, then consolidate them into one, otherwise you can't.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum