Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    6

    Unanswered: Cocatinate 2 columns

    Hi,

    Please help.. I want a level in the dimension such that the concatenation of two columns in the dimension. Can I do that while creating the dimension or I have to do in the database level.

    please answer urgent help..

    Raj

  2. #2
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    best way to do it is at the relational level so it is ready for processing.
    however, you can concatenate strings in MDX

    this is an example of measure concatenation

    LINK
    Last edited by Ruprect; 12-13-04 at 16:40.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •