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 - 2001-05-18 : 08:36:31
|
giora writes "(SQL server 2000, Windows 2000)
I have the following case: (I'm not sure how can I do it, after I read the documentation)
my simplified FACT table contains the following fields:
source_acount_id
dest_acount_id
money
"money" represents the amount of money delivered from one account to another.
If I use the source_account as a dimension - I can see the sum of money that went from source_account X. If I use the dest_account as a dimension - I can see the sum of money went to the dest_account X.
Another kind of data that I don't know how to extract from the cube is: "money that went to or from account X" = "money that went to account X + money that went from account X"
How can I use my fact table to do it? (I tried to do is using virtual dimensions but did not succeed)
It harder than usual - Here I try to combine two MDX queries into one.
Thanks in advance." |
|
|
|
|
|
OLAP: making a MDX-based dimension from more than one query