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..
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 Ill 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
LEGO Island Discussion, modding, news and more!
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
HmongThoobNtiajTeb. com/
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Search
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"






