Question Re: Replace Function in SAP analytics cloud in Technology Q&A

Replace Function in SAP analytics cloud

former_member1316811 — Tue, 29 Nov 2022 06:31:12 GMT

Hi Everyone,

I have a dimension with a list of project number that looks like this.

IN.20037820

I am trying remove the dot in the middle so that it is trimmed down to IN20037820.

So I tried to create a calculated dimension, using the REPLACE function,

REPLACE([d/"Status and Commentary":Project_Def_1f3z41s68l] ,'.','')

but I get this error.

Not sure what it means by choose a property, or how to choose a property, hoping someone here has a clue.

"Formula could not be computed: Choose a property for dimension "Project_Def_1f3z41s68l" in function "REPLACE". Please complete or rewrite the formula."

question.png

Re: Replace Function in SAP analytics cloud

mfoeken — Tue, 29 Nov 2022 07:43:28 GMT

Hi Steven,

Have you tried using double quotes: "." ?

Kind regards,

Martijn van Foeken | Interdobs

Re: Replace Function in SAP analytics cloud

Susanne_Helbig — Tue, 29 Nov 2022 08:01:35 GMT

Hi steve5232,

the formula is written with semicolon and you need to specify the property of the dimension you want to change.

Try something like this:

REPLACE([d/"Status and Commentary":Project_Def_1f3z41s68l] .[p/ID];".";"")

Best regards
Susanne

Re: Replace Function in SAP analytics cloud

N1kh1l — Tue, 29 Nov 2022 08:04:01 GMT

steve5232

Try something like below. You need to provide which property (ID, Description etc ) of dimension you want this replace action on.

REPLACE([d/"EMPLOYEE":WD_EMPLOYEE].[p/ID],".","")

Hope it helps !!

Regards

Nikhil

Re: Replace Function in SAP analytics cloud

former_member1316811 — Wed, 30 Nov 2022 01:50:39 GMT

Thank you it worked.