Hi,
To keep things simple, let me eliminate all extraneous details and
focus on the problem:

I have three measures:
Time: date_time
Point: point_id, name
Unit: unit_id, type -> type can be one of the following "SUM", "MAX",
"MIN"

The fact table has the following columns:
date_time
point_id,
unit_id,
value

The question I have is following:
Can I aggregate value in the fact table in such a way that
if unit.type is "SUM" then I sum, if unit.type is "MAX" then use MAX
when unit.type is "MIN" use MIN.

I appreciate any feedback

Koichiro

Hi
Create 3 measures: Min, Max and Sum.
Create dimension Type.
Create culculated measure which will show one of real masure base on
selected member of dimension Type.
Sasha

"Koichiro" <koichiro (AT) sbcglobal (DOT) net> wrote