When infoObject not activable…‏

The Stupid I did: there are two z-Attributes(a & b) which I would like to change the data type, inside a InfoObject (c ). I did change the Data type of these two Attributes before I remove them from the attribute list of InfoObject C. So…what happen?

When I want to remove a & b from C and active C, the BI system should me a message that “you can’t active  C, because there is a error when adjust the master data table ”. well..obviously..there are still lot of old format data inside the master data table..so..I get this error.

Ok, so..let me delete all master data firstly…ops.. I get any other message “ you can’t delete master data because this InfoObject is not active”. So ….S..H…I..T…

So..what can I do…I did try to google...but..at the end..only wait until next day until my private coach in office.

Solution from my coach (in fact, I am not 100% sure what did he do..he did it to fast, my knowledge is to few):

1.      Write a ABAP program to delete all master data for InfoObject C. à so..a amazing solution, what can I say.
2.      TC: SE14. To adjust the format of the master data table. (not sure did he do this, but definitely he take a look something in this TC.
3.      A small icon show out on the right side of the InfoObject C (as following picture).

The reason of this icon show out is we use “Aggregate” for this InfoObject. To remove this icon, we need to execute “Attribute Change Run“.

4.     Go to RSA1à InfoProvideràToolsàApply Hierarchy/Attribute Change.


More Info: http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417600)ID2144214450DB02902198745675117596End?blog=/pub/wlg/13726

5.      Finally with those amazing stuff, I can active this InfoObject, transformation, DTP…and load the data. End of today. Ops..

【輕鬆一下】
來看一下我現在每天上班的地方吧。
本日推薦文：拜訪『WMF 總公司』與『WMF Outlet』