Truncate Characteristic data

[Former Member]

Hello Experts,

I have Social Security Number in a infoobject. On BEX report, I would like to display only the last 4 digits of SSN. How do I do that please?

Regards,

-Sonny

[former_member189638]

Try using the replacement path variable. This might help you

Check the following link

http://help.sap.com/saphelp_nw70/helpdata/en/af/809528939d5b4fbff7e16a5bdc0d85/content.htm

[Former Member]

Hi,

In transfer rules you can do coding to truncate and display only last 4 digits of social security.

you can use offsets... suppose for 9 length filed id FIELD, YOU CAN WRITE LIKE FIELD+0(4).

out of 9 charecters, which charecters you need?

ex: field = 000000000 if you need last 4 then field+0(4).

If you dont mention any offset, then it will only pick the first 4 char's by default (truncating the length).

Hope it helps.

Regards,

Mona

[Former Member]

I am very surprised that BI is so inflexible and rigid being a reporting tool. Thanks very much for all your answers.

-Sonny

[Former Member]

Hi,

the alternative would be to add a navigational attribute to your SSN IObj.

Load this IObj into itself and fill this attribute was suggested ATTR = SSNID+x(4) (x = LEN(SSNID)-4).

Activate this Nav in your Cube and you'll be able to report on it.

Another alternative is to implement a virtual char; a bit more complex and less performant but also possible...

hope this helps...

Olivier.

[Former Member]

Hi Sonny,

this canot be done in the report designer.

You will have to add an extra field to the cube and use a routine to truncate.

Udo