Skip to Content
Former Member
Oct 27, 2015 at 10:06 AM

Insert new Columns in Analysis for Office 2.0


Dear all

I have a BEx Query added as a Datasource in a Analysis for Office Excel Workbook.

Company Code PCS China 10 Australia 20

Now I like to add a new Column into this Table:

Company Code Budget PCS China 10 10 Australia 30 20

This is not a BI-IP application. The user wants only add manually the Values for the Budget and the he wants to save this Workbook to the BI-Plattform.

When refresh the BEx Query, the Budget Column should be still there with the Values the User entered.

Does somebody know, how to insert such a Colum? A How-To would be great!