Some Attributes values coming none, instead of coming none it should be replaced by blank !

[anamika_mudgal]

Hello Folks ,

I have one requirement ,

Some Attributes values coming none while creating planning view, now instead of coming none it should be replaced by blank . Can we achieve through EPM Formatting ?

Or any other workaround ?

Any lead on this would be appreciated, Thanks in advance.

Regards,

Ana

[mkorndoerfer · Accepted solution]

Hello Ana,

Yes, it is possible to do it via EPM Edit Report. Follow the steps below:

1. Open EPM Edit Report in Excel;
2. Select 'Member Names' tab;
3. Select the dimension (e.g. 'Location ID') and its respective value to be changed (in your case, 'None'). Then just add the new name for it (in your case, add one space) and click on 'Override'. See screenshot 'epm-editor.png'.

Best regards,
Matheus