nested replace in eazybi

devashree ma

I have a data in eazybi and it is a grid data. 

Example: 1,2,3

I need the data to be replace as a,b,c

 

I used replace but it replaces only 1 as a but nested replace is not working

 

Thanks,

Devashree

Zane eazyBI Support

Hi @devashree ma,

Yes, MDX unction Replace() iterates through a list of values only once and replace only one item at the time. To make this work, you might want to use Replace() function within itself like this:

Replace(
  Replace(
    Replace(
      --initial value or an empty string if a value is missing at all
      CoalesceEmpty([Measures].[Property with values 123],""),
      "1","a"),
    "2","b"),
  "3","c"
)

 

Best,
Zane / support@eazyBI.com