Can we add Additional Fields to already existing InfoCube?

[former_member466150]

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?

[MGrob · Accepted solution]

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

[former_member466150 · Accepted solution]

This message was moderated.

[former_member466150]

Ok Thank You suman and martin.

[former_member182470]

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.

[former_member466150]

Hi Suman Chakravarthy K,

Thank you very much, as you mentioned I have deleted DTP and created new one. That's it, Data loaded into the Cube.

Will you please explain what actually happened after deleting old DTP and running the new one.

Because my DataSource, Transfermation, DTP all were created newly after deleting the old DataSource, Transfermation, DTP (with same DataSource Name).

And one change that I made between Old and New DTP was, I changed Extraction Mode to FullLoad. Is this has any effect.

Thanking You,

Hemanth

[MGrob]

Hi

Its related to a program error in your current version of SAP NW BW. There is a couple notes that fix this behaviour or service pack should you patch your system.

The only way this can be fixed is creating a new dtp.

Have a look at Note 1148007 - Error when generating write program for InfoCubes

Martin

[former_member182470]

I think your old DTP would have been corrupted internally at the database level. That's why deleting and creating did the magic for you.

[RamanKorrapati]

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

[anshu_lilhori]

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

[former_member466150]

Hi AL,

Thanks for the reply. Yes I have checked Transformations, Mapping, InfoCube is active for sure and no warnings or errors during activation in the entire process except at DTP Level I am facing the issue.