3 Replies Latest reply: Oct 15, 2013 7:02 AM by Goran Korsgren RSS

    Rename column names that has square brackets in name

    Goran Korsgren



      I have a select (MDX)  that returns column names like [Period].[Month].[MEMBER_CAPTION].


      I would like to simplify those kind of names


      Load [Period].[Month].[MEMBER_CAPTION] As Month

      does not work


      Load [[Period].[Month].[MEMBER_CAPTION]] As Month

      does not work.


      Is there a way to rename column names containing square brackets?