dimension model for many indicators field

j at 07h58
15
May
2010
dimension model for many indicators field

I have 30+ fileds that has either 1 or 0 ( true or false)value in a fact table

Patid -- -- --- PTInd_1 Ptind_2 Ptind_3........ PTind_30 -- etc

1 0 1 1



I need to be able to create a dimension using thse attributes( patind1 ~ 30)..wha
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
Hi All, I would like to design the time in a multidimensional model. The classic calendar date dimension (day, week, month, year) should be applied here. Besides that, I have a fine grain: the minute. More specifically, let's suppose I have 10.000
Hi, I'm working on a project where dimensions have dates in them. An example is for a client where we have date of birth, joining date, date of death, etc. In fact i have about 6 different date columns. Now, I'm trying to find out what the best
Dear community, I would like to ask you for helping me with a star data model / reporting problem. The simplified data model is: FACT_SALES (DATE_ID, PRODUCT_ID, CUSTOMER_ID, PLANT_ID, SALES_AMOUNT) DIM_PRODUCT (PRODUCT_ID, PRODUCT_NR,
Sorry, this is a long explanation but I wanted to document the entire “case”. Thanks in advance for your advice. Background: Currently we are modeling a data mart for traffic accident data. The source system is a repository rather than a
Hi, I have a requirement to build canned reports in WEBI XI R3. The requirements are such that most of the reports are on the dimension tables and needs dimension tables to be joined. From a starschema prospective we cannot join dimension tables. My
Forums from same category
See also
more_less
Informations

7 Replies For the topic :
"dimension model for many indicators field"

This topic has been viewed 2219 times.

Last message :
15/05/2010 at 07h58 by "j"