How to Filter Product Codes Using Scripting in SAP Analytics Cloud (SAC)?

[#1]

Hi Everyone,

I have product codes as dimensions in SAP Analytics Cloud (SAC). I want to filter these codes to show only those where the 13th digit is “C” using scripting.

Can anyone help me with how to achieve this in SAC?

Thanks in advance!

[N1kh1l]

@RajuRam 

You have not mentioned where you want to show these filtered product codes. If you want to display them in stories, you could create a calculated dimension and use that to filter the list. If this filtering requirement is something which you will do quite often, its advisable you add an attribute to your product dimension and flag it so that you have a universal filter for all stories and calculation.

IF(SUBSTRING([d/"MODEL":PRODUCT].[p/ID],13 ,1)="C" ,"Contains C" ,"NA" )

Also you have to ensure all product members length are more than 13. Else try to check the length first in the formula. Also the position might be 12 or 13 based on index starting at 0 or 1.

Hope this helps !

Nikhil

[RajuRam]

Dear Mr. Nikhil, I could not find the substring function in my calculation editor. I presume this is because my data is from SAP BW live data. Could you please confirm whether text functions will work on SAP BW live data? If not, I kindly request you to suggest an alternative approach. Thank you.