Hyperion Essbase (MOSC)

MOSC Banner

MDX Query

edited May 21, 2012 4:05PM in Hyperion Essbase (MOSC) 1 commentAnswered
HI All,

I am trying to write a query to generate top 10 cusotmers by channel on rows and current year and prior year sales on columns along with actual scenario. i had written a query where i am able to get the top 10 customers by channel on Rows but not able to get the multiple years on columns.can any one help... the code i written is

WITH SET [Top10] AS 'Generate ({[Channel].Levels(3).Members},
Crossjoin({[Channel].Currentmember},TopCount({[Customer].levels(0).Members},10,[Account].[AC_S40001])))'
select {([Account].[AC_S40001],[Scenario].[SC_Actual])}  ---here i need current year and prior year also .. assume current year is FY12 and Prior Year is FY11

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