Hi,

I am a newbie in OLAP world.

I am having problem in counting weighted average.

I have a fact table consist of Volume,Tax and etc.

The fact table is actually Sales Volume of all company in country.

I have also Brand, Company as dimension table.



What I did is to create Relative Contribution to Total Industry by
creating following calculated measure:



ContribBrandToTotal:

[Measures].[Volume] / ([Measures].[Volume],[Brand].[All Brand])



ContribCompanyToTotal:

[Measures].[Volume] / ([Measures].[Volume],[Company].[All Company])



ContribBrandToCompany:

[ContribBrandToTotal]/[ContribCompanyToTotal]



To Calculate Weighted Average of Brand Tax Rate to Company,

I simply create:

[Measures].[Tax]*[ContribBrandToCompany]



I got right leave values. I expect the leaves values to be sum up at
company level to get The Weighted Average.

But I found It did not sum up.

Anyone can help me on this?

Or any other way to calculate Weighted Average?



Thx


--
Posted via http://dbforums.com

Typically, a weighted average requires an additional measure (with 'sum'
aggregation function), which can efficiently aggregate the weighted leaf
values. Otherwise the leaf values have to be aggregated on the fly. Can
you provide some simple sample data that illustrates how you want the
weighted average to work - it's not obvious?

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!