Skip to Content
avatar image
Former Member

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!

Thanks.

Adrian

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 27, 2015 at 10:27 AM

    Hi

    You have a few options. Do you need to store the budget figure in BW?

    If yes you could look at using the planning functionality.

    If no you could convert the crosstab to formula and just add a column to enter the budget. If you want to retain the crosstab you could put the budget figure at the end of your crosstab provided the column numbers do not grow.

    Add comment
    10|10000 characters needed characters exceeded