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 |
|
poobalanm
Starting Member
1 Post |
 Posted - 2004-09-30 : 09:10:33
|
| Hi all,I'm having a major design problem for a data mart. the fact table contains averaged values (e and p) read and processed from the original db. is it possible to not see sum of the averages when i drill-up or drill-down the data? example:unit A1 : 4.5 and 3.5unit A2: 3 and 5unit A3 4 and 2Division A should be (A1+A2+A3/3 = 11.5/3 = 3.8) etc.the dimension is "BizUnit" with Division at level one and unit at level 2.at the moment i getting answer Division A : 11.5 and 10.5 which is meaning less. as i go up the levels, the values increases because it is automatically summed up. Also, each unit consists of individual ppl that contribute to the actual results. Thus the values for each unit itself is an average of the individual's results. Hope i'm clear in my question. really hope someone can help with this...poobalan |
|
|
jojo_jacob
Starting Member
24 Posts |
Posted - 2004-10-01 : 00:29:29
|
| You may try the following Calculated Measure for each Read and Processed:sum([BizUnit].currentmember.children,[Measure].[r])/count(sum([BizUnit].currentmember.children)And, if u don't want the original measures, just hide them using the dimension properties.Let me know if this worked.Jojo |
 |
|
|
|
|
|
How to average the data in fact table