Input ready rows showing error when checked with 'transfer values'

[Former Member]

Hi All,

I have a input ready query. In that i have made settings for adding new input ready rows. As a result I got new input ready rows in the end of the query. But when I entered values in the input ready query and selected 'transfer values' it is showing an error in the BEx Analyzer. Message - 'Entered values are incorrect'

In my query I have used characteristic fiscal year period in columns. Because I want to split the quantity based on fiscal year period. So I put fiscal year period on top of the structure in columns(keyfigure structure). Is this a reason for the failure because SAP says You cannot use characteristics in the columns and can use one structure only. in the link [http://help.sap.com/saphelp_nw2004s/helpdata/en/43/f234619e3c4c5de10000000a155369/frameset.htm]

I would like to know whether this is the reason for the failure or is there any other workaround.

Thanks and Regards,

Jerry

[Former Member]

Part of standard SAP I guess as this even doesn't have a workaround in WAD/BEx HTML. Check this under 'Input Ready New Rows' : http://goo.gl/Nzatr Wondering if the characteristic is compounded, as the compounding parents can be restricted to a single value or drilled-down in rows/columns?

[Former Member]

Hi Arun Bala,

The characteristic is not compounded. I want to know whether I am proceeding in the right way because I have put fiscal year period in columns. SAP says not to put any characteristic in columns. But I need to show the quantity in all fiscal year periods. So fiscal year period is put on top of the structure(contains only quantity) in columns.

My question is

1. From the input ready rows perspective - 'Is it sure that the input ready rows will not work if there is a characteristic in columns'. In my case fiscal year period is in columns.

2. From the query perspective - 'Is there any way to show the quantity of all fiscal year periods without using ficals year period on top of the column structure'.

Thanks and Regards,

Jerry

[gregor_dieckmann]

Hi Jerry,

you misunderstand the documentation. You can drill-down a characteristic on the columns and still maintain new lines. Only in the special case that no data exist at all (grid is empty) you have to put all the characteristics to the rows, cf. note 1149346 for more details.

The error you got might come from the UI layer, i.e. BEx Analyzer. If you have problems to understand error message (unclear, missing detailed information) open an OSS ticket.

If you want to debug this layer, check class cl_rsr_xls_view, method CREATE_NEW_VALUES.

Regards,

Gregor

[Former Member]

Hi Gregor,

That was good information. I will try to debug the code and find out what is wrong.

Thanks and Regards,

Jerry

[Former Member]

Hi,

How can I debug the Analyzer? I put session break point in the method 'create_new_values' and executed the analyzer. When I selected the transfer values option from the context menu, it did not open any debugging screen. It still showed the same error that 'entered values are incorrect'.

Thanks and Regards,

Jerry Jerome

[gregor_dieckmann]

Hi,

you have to use an external break-point.

Regards,

Gregor