Skip to Content

dimensions with null measures disappear when pasting a smart copy in AFO

Hi experts,

I am currently experiencing an issue where a user is using smart copy/paste, and the data contains dimension values with corresponding measures containing only null.

When the user initially connects to the query all the dimension values are shown. However when the sheet is filtered for the measure containing null values for some dimension values, AND the user chooses smart copy and smart pastes on a new sheet, the dimension values with corresponding null measure values are not shown. These can be found again by reselecting all measures, pressing ok, and refiltering for the previous mentioned measure.

Is there any explanation for this behaviour? Yes I know that a workaround could be to create a formula and add 0 to the keyfigure in the BEx query, but I am also interested in the reason for the behaviour, in order to explain it :)

Best regards


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 09, 2018 at 11:39 AM

    I think it is the difference in the BICS vs ABAP behavior; there is a related idea in old Idea Place to address nulls with Analysis Office:

    Add comment
    10|10000 characters needed characters exceeded

    • Yes on the first; and on the latter I am simply guessing. There are some SAP Notes about Analysis Office and null behavior, relating back to BICS, so I am simply guessing that's impacting the smart copy.