How To Enter New Rows in BI-IP with Excel Interface (SP 7 and above)

[Former Member]

Colleagues,

We recently applied SP 7 to our NetWeaver04s environment, and are using Excel for our front-end. We have developed queries, and embedded them in workbooks and are trying to figure out how best to add new rows.

Apologies in advance if this obvious and we just missed it. Thank you for any help you may be able to provide.

-M

[former_member93896 · Accepted solution]

Hello Michael,

it depends on the type of query. The scenarios are described in the online help. The easiest is to use key figures in the columns and a free characteristic in the rows. Then you can simply enter new rows for example using the value help (hit F4).

<a href="http://help.sap.com/saphelp_nw04s/helpdata/en/43/f234619e3c4c5de10000000a155369/frameset.htm">Manual Planning</a>

Regards,

Marc

SAP NetWeaver RIG