Post reply

MDX query

  • May 24, 2006 at 9:57 am

    #61239

    Hi,

    I am using MDX query in my report.

    I want to concatenate two fields belonging to the same dimension table like empID and empName like

    empID - empName.

    I tried using "+" operator,but didnt work.

    Kindly help with examples.

     

    Thanks

    Arobind.B

  • May 24, 2006 at 11:10 pm

    #639958

    Try

    empID & empName

  • May 25, 2006 at 12:48 pm

    #640147

    It didnt work.

     

    Kindly help

  • May 25, 2006 at 10:17 pm

    #640222

    Is your empID an int datatype?

    Try

    SELECT CAST (empID AS varchar(20)) + empName

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

  • May 28, 2006 at 10:35 am

    #640507

    Mine is an MDX not SQL.

    The integer data type didnt had any influence

  • May 30, 2006 at 5:51 pm

    #640815

    Sorry, I was speaking beyond my knowledge level. *grin*

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply