The Guru & 大大

其實沒有什麼好覺得羞恥不敢公開講的，我的英文程度真的不是很好。

 

出國旅遊，跟外國同事傳傳Email說一下系統情況這種程度的英文我都還OK，但啥看CNN新聞、看原文電影影集、和美國同事開Telephone meeting，我就會死得很慘。原因其實很簡單，我的英文單字量真的不怎麼多啊！

 

開始在WMF寫論文後，每天都面對很多挑戰，同事常常交代給我一些問題讓我自己去研究解決方法，我當然沒有那麼天才能平空生出答案，唯一能做的就是天天去拜SAP SDN 論譚，多看幾天就會發現很多人問問題的開頭字都是Gurus。剛開始還沒太在意，反正不影響底下文章的了解，後來看太多開始覺得奇怪，再加上這字的發音總讓我覺得頗滑稽，好似魔戒裡的那隻是人非人的生物，最後終於引起我的好奇心用Google 翻譯了一下：

guru /ˈɡʊruː/ DJ    /'guru/ KK

• a Hindu or Sikh religious teacher or leader 古魯（印度教或錫克教的宗教導師或領袖）

• a person who is an expert on a particular subject or who is very good at doing sth 專家；權威；大師 informal

 

原來Guru 就是我們的大大啊！

 

【輕鬆一下】 

現在每天最大的期待就是過年回台灣大吃大喝的旅行。不只我很期待返鄉之旅，我家的德國人也每天夢想著要去澎湖、要去蘭嶼、要去綠島，因為上次回台灣他被小琉球的美給嚇到了，什麼巴里島穌美島的都沒有就在離我家不到一小時車程+ 外加45分鐘船程的小琉球美啦！所以他這次超期待聽說比小琉球更美的蘭嶼與綠島。

本日推薦文：大爺遊台灣 --『小琉球』

 

InfoObject - Text 的語言設定‏

As you know, you can set up text data for InfoObject.

More, you can also set up if the text data are language dependent or not.
When yes, sometime this case happen:

You have 20 different language text in your source data, after load the data into InfoObject, some language missed…what happen?

Of course, there are different reason cause your data missed..but..in most case…the reason is just so simple: you didn’t install the language you need!!

 

TC: SMLT


On my system, I only have two language installed: English and Germany (as above photo). Even I have 20 different language text in my source system,  only these two language text will be loaded into my InfoObject.
Last point, you can add more language by this transaction code according to your need.  

【輕鬆一下】 
最近被論文進度追著跑，不太有寫部落格的情緒，但其實發現，還多虧了我有寫部落格的習慣，有些東西看過一次，下次想要在拿來用時卻想不起來到底Transaction code 是啥啊。

低潮了時候來看看陽光，沙灘的美麗熱帶海吧。
本日推薦文：藍天、美食、珊瑚礁 「帕安島」

Data Warehouse 之爭

 

今天發現一件很好玩的事，原來…西方人…也會這麼))&$(I$L%…

 

有讀過Data Warehouse 文獻的人應該都認識Willam. H. Inmon 和 Ralph Kimball 這兩位大師吧。這兩位可說是開創了DW 的理論基礎(雖說兩位各自提的理論還蠻不相同的)，也對DW 這產業有很大的貢獻。

 

不過今天要談的只有Inmon 大師。

 

前幾天讀到Inmon 的兩篇文章，他在這兩篇文章中抱怨有個叫匿名RAUL634 的人老是去修改他在Wikipedia 上的身家歷史，明明他，Inmon，就是發明Data Warehouse 這個辭的人，可是這位RAUL634老兄不知何居心，老是去改掉這段話。在這兩篇文章中，Inmon 還引經據典地說明，IBM 的研究員Barry Devlin 的確在1988 年IBM 的內部期刊中發表過一篇文章，但那篇文章裡從頭到尾只有用到 Information Warehouse 這兩個字。他，Inmon ，是第一個提出Data warehouse 這個辭的人，當時他還想要註冊這兩個字的所有權，曾經請過律師去查明是否有人用過這兩個字， 結果是某家出版社擁有這個辭的所有權，但是指跟資料庫完全沒關係的東西。所以最後的結論是：他，Inmon 是第一個提出Data warehouse 這個辭且表示與現在大家所說的BW 是同一個東西了人。

看到Inmon 這麼引經據典，我還真的相信他了…

 

沒想到，過了幾天，一個巧合下，我在當年那位IBM 研究員Barry Devlin 的部落格看到他反控Inmon 的文章。他說，事實勝於雄辯，直接去看他當年發表在IBM 期刊的文章就知道，他的文章裡明明白白的提出『Business Data Warehouse 』這個辭。我去檢查了Devlin 當年發表的文章，沒錯，文章裡出現了三四次Business Data Warehouse 這個辭。然後在那篇反控Inmon 文章的結尾，Devlin 還嘲諷Inmon說：你，Inmon ，要不要乾脆說自己是 universally recognized as the father of the data warehouse 的人算了(註一)，ps 雖然很多人會不同意。

 

Well，看到這裡不知道你是如何想的，這事件真的有很令人玩味之處。當年Devlin 提出的辭是”Business Data Warehouse”，而不是”Data Warehouse”，所以說Inmon 是第一個提出 Data Warehouse 也沒錯。但在Inmon 那兩篇辯解的文章裡，Inmon 只敢說Devlin 當年提到的是 Information Warehouse ，他為啥不敢辯說 BDW 跟 DW 是兩個不一樣的字啊？！

 

註一：在Inmon 的部落格，他出版的書，他的Wikipedia 網頁…所有他有權力插一腳的地方都可以看到Inmon 這樣定位自己：Bill Inmon is widely recognized as the "father of data warehousing."。

註二：這篇文章並不是我不尊敬Inmon，其實不論是Inmon, Devlin 還是這篇文章只有輕輕帶過的Kimball，他們在BW 界的成就和貢獻都是我這輩子不可能達到的。

 

【輕鬆一下】
德國今年天氣超怪的，上一個星期還是高溫25度的美麗夏日，才過一個週末，馬上從夏天直接跳到冬季，這一星期沒有一天最高溫是超過五度的，秋天就這樣跳過去了，雖然這樣，還是要來看一下秋天的代表物==南瓜。來看看我第一次做的南瓜燈籠吧！
本日推薦文： Trick or treat!

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產業的動態。請大家拭目以待。