title: Handling MDX OPENQUERY, The identifier that starts with is too long. Maximum length is 128
body: <p>I have a problem using openquery. i want to select the column with it's name but the name is too long because there are much levels   </p>
  
  <pre><code>SELECT 
       A."[Dimension].[NAMEOFLEVEL1].[NAMEOFLEVEL2].[NAMEOFLEVEL3].[NAMEOFLEVEL4].[NAMEOFLEVEL5].[NAMEOFLEVEL6]" AS Acc2 
  FROM OPENQUERY(CUBEX,
          'SELECT 
              ({
                  [Dimension].[NAMEOFLEVEL1].[NAMEOFLEVEL2].[NAMEOFLEVEL3].[NAMEOFLEVEL4].[NAMEOFLEVEL5].[NAMEOFLEVEL6]
              }) DIMENSION PROPERTIES MEMBER_KEY 
              ON COLUMNS, 
              NON EMPTY (
                  [TIME].[MONTH]
              ) DIMENSION PROPERTIES MEMBER_KEY 
              ON ROWS
          FROM [MyTable] 
      ') A
  </code></pre>
  
  <p>the error is as follow :</p>
  
  <p>The identifier that starts with '[Dimension].[NAMEOFLEVEL1].[NAMEOFLEVEL2].[NAMEOFLEVEL3].[NAMEOFLEVEL4].[NAMEOFLEVEL5].[NAMEOFLEVEL6]' is too long. Maximum length is 128.</p>