one or three cubes

View previous topic View next topic Go down

one or three cubes

Post  dansawyer on Fri Jul 09, 2010 9:34 pm

We are creating a business management 'summary' data warehouse to support customers and the business. The example of the types of information include: 1. consumption summaries, 2. purchase order summaries, and 3. statement summaries including one time charges.

It would be convenient to combine these multiple into one cube, however it does not seen feasible to do this. The practical alternative seems to be multiple cubes.

Is there a structure that supports one cube or are multiple cubes required?

Thank you,
Dan

dansawyer

Posts : 5
Join date : 2010-05-01

View user profile

Back to top Go down

Re: one or three cubes

Post  ngalemmo on Mon Jul 12, 2010 11:23 am

To get things into one cube, all the measures must conform to the same set of dimensions. If that is not possible, or the result would be too summarized to be useful, then you have to go with separate cubes.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

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