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 |
|
yeapjudy
Starting Member
1 Post |
 Posted - 2004-06-23 : 03:58:09
|
I create a new cube with 6 Dimension and 1 virtual Dimension, because of the one of the Dimension, my get the multiple records, example in Dimension A, the data is likedomain_code domain_name Weight geo01 AA 1 UA01 AA 1 UB01 AA 1 UCAfter i link the domain_code with Fact table, the multiple record will list out, but when i try to link with domain_code and geo from Fact table to Dimension, it take me more than one hours to process and also cannot finished, so i stop it, did anybody know the reason of this problem and the solution? Yeap Judy |
|
|
Devarajan
Starting Member
13 Posts |
Posted - 2004-07-02 : 04:53:57
|
Hai i know ur problem plz use surrogate keys in dimension and the fact G.DevarajanS/o K.Gopalakrishnan |
 |
|
|
|
|
|
Multiple Record In Cube