Hi,

If from fact table I want to create 3 measures
like
Sum(Data) where id = 1
Sum(Data) where id = 2
Sum(Data) where id = 3

Can I do it in one fact table or
I need to create 3 different view for 3 different where condition

--
Thanks

Am

try anything like:

select ...
sum(case when id= 1 then Data else null end ) as Measure1,
sum(case when id= 2 then Data else null end ) as Measure2,
sum(case when id= 3 then Data else null end ) as Measure3
from table

or
select ...
case when id= 1 then Data else null end as Measure1,
case when id= 2 then Data else null end as Measure2,
case when id= 3 then Data else null end as Measure3
from table
(no group by and no sum)

1 pass 1 view and 3 measures

does this helps you?

"AM" <anonymous (AT) developersdex (DOT) com> wrote