Random Mind #4

Just read JB's recap of The Woman Who Still Wants to Marry episode 4. Got big blown by the script, the imagination of Kim Bum flirt with older woman. That is one cute hell playboy right there!

Follow Changes to Any Website with Google Reader

And now Google Reader has enable us to follow changes of any website pages that don't have feeds. Just click Add Subscription, paste the page URL and click Create a Feed. My first trial will be NAB Reksadana PNM Ekuitas Syariah's page. Tomorrow the page should be changed, and I will see it through my lovely Google Reader!

Update: unfortunately it is failed T.T

Google was not able to access this page to check for updates. This page may be unavailable or have other restrictions that prevent Google from getting updates.

Random Mind #3

Jang Geun-Seok surely choose the dorky path! In a bold way! I can't believe this was the charming Geun-Seok in Hwang Jini and You Are Beautiful. LOL.. such a dork.

Random Mind #2

Some random trivia about Younha's song "Broke Up Today":

• The music video starring Ji Chang Wook & Han Bo Bae. The handsome Ji Chang Wook was adorable mangnae (youngest brother) Song Mi Poong in drama The Sons of Sol's Pharmacy House.
• Younha was featured in Kim Dong Wan's single Promise. It was released at the time Dong Wan was going to the mandatory military service in 2008.
• A lot of KPop lovers consider Younha is very talented but receives not enough attention due to massive expansion of girl and boy band.
• The song and the music video, I find them quite interesting. But still, not enough to conquer SNSD and 2PM on the chart *grin*
• The hair.. it was hair extensions right? Ah.. what's with these girl singers and hair extensions... It didn't look natural.
• Anyway, please enjoy her gifted voice like I do and forgive me for all the nonsense.

Call .Net Application from SAP BAPI

Although other way around is very common, I never think of possibility to establish connection from SAP to .Net. This article describe the possibility. In that example, SAP BAPI call .Net program to send e-mail through Gmail POP3. Nice.

SAP BI Planning Sequence

Let's learn a bit about the result of button Start Modeller in transaction RSPLAN. Any of you wonder what is that thing - when an explorer burst out contains 5 tabs titled Modeller at the top of the window? Well I am. Why would we have to do it web based anyway. I'll let that to be a mystery for now.

Simply said, this window allow us to perform some 'query command' to an InfoProvider. Like we all IT freaks acknowledge, the famous "SELECT attribute_fields, SUM value_fields GROUP BY attribute_fields FROM table WHERE condition"

Those 5 tabs represent each piece of the famous statement above. InfoProvider represents the table. Aggregation level represents the SELECT and GROUP BY attribute_fields at the same time. Filter represents the WHERE condition. Planning function represents the type of command we need to do, whether it is delete or update. Other than that, a lot of actions already prepared by SAP. Moreover, we can add new type of actions when all that prepared don't fullfil our need. Planning sequence is like a wrapper that consist sequence of the planning functions needed to play together for a certain goal.

Up until here, I hope that helps to mend your confuse mind. And not get more confuse. Next...

This is some diagram to show the relationship between each tab.

So to get us started, first we need to define an aggregation level.
Following it, a filter and a planning function based on the aggregation level. Finally, put the planning function into a planning sequence.

Now the fun part, testing. First make sure the InfoProvider is in the Plan Mode. Go to RSA1 right click the InfoProvider. Change Real-Time Load Behaviour and tick Real-Time Data Target Can be Planned. After we do this, we need to close the browser and re-open it. In the extreme condition where SAP seems to be ignorant little thing, I even have to close the browser, close the GUI and re-login.

A planning sequence can be executed directly. You can see execute button on top of Planning Sequence tab. Don't be scared to click it because it won't change the actual data. Not until you click "Save Plan Data" and set the InfoProvider into Load Mode. The newly updated data will appear as a new request in Manage section of the InfoProvider.

The useful part, planning sequence can be called through Process Chain. You can find it under Process Type - Other BW Process - Execute Planning Sequence.

Phew, I'm done.

Written while listening: 죽어도 못 보내 - 2AM

Currently on The Playlist

• Even If I Die, I Can't Let Go - 2AM. Jo Kwon yang melambai itu.. nyanyi ballad kaya gini. Currently smitten by the strong lyrics. 
• One Love - Andy Feat. Kim Dong Wan. The lyrics come from the heart, thus so beautiful. I can't help but to say, good job Andy! And come back soon Shinhwa!
• Alone - CNBlue. New comer with a bit of Japanese taste, fast and catchy rhythms.

Seriously addictive, here is 2AM's MV with English transalation. Credit as shown in the video.

Random Mind #1

I thought if I could keep these random thoughts in blog it would be better. Twitter or Facebook are just too expensive for an office prisoner like me. So here I go:

Was reading dramabeans about Que Sera-Sera and realize how un-finish the drama is from the viewers' point of view. Thinking about this guy who is serving his military duty and will come back in 9 months. So Eric, just do Que Sera-Sera season 2 when you come back please!