Skip to Content

Analysis for office 2.4 -> ## instead of Empfy cells

Dear Experts

we have updated from 1.4 to 2.4 SP2. Now all empty cells are new filled with ##. Is there anybody to know about that? How can we changed it to empty cells without ##.

Thanks a lot.

Kr

Adrian

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 06, 2017 at 10:58 AM

    Hi Adrian - looks like per this SAP Note https://launchpad.support.sap.com/#/notes/2343234/E you will need to wait for 2.5 or do the work around mentioned in this note:

    "In case you need an urgent workaround for this problem:

    Create a new calculated attribute in your HANA view where you replace the # and ## member with a member value, which does not conflict with your data and use the new calculated attribute instead of the original attribute."

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 06, 2017 at 09:21 AM

    Hi Adrian - is your data source a BEx query? If so you can suppress null values in BEx - see https://archive.sap.com/discussions/thread/865074

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Tammy, Thanks for your Response. No it's a Calculation View from HANA. The issue is that in AFO 1.4 it's empty and in 2.4 we have ##. Do you have an idea about to solve it?

      Thanks a lot.

      Kind regards,

      Adrian

  • Jun 06, 2017 at 11:58 AM

    Thank you Tammy!

    Add comment
    10|10000 characters needed characters exceeded