Hi

In Analyis Manager I want to set up a calculated member that sums the hours
for 2 activities

[Aktivity].[Main].&[11].&[11012300].&[11012301]
and
[Aktivity].[Main].&[11].&[11012300].&[11012302]

I can figure out to do this with one activity:

([Aktivity].[Main].&[11].&[11012300].&[11012301],[Measures].[hours])

but how to do this for the sum of the 2 activities?

-thanks

You can sum over a set composed of the 2 activities:

[Aktivity].[Main].&[11].&[11012300].&[11012302]},
[Measures].[hours])

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deepak

Thanks,

-Henrik.

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> skrev i en meddelelse
news:ezql7E47FHA.3876 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

Hi Deepak

Thanks,

-Henrik.

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> skrev i en meddelelse
news:ezql7E47FHA.3876 (AT) TK2MSFTNGP09 (DOT) phx.gbl...