November 1, 2006 at 10:43 pm
Hi,
I am using Analysis Services 2000. I have an OLAP cube and the data displayed looks something like this.
Cost Price Selling Price Profit
Product Sub Product
All Products
A A Total 318 340 22
A1 100 113 13
A2 122 127 5
A3 96 100 4
B B Total 370 388 18
B1 100 113 13
B2 148 150 2
B3 122 125 3
C C Total 241 237 -4
C1 97 97 0
C2 144 140 -4
I want the display to b like this (below). I want the average of the prices of all the products displayed below
Cost Price Selling Price Profit
Product Sub Product
All Products
A A Total 318 340 22
A1 100 113 13
A2 122 127 5
A3 96 100 4
B B Total 370 388 18
B1 100 113 13
B2 148 150 2
B3 122 125 3
C C Total 241 237 -4
C1 97 97 0
C2 144 140 -4
116.125 120.625 4.5
How can I achieve this in Analysis Services 2000?
November 6, 2006 at 8:00 am
This was removed by the editor as SPAM
November 6, 2006 at 10:29 am
You can create calculated measures to do the averages. Eg. (from Foodmart 2000)
Sales Average = [Measures].[Store Sales]/[Measures].[Sales Count]
Otherwise, some OLAP browser come equipped with aggregate functions to choose from.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply