Metadata Repository‏

A very useful tool inside BI Workbench Administration
“Metadata repository”


All Objects are listed here:

For example, I chose “InfoCube” à all active InfoCube are display.

Click one of the InfoCube, can see all information about this InfoCube, even the Queries and Aggregates which are using this Cube.

 

【輕鬆一下】
德國學校開學後，同事們都紛紛從休假中歸來，每天員工餐廳裡用餐的人都變得好多好多，來看看一下我曾經待過的德國公司的員工餐廳吧！
本日推薦文： 德國員工餐廳比一比

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』

Release the transport request‏

First time to release the transport request. But not allow to transport yet, haha..

At school, we only have one SAP system, no need for transport, all Objects are stored locally.

Later during my training ship by a international company, I did do some customizing. But there are too much trouble to apply “Developer Key” for a short term student inside a giant company. So I always use my leader’s account to login when I need to create “transport request”.  After the new functions passed for testing, my leader would release the transport request and transport it by himself. Let’s why until now I never have a chance to use this TC yet. Even it’s soooo easy…

TC: SE09


Click on the „Truck“ icon to release the transport request.



Then, with TC: STMS, you can export the transport request to target system.

【輕鬆一下】
週末 = 敗家時間？
推薦文章：粉紅小筆電eeePC S101H 開箱文

Where does "Partner-Role" hide?‏

Though I already have some experience on SAP BI and ERP before I come into this project, SAP CRM is absolutely new to me. My coacher, a BI-Expert, also doesn’t use CRM before. My colleagues? This is the first CRM project in this company, so...no one really knows something about it. The only one who really knows CRM is our consulting company which is 500 Kilometer away from us. So during the process to build the DataSources up, I spent lots of time to figure out which attribute in which table are the data I need.
For example, the most important DataSource I need to create: “Activity”.
On our UI, our end user (which are sales department) need to fill in the different partner when they create “activity”.
And I though those Partner-data will be in the table “CRMD_ORDER_INDEX”.

The attributes “PFT_6”, “PFT_7”, “PFT_8” indicate which Partner-Role the partner is. Totally wrong!!
Until I found, one activity have 3 partners with 3 different roles, but they are all marked in the attribute “PFT_8” in table “CRMD_ORDER_INDEX”. OMG! Something wrong!!
So, I read the SAP HELP firstly, it looks like I should go to “CRMD_PARTNER” table. But with deeply search on SDN Forum, I found out the true:
The Table “CRMV_linkPartner” includes the information: “Activity number”, “Partner Number” and “Partner role”. The attribute “PARTNER_FCT” indicates the “partner role”. These are what I am searching for.



【輕鬆一下】
聽說第一道鋒面已經降臨台灣了，不過我猜台灣應該還是熱得不得了吧，來看點清涼的降降火吧！
本日推薦文章：拜訪馬其頓王國 -- 人間仙境

ODS/DSO 美麗的誤會

I use SAP SDN Forum almost everyday. From there, the word "ODS/DSO" first time goes into my brain. But I didn't really pay  attention on it, I though it's just the abbreviation of "Object of Data source".

Until accidentally I read the title of this article (Difference between ODS and DSO objects) . Suddenly find out, what a big mistake I made. Lucky, I didn’t use ODS or DSO on my currently project yet. So my colleagues don’t know that I have no idea about soooo basic staff.
The definition of ODS or DSO can be found at above link, I don’t want to repeat it. Just some small thing for people who may the same as me who have no idea of “Data Store Object”. It is similar to InfoObject and InfoCube, all can store the data, but of course, they are three different things.

【輕鬆一下】
聽說台灣開了一家超精品百貨BellaVita，賣點是首家愛瑪仕台灣旗鑑店。不知在這麼高級的百貨公司能不能買到美食界的精品：『法國黑松露』啊？
本日推薦文章：【法國鄉村遊】跟著狗狗尋松露去

關於我、SAP、與這個站

先說我。六年級後段班，因為老天爺的錯愛，不情願地離開我可愛的寶島，降落到人冷食物冷天氣也冷的德意志帝國。


再說我和SAP。為了能在德國繼續生存下去，我重回校園學習關於SAP的一切。這中間包含一年的SAP BI 專案；半年在賓士總公司實習時使用QM模組；兩個月前我與德商WMF公司簽下一紙六個月的合約，在這六個月中，我將協助此公司建立因導入CRM模組而產生的BI報表需求。而此公司同意我將所有這過程中所學寫成我的碩士論文。

最後關於這個站。這個站將紀錄我每天在SAP領域所作所學的東西，預計一些技術性的文章之後會改編收入於我的論文中。在這個時間點上，我還真不知道這個部落格之後會往哪個方向發展，我想除了技術性文章外應該還會寫些德國SAP產業的動態。請大家拭目以待。