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 |
|
SQLboom
Yak Posting Veteran
63 Posts |
 Posted - 2004-04-17 : 09:13:05
|
| Suppose that i have to create a Analysis Services report cube based on the output of following queryselect local.colA, local.colB, foreign.colX, foreign.function_name(par1, par2)from local left outer join foreign on local.C = foreign.YNow, here the tables local and foreign belong to different databases. Can some help with the folowing queriesa. how to go about creating the cube(s)b how to handle the outer joins through cubec. how to call a database function as the outputd how to handle a tables which are in different databasese. Of course, i could have added so many other features like isnull, replace, between, in statement etc. How do we handle these.Please help!. ..I am totally lost with this. .. |
|
|
|
|
|
creating cube(s)