"Could not find any data to display" when Key figure is with "Always Hide" option in display property
After upgrade to BW731-SP14 from SP04, seeing an issue in the Bex output if display property of a Key figure is changed to "Always Hide". Where as the same report used to display the output even with Key figure is hidden in earlier versions. Not sure if it is due to upgrade or any other.
In detail : A bex query is designed by hiding a Key figure, a formula variable is created in which this key figure is used. Formula variable is made to display always where as key figure is made to hide always. So in the output, only 1 column(Formula variable) should be displayed. This report worked fine earlier but its now displaying the message "Could not find any data to display" inspite of data available for output. Tried the option "Suppress Zeros" to Do Not suppress also.
Part of trials, if key figure is made available for display then output is seen for the report but which is displaying 2 columns i.e, Formula variable and Key figure, but requirement is to have only formula variable column in the output.