Skip to Content

Replacing None in attribute value - not available for key figures at a level

Apr 19, 2017 at 10:35 PM


avatar image

Hi All,

Is it possible that we can replace the "None" (highlighted in below screenshot) with something more meainingful like "For all customers" in our planning view. - e.g. if we have 2 key figures in a view defined at 2 different planning levels, leads to a display of "None" for key figure at higher level

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Matheus Korndoerfer
Apr 19, 2017 at 11:35 PM

Hello Vijay,

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 (in your case 'Customer ID') and its respective value to be changed (in your case, 'None'). Then just add the new name for it and click on 'Override'. See screenshot 'epm-edit-report.png'.

Best regards,

epm-edit-report.png (126.2 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Matheus, It resolved the issue.