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

View previous topic View next topic Go down

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

Post  aganatra on 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

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