Skip to Content

Show leading zeros in BEX

HI

I have a characteristic type CHAR with ALPHA conversion that shows values in cubes, DSOs, composites etc as 000123, however when I create a query based on them this char is displayed as 123.

Can you please suggest what option in BEX must be set to allow display leading zeros in queries?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 27, 2017 at 10:17 AM
    Add comment
    10|10000 characters needed characters exceeded

    • Hello Tammy

      Thanks for suggestion, but the possible solution those links give - "remove ALPHA conversion" is not acceptable in my situation. I must have those values in all infoproviders as 000123 and in BEX as 000123 as well.

  • Nov 02, 2017 at 02:23 PM

    Hi,

    another workaround is to fill one of the short/medium/long text with the 000123 values you want.

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 01, 2017 at 02:45 AM

    Hi,

    You may also use the function of EXCEL if you are using analyzer. Say right click the column then properties, choose general and enter 000000 if your object is 6 characters.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded