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

Flexiblity To Add Attributes To A Dimension And Not Process The Whole Cube/s

Go down

Flexiblity To Add Attributes To A Dimension And Not Process The Whole Cube/s Empty Flexiblity To Add Attributes To A Dimension And Not Process The Whole Cube/s

Post  aganatra Tue May 26, 2009 2:04 pm

Hello,

We are in the process of designing a DW for Games and have run into a business problem : Business users want to add attributes to a dimension and decide its level in the hierarchy on the fly. The new attributes should be availabe in reports (including drill downs) immediately.

Example: A game has attributes like type (video/non-video), manufacturer, year of purchase etc... 6 weeks/months from today management might want to add attributes like time taken to play a game and number of player posistions..

How do we model our game dimension such that we dont end up reprocessing the entire cube whenever these changes occur.

Thanks in advance.

Amit

aganatra

Posts : 1
Join date : 2009-05-26

Back to top Go down

Back to top

- Similar topics

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