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_member207052 · Accepted solution]

Hello,

Look under dimensions instead of measure. you have to create a calculated dimension.

You could look into the learning materials for further details on getting started with SAC: https://www.sapanalytics.cloud/guided_playlists/

[former_member207052]

Hello,

Create a Calculated dimension with the below formula:

You have to specify whether you want to compare the ID or the Description of the dimension. You could use ctrl + Space to get help in the formula window.

IF(LIKE([d/"BestRunJuice_SampleModel":Sales_Manager__5w3m5d06b5].[p/Description],
        ".*W.*"),
        "Has cap W in name",
        "No cap W in Name")

[former_member657015]

Thanks for the reply.

In my SAC story I can not see the calculated dimension option under Builder Panel.capture2.pngcapture1.png

Please find attached screenshot and please suggest.

Thanks

[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

[former_member542603]

Hi Neha,

You can create a calculated measure in the Builder Panel using the below formula.

IF(Like([company_name].[company_name], ".*ABC.*"), [new_grp_name].[new_grp_name], [company_name].[company_name])

Let me know if this matches your requirement.

-Sathya

[former_member657015]

Hi

Please find attached error.

capture.png

Also why we have to write company_name.company_name

Please suggest.

Thanks

[former_member542603]

Hi Neha,

It is like "Dimension_Name.ID".

As mentioned by Narashimman Pls try Ctrl+Space after the dimension.

- Sathya