We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

MDX Question

Received Response
10
Views
2
Comments
edited Aug 2, 2018 2:36AM in Essbase 2 comments

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]}

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!