Skip to Content

Retrieve empty rows option

Hi community,

I've tried to set checkbox for Retrieve empty rows option in Query parameters but nfortunantely this option is disabled.

How it could be enable or is there any way to get NULL values data in a report ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 25 at 11:21 AM

    "Retrieve empty rows" available in OLAP .unx universes and BEx queries.It is not available in Relational .unx universes.

    check mentioned sap note.

    1729435 - Are Query Properties "Retrieve duplicate rows" and "Retrieve empty rows" available when designing a WebI document off either .UNX or BEx queries?

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 25 at 12:13 PM

    Thanks, Amit for your response!

    I am also interested in get values with null, any idea how to do that?

    Add comment
    10|10000 characters needed characters exceeded