Hi All,

I have to measures: [measures].[cost] and [measures].[budget].
I would like to add then within an MDX statement as such:

SELECT
([measures].[cost] + [measures].[budget]) ON COLUMNS,
{[products].[products].members} ON ROWS
FROM [sales]

How can I get the addition of two measures within MDX statement without
adding a calculated member at the Analysis Services cube level.

Thank you
JAMES

--
Message posted via http://www.sqlmonster.com

Create a calculated member and seletect it on the columns. YOu can either
create the calc member in the interfact, or in a WITH statement in your MDX.

WITH MEMBER [measures].[SalesAndCost] AS '[measures].[cost] +
[measures].[budget]'
SELECT
([measures].[SalesAndCost]) ON COLUMNS,
{[products].[products].members} ON ROWS
FROM [sales]

"James Woo via SQLMonster.com" wrote: