Renaming Dimension elements

We have a Dimension called “Assets am Standort” (= Assets in Location) ; and I would like to rename in the report the 3 Assets we currently have.

Instead of “SSI_211_01” , we would like to have “CustomName 01” displayed.

image

I´ve tried to create the following New calculated member in the dimension:

case when
[Asset am Standort].[Asset am Standort].Name = “SSI_211_01”
then “Custom” else [Asset am Standort].[Asset am Standort].Name END

When I do so, I see the folloing error message:

image

How can I solve this?

Many thanks in advance.

Hi @AntonBDR ,
There are two possibilities that you could try.

  1. You can either create a new JavaScript dimension that would be created and used instead of your “Asset am Standort” dimension. See some examples here: JavaScript calculated custom fields - eazyBI for Jira

  2. Or add custom JavaScript code in import options to rename your values: Custom JavaScript code - eazyBI for Jira. This will modify the received issue JSON object before importing issues into eazyBI.

best,
Gerda // support@eazyBI.com

@gerda.grantina would you be able to provide a script based on above example asked in original question, I will then modify it accounding to my need.