Re: Don't aggregate a measure

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Jéjé" <willgart_A_@xxxxxxxxxxxxxx>
Date: Fri, 11 Aug 2006 10:18:27 -0400

does Measure1 is a calculated measure?

"Immy" <therealasianbabe@xxxxxxxxxxx> wrote in message
news:%23YCtvPUvGHA.1772@xxxxxxxxxxxxxxxxxxxxxxx

Hi all,

Does anyone know how I can achieve this using AS2000?

Example

Measure1 M2 M3 M4 M5
1000 100 10 50 60
950 50 10 50 60
500 100 10 50 80
600 100 50 50 60
700 100 10 50 0
500 200 10 50 60

Imagine I have a time dimension in play... how can i have Measure1 NOT
aggregate up but the other measures DO?

Current result when aggregated up to top level
Measure1 = 4250

Desired result when aggregated up to top level
Measure1 = either AVG or SUM/RowCount - But when I drilldown, I am able to
see the actual figures by day.

Hope this is clear?

Regards
Immy

Follow-Ups:
- Re: Don't aggregate a measure
  - From: Immy

References:
- Don't aggregate a measure
  - From: Immy

Prev by Date: Re: Needed Advice - Olap client tool
Next by Date: Re: Don't aggregate a measure
Previous by thread: Don't aggregate a measure
Next by thread: Re: Don't aggregate a measure
Index(es):
- Date
- Thread

Relevant Pages

Re: Dont aggregate a measure
... Imagine I have a time dimension in play... ... aggregate up but the other measures DO? ...
(microsoft.public.sqlserver.olap)
Dont aggregate a measure
... Imagine I have a time dimension in play... ... how can i have Measure1 NOT ... aggregate up but the other measures DO? ...
(microsoft.public.sqlserver.olap)