MDX Question

Summary

MDX Question

Content

Hello,

Here is Sample MDX script and here we are using temp member as  [Measures].[Profit Percent] to calculate.

Is there any way I can use Member Name instead of "Temp Member" which exists in the Hierarchy? and calculate data in MDX directly for reporting? when I tried that I am getting an error and saying that member conflicting the member which exists in the outline.

WITH

MEMBER

  [Measures].[Profit Percent]

  AS 'Profit *100 /Sales', SOLVE_ORDER=20 

MEMBER

  [Year].[FirstFourMonths]

  AS 'Sum(Jan:Apr)',SOLVE_ORDER=10 

SELECT

  {[Profit], [Sales], [Profit Percent]}

ON COLUMNS,

  {[Jan], [Feb], [Mar], [Apr], [FirstFourMonths]}