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

      Hi

       

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

       

      I would like to simplify those kind of names

      but

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

      does not work

      and

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

      does not work.

       

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