Skip to Content
avatar image
Former Member

Split a character in query designer

Hello,

Can some help me split a characteristic, to take only the first 10 digit.

I have a char as Doc+company+year.

510000004345002014


I want to extract only the 10 digit.


Many thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 20, 2017 at 09:14 AM

    Hi,

    please do datamodelling on Datawarehouse level

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 20, 2017 at 04:59 PM

    It's unclear if this is the case but if you are using a compound characteristic where the first 10 characters are the key, you can change the display settings of that characteristic to be "Key (Not Compounded)".

    If not using a compound characteristic then Koen is correct in that you'll have to handle this in the model layer, presumably via a transformation that can extract those first ten digits into their own characteristic

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2017 at 01:36 PM

    Thanks both of you for the input but I don't have access to the Data warehouse. I have only access to Bex designer.

    so in that level( Bex designer) I can't change it right. the only thing I can do for now is change it to key figure based on the Replacement Path and than I can extract the 10 digit.

    Many thanks.

    Add comment
    10|10000 characters needed characters exceeded