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 |
|
andrea.temporin
Starting Member
1 Post |
 Posted - 2009-02-09 : 11:15:19
|
| Hello,I have to migrate a SQL 2000 Olap Database in SQL 2005 platform but I found this problem:I've got Dimension "D_A" based on table "T_A" which is referenced to the fact table "F_T" through the table "T_R" (no dimension is based on T_R table): you can have n records of T_A for each value of key in T_R. This particular schema is supported in SQL 2000 AS and you can get it too in SQL 2005 only if you use the migration tool. If you try to do it manually or you try to modify the cube created by the migration tool you won't find your field any more in the "measure group columns" combo. It seems to be supported by XMLA syntax but not supported by the "SQL Server Business Intelligence Development Studio" IDE.I've tried to to get this using intermediate dimensions and referenced dimension attribute, but if you query the cube you've got the right value using the intermediate dimension and always ground total for every member of referenced dimension.Any idea? It won't be nice to have always to modify the cube using XMLA scripting...ThanksAndrea |
|
|
|
|
|
Referenced relationship type in dimension usage