SAP analytics cloud-Stories-If else with Like

[former_member657015]

Hi Team

I have limited access in my organisation like I can work only on stories . We dont have data model access to create or edit.

I need to create a new column on a story/ table where I was showing data :

if company_name like "*ABC*" then "new_grp_name" else company_name

Could you please help on this.

Thanks

Neha

[jerryjanda]

Thank you for visiting SAP Community to get answers to your questions. I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. (For example, you can outline what steps you took to find answers (and why they weren't helpful).) The more details you provide, the more likely it is that members will be able to assist you. You should also clearly state a question.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question).

--Jerry

[former_member657015]

capture1.pngcapture.pngcapture2.png

Hi Team

I understand your suggestion and I knew it, but I don't know why this "create calculated dimension" is not available on my SAC version. Please find attached screenshot and suggest me.

Thanks

[former_member657015]

I have no surrounding to ask the question related to this tool.

And if I am stuck somewhere in your tool then who is responisble to provide the solution.

The team is not proactive.

VERY DISAPPOINT

[former_member657015]

Hi All

Thanks for the reply.

Kindly suggest, whats wrong in this formula:

IF((LIKE([d/"BSR_MODEL":YCAMPAIGN_TXTLG].[d/"BSR_MODEL":YCAMPAIGN] ,".*XBR.*" ) ,"MULTIBRAND",[d/"BSR_MODEL":YCAMPAIGN_TXTLG].[d/"BSR_MODEL":YCAMPAIGN] )

Really appreciate.

[former_member657015]

Thanks for your suggestion.

It was live connection that is why "create calculated dimension" option was not avaiable with us.

But this time again I am trying to write below formula using LIKE function

but getting err.."Formula could not be completed..choose property for dimension DESCRIPTION..."

Would really appriciate if you can help me.

thanks