Adding field to info cube

[Former Member]

HI

I have a cube with data, Now i want to add a new field and want to load data for that particular field.

eg:-

F1 F2

1 A

2 B

3 C

1 A

1 A

3 C

I already have the data for Field1, now i need to load data to field 2, for which the data has to be replicated like above in my fact table. I am having the data for Field 2 in another FF (i.e not the one loaded initially). So i need to add the field and load the data to that particular field from another flatfile.

[abhishek_rajan3]

Hi,

Sorry, but the issue is not very clear. Can you please elaborate more on this?

In case your issue is how add a new field to cube and load data for this field, there are two options:

1) Transport changes, delete data in the infocube, and reload from the FF that has new field data. In this case, the Flat file should contain data for all fields in the cube which you need data for.

2) Use Remodelling tool for Infocube (If your system is 7.x), and fill F2 based on F1 field values. Please refer to the below link for help to use remodelling tool:

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/008f9fef-22e4-2a10-d994-a17c55ca06f0

Hope it helps.

Thanks,

Abhishek.