Skip to Content
h k

Can we add Additional Fields to already existing InfoCube?

Hi,

I have initially loaded extracted Data from ECC into an InfoCube using VIEW concept.

Later I have added 2 columns(NETWE, WAERK) in the VIEW and created the DataSource (RSO2).

Also I included these additional fields in my InfoCube by Editing it (CTRL+F1).

I Deleted previous DataSource before Replicating, After Replicating and executing InfoPackage the Data is fine in the PSA. But while Executing DTP I am getting Error as :

'error while updating to target (type infocube) in sap bi'

'error while updating to the Target'.

Status: 'Processed with Errors'.

I deleted previous Data in the InfoCube as well before DTP.

What is the solution for this?

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Sep 08, 2013 at 04:49 PM

    Hi

    Since your data is fine up until PSA try to

    1) reactivate datasource

    2) the transformation between cube and DS.

    3) delete your dtp and create a new one (this should fix it)

    hope it helps

    Martin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 08, 2013 at 05:23 PM

    Have you mapped two new fields in the transformation?

    Delete the existing DTP and put the filters, if any.

    That's it, your load should be successful to Cube. I don't see any issue here.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 08, 2013 at 03:54 PM

    Hi,

    Please check the transformations.Are they activated ?

    Check if the currency mapping has been done correctly for the newly added fields.

    Activate the infocube again and see if it gives any sort of warning or error messages.

    Check if the issue is with some erroneous data.

    Hope this helps.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 08, 2013 at 04:28 PM

    Hi hemanth,

    Have you deleted data from cube before adding info objects cube?

    Always better to add info objects thru remodeling if cube have data. if you need historical data for added fields then delete and reload is mandatory.

    Check the below steps.

    1. Replicate your data source in to bw side(if done, then not required)

    2. Activate your data source.

    3. Activate transformations from data source to info cube.

    4. Check the transformation mapping was correct or not.

    5.if your info pack was full load then delete previous request at PSA(just have latest one)

    6. load latest request from PSA to Cube thru DTP.

    It may works. if you got any error pls share here.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 09, 2013 at 05:33 AM

    Ok Thank You suman and martin.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.