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

one or three cubes

2 posters

Go down

one or three cubes Empty one or three cubes

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

Back to top Go down

one or three cubes Empty Re: one or three cubes

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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