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

aganatra at 20h04
26
May
2009
Flexiblity To Add Attributes To A Dimension And Not Process The Whole Cube/s

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..
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
My company is currently building a data warehouse and I have a design issue that I am not sure how to address. In general, our business is selling an asset, such as the stock of a corporation, with a certain number of shares and a value. The value of th
I have a business requirement that is somewhat stretching my modelling skills. The application is a highly sensitive one so I’ll describe the problem using a Sales Datamart template. There are 7 plus fact tables, 1 is updated monthly, the rest
Hi Just looking for some confirmation that a dimension with partial attributes might still be considered conformed. For eample A dimension of batch ProdBatch PK BatchID Batch Name Product ID Product Name ... at an invoice Fact table
Hi everyone, I am implementing a cube and I run into a problem with slowly changing dimensions(SCD type 2). I guess it might be resolved somehow with MDX or somehow else, maybe you guys can help me to resolve it. The problem: I have SCD, say Policy wit
suppose you have - a discount code attribute - a status attribute which depend on the combination of the dimension customer & the dimension product. You want to be able to relate these attributes to a fact table invoice details. What are the
Forums from same category
See also
more_less
Informations

0 Replies For the topic :
"Flexiblity To Add Attributes To A Dimension And Not Process The Whole Cube/s"

This topic has been viewed 919 times.

Last message :
26/05/2009 at 20h04 by "aganatra"