Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Best Practice: two Cube share one Dimension?

2 posters

Go down

Best Practice: two Cube share one Dimension? Empty Best Practice: two Cube share one Dimension?

Post  kepb 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
kepb
kepb

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

Back to top Go down

Best Practice: two Cube share one Dimension? Empty Re: Best Practice: two Cube share one Dimension?

Post  hang 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

Back to top Go down

Back to top

- Similar topics

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