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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-25 : 09:20:52
|
| Mike writes "I am writing a VB application over SQL Server 2000 which uses DSO to build dimensions and cubes on an OLAP database. A number of dimensions are parent-child on the same base table, but with different filter conditions. All dimensions are joined to the fact table over a many-to-many join table.My problem is that when I build a cube which uses more than one parent-child dimension, I need to alias the dimension table so Analysis Services can build the necessary SQL statements. I have tried aliasing using the <Cube>.FromClause and <Cube>.JoinClause properties but whilst I can set them the resulting cube is invalid. However, I can do this successfully using the Cube Editor. When I set the alias, the <Dimension>.SourceTableAlias is set accordingly. in DSO, the <Dimension>.SourceTableAlias is read only, and nothing I do seems to let me set it.Please Help.RegardsMike Arnold" |
|
|
|
|
|
Dimension Table aliasing using DSO