How to populate first 2Chars into new field in report

[Former Member]

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.

[Former Member · Accepted solution]

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];

[Former Member]

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

[Pravender]

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

[Former Member]

Hi Pravender,

Thanks for ur reply .Is it the only way or any other way to do?

Please provide sample code if possible.

Thanks

Srini.

[Pravender]

You can use a macro in Bex analyzer.

Or you can handle it in modeling part.