Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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 CodePCS
China10
Australia20

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

Company CodeBudgetPCS
China1010
Australia3020

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!

Thanks.

Adrian

Tags:
Former Member
replied

Last week at SAP TechEd Las Vegas, SAP showed a demo of 2.2, where you can insert rows/columns with custom Excel formulas; after refreshing the formulas stay....when I have time I will try to share more of my notes. 

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question