Hyperion Essbase (MOSC)

MOSC Banner

MDX Query Attribtue Dimension

edited Jul 31, 2013 1:52PM in Hyperion Essbase (MOSC) 1 commentAnswered
I am creating an MDX data export from an Essbase 11.1.2.2 BSO cube to replace a slow-running report script.  Using the Execute MDX in Smart View to test it.  For the rows, I need the first member to be from the cost center dimension.  The second cell will have the corresponding text from an attribute dimension.  I am having trouble getting the attribute text out.  Can someone help me with the syntax?  What I have so far:
WITH MEMBER [Period].[YTD_CLSExpMonth] AS 'SUM(PeriodsToDate([Period].Generations(1), [Period].[&ClsExpMonth]))'
SELECT
  { ([Actual], [JDE], [&ClsExpYr], [&ClsExpMonth]), 
([Actual], [Final], [&ClsExpYr], [&ClsExpMonth]),
([Actual], [Final], [&ClsExpYrMinus1], [&ClsExpMonth]),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center