Cross Join Issue

• Olalekan Adewale

  Right there with Babe

  Points: 767

  More actions

  June 28, 2017 at 11:09 am

  #150586

  Hi All
  Kindly assist with this MDX code.
  Code below
  
CrossJoin (
             filter ([Product].[Main Caption].Children,[Measures].[Contract Rate] <=1 ),
            [Product].[Currency].&[FCY]
        ),
        CrossJoin (
             filter ([Product].[Main Caption].Children,[Measures].[Contract Rate] <=5 ),
            [Product].[Currency].&[LCY]

  and the following output form PPS desinger
  
  The Currency lines are distorting the table above. How can I rewrite the code and still get same figures without second column appearing.

  Many thanks.

• Alan Burstein

  SSC Guru

  Points: 61141

  More actions

  June 28, 2017 at 1:26 pm

  #1948622

  I'm not an MDX guru but, what you posted is not the complete MDX code. The complete statement would include (at least) a SELECT and an ON statement. The "Average Balance" column is being defined ON columns (AKA ON 0). Without the complete MDX query it's impossible to say how we'd remove that column.

  "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

  -- Itzik Ben-Gan 2001