Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
odin_dark
Starting Member
1 Post |
 Posted - 2006-06-27 : 10:36:34
|
| Hello, I’m creating a cube with Analysis services 2000 and SQLServer 2000 that has the following structure:The fact table has a primary key and some measures:o Fact_Tableo PKFact (the primary key)o Measure 1o Measure 2And I have some dimensions, but I’ll put here the one of interest, this dimension has a foreign key to the fact_table, this is because it is really a “detail” of the fact table, the interesting thing here is that this dimension not only has a foreign key to the fact_table, but also is a parent-child dimension:o Dimension_Tableo FKFact (the foreign key to the “PKFact” field of the fact table)o PKId (The id of the field for the parent-child relationship)o FKParentId (the foreign key to this same table, this is, the parent of the field)o TheLevel (the data…)So, if I create the cube without the Dimension_Table (of course, I have more dimensions), the cube shows the data correctly, but when I include this dimension, the data of the fact_table starts to be repeated once for each row in the dimension table (once for each row that has the relation PKFact – FKFact of course), Somebody knows how I can avoid this data being repeated? I’ve tried a lot of things but none works.. Please help!!Thanks in advance. Odin_Dark@yahoo.com.mx |
|
|
|
|
|
|
|
Data starts to repeat when add a parent-child dim