webi report short names BOXIR 3.1

[Former Member]

Hello all,

I have a webi report with column  "Product Description". This column has around 1000 rows and the data is in the format: CarSale.prod01

AccSale.prod02; CarWash.prod03; CarWash. Convert PROD05 and so on.

I want that this column displays short form of the names. Like for CarSale.prod01 it displays CS.PO01 and same way AS.PO02, CW.PO03, CW Convert PO05 and so on. How can I achieve this in the report or universe? I have around 1000 rows with different names.

Thanks,

N

[former_member182342 · Accepted solution]

Hi Nisha,

Check below formula

=Substr([Prodcut Description];1;1)+Substr([Prodcut Description];4;1)+".PD"+Right([Prodcut Description];2)

Regards,

Anish

[arijit_das]

I would suggest you to maintain the short text in master data.

[Former Member]

Hi,

If The Patern in your example is same .

=Substr([Product_Description];1;1)+Substr([Product_Description];4;1)+"."+Substr([Product_Description];10;7) + Replace(Right([Product_Description];6);"Prod";"PO")

[Former Member]

you can apply alerters on "Product Description".

or you can apply substring to capture common string of your "Product Description" and apply alerters