Skip to Content
avatar image
Former Member

How to populate first 2Chars into new field in report

Hi All,

I have report requirement like to populate the first 2chars of a characteristic in the report.

Eg: I have ASM code with characteristic values A1200,B2300........now i need to populate only first 2chars like A1,B2...in the new object (name it as Region.)

So finally my report will be

ASM Region Kf1

A1200 A1 100

B2300 B2 200

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 08, 2010 at 12:33 PM

    Hi.

    The clearest way to do it is to use formula at loading time.

    I mean you should use formula in transformations - map ASM to Region and use formula LEFT(2 , ASM).

    So when you load data to cube you already wil have populated Region with 2 chars from ASM.

    Regards.

    [Uryukin Andrey|http://il.linkedin.com/in/andreyuryukin]

    SAP-BI Consultant, [Advantech|http://advantech.co.il/en/index.asp]

    [My Blog|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/u/252016769] [original link is broken] [original link is broken];

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 08, 2010 at 08:08 AM

    You can handle this in a user exit code using a formula variable.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 09, 2010 at 05:47 AM

    As the requirement is changed and i need to add few more fields so thought of changing the design.

    Add comment
    10|10000 characters needed characters exceeded