Korea's King of Ballad

Proudly introducing you (if you haven't know) Mr. Shin Seung Hoon! ^_^ I'm currently smitten by his voice in OST of IRIS, Love of IRIS. This IRIS drama is soo on hype. With it's high production budget, abroad shoots (so far I had seen scenes in Hungary and Japan) and a lot of stars playing in it. It has Lee Byung Hun, Kim Tae Hee, TOP. It's OST has Baek Ji Young, Kim Tae Woo, Big Bang and yes, Mr. Shin Seung Hoon himself. Oh he has that mysterious aura which makes him even more charismatic as he gets older. I really hope his prodigy will be as as good as him, or even better. May I wish a hard work and good luck for Tei, Shin Hye Sung, who else? Lee Seung Gi? Kim Jong Kook? No? Hihi.

Download Shin Seung Hoon - Love of IRIS [Credit: Soompi IRIS forum]

SAP BI GetQueryViewData

Now that my scope of work has shifted, I found new things to play with. Good bye ABAP-ing in ECC 6.0. Welcome ABAP-ing in SAP BI, kekekke. More than that, I am challenged to bring out SAP BI data to the world company. Like what my seniors and I have been doing in R3, we abused brought out the precious information to Web Services and SQL Servers. And the result are dynamic heart beats of transactions and reports that have the spirit of single source of truth. Speaking of information in our company is speaking of SAP data. No other. Of course, without having to remember a T-Code.

Years passed through. My interest got hooked on SAP BI. With all massive storage and OLAP techniques that makes reporting finally got its attention in the first place. To communicate with SAP BI from outside, I've tried the hard way and currently using the easy way. The hard way, learn MDX Query and pass it to BI by calling a BAPI. I can't remember the BAPI name, I don't want to discuss that now. Me feels too hard to coupe with MDX query. The easy way, using a web service that SAP BI provide. For doing this, you have to work with some one who have access to SAP BI GUI and can operate SAP Query Designer. Ask the dude to follow the steps to prepare the web service in SAP BI here. That document is a starter, the journey to have a ready-to-call web service has just begun my friend. This is tricky, you thought you got the web service link, but when you tried to access it, BUM! Failed. Well if that's the case, kindly contact me. See if I can help you. Been there, me. Sorry but I really need to skip so that I can finish this fast.

Specify your output data to SAP BI dude so that they can build that into a query, of course from the Query Designer. As a result, you will get query name and info provider name.

Now it's web application's turn. The service you need to call is GetQueryViewData. When testing, use a simple query without any variable screen. Because dealing with variable screen is the second confusing thing. Explanation from SAP on how to pass parameter to variable screen in this service is veeery hard. It is far away from plain. I have to google and google again until accidentally met the same programmer with the same problem. And this is how GetQueryViewData is called using parameter:

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Collections.Generic;
using System.Net;
using WSDashboardEnterprisePortal.SAPBIProxy.GetQueryData;
//That was the class of the web reference
public static GetQueryViewDataResponse GetQueryData() {
       NetworkCredential login = new NetworkCredential();
       GET_QUERY_DATA BWQuery = new GET_QUERY_DATA();
       login = new NetworkCredential();
       login.UserName = "UserName";
       login.Password = "Password";
       BWQuery.Credentials = login;
       BWQuery.PreAuthenticate = true;
       GetQueryViewData gqvd = new GetQueryViewData();
       gqvd.Infoprovider = "InfoProvider";
       gqvd.Query = "QueryName";
       List listParam = new List();
       W3query param;
       for (int k = 0; k < arrParameter.Length; k++) {
       //If you only have one parameter, omit this loop
            param = new W3query();
            param.Name = string.Concat("VAR_NAME_",(k+1).ToString()); //VAR_NAME_1, VAR_NAME_2, and so on
            param.Value = "0CALMONTH";
            listParam.Add(param);
            param = null;
            param = new W3query();
            param.Name = string.Concat("VAR_VALUE_EXT_",(k+1).ToString());
            //That was VAR_VALUE_EXT_1, VAR_VALUE_EXT_2, and so on
            param.Value = "200909";
            listParam.Add(param);
      }
      gqvd.Parameter = listParam.ToArray();
      gqvd.ViewId = null;
      GetQueryViewDataResponse response = BWQuery.GetQueryViewData(gqvd);
      return response;
}

Two Things That I Don't Need To Do

In my case, gaining weight and being improvident are two things in common. Things that I don't need to do.

Sinetron It Is

There are dramas in Korean being called as makjang series. Makjang plot it self is described as:

outrageous storylines involving adultery, revenge, rape, deception and the like, designed to keep viewers hooked no matter how ridiculous the stories became.

In Indonesia, I am sure we call that sinetron :D
Credit: dramabeans

On Rainy Days Like This

Suddenly remind me of old-office days. 8 o'clock in the morning, inside angkot B-09 Ciledug, listening to Opick's song. It was cloudy outside, rain began to pour in. I was wondering will I pass the last of lots of Pertamina exam. Then, if not how long will I be working in current office. All feelings got in my heart. The memories of friends who are already pass Telkom exam. My parents who wish me to work in decent hours. Allah Who is very kind to me. It was hard days. And I was alone. Like I always do. Ah no~~. Allah is there ^^

Create New User in SQL Server

Credit: Dr. Herong Yang [www.herongyang.com]

C:\>sqlcmd -S localhost -U sa -P xxxx

1> -- Set DBPMSPemasaran as the current database
2> USE DBPMSPemasaran;
3> GO
Changed database context to 'DBPMSPemasaran'.

1> -- Create a new server login name: PMSPemasaran
2> CREATE LOGIN PMSPemasaran WITH PASSWORD = 'xxxxx'
3> GO

1> -- Create a new database user linked to the login name
2> CREATE USER PMSPemasaran FOR LOGIN PMSPemasaran;
3> GO

1> -- Grant database ALTER permision to the user
2> GRANT ALTER To PMSPemasaran;
3> GO

1> -- Grant database CONTROL permision to the user
2> GRANT CONTROL To PMSPemasaran;
3> GO

Here is what I did to test this new login name and user: PMSPemasaran

C:\>sqlcmd -S localhost -U PMSPemasaran -P xxxxx

1> -- Set DBPMSPemasaran as the current database
2> USE DBPMSPemasaran;
3> GO
Changed database context to 'DBPMSPemasaran'.

1> -- Create a new table
2> CREATE TABLE Test (ID INT);
3> GO

1> -- Drop the table
2> DROP TABLE Test;
3> GO

Konglish

Andy's Single Man song is released. Listen to it a bit. And shocked how Andy who ever stayed at US and experienced education there incorporated some Konglish in the song, "Wannabe a sing sing boy." LOL. I guess he finds it cute so he agreed to sing it. Oh and just listen how he pronounced sweetheart like he didn't know the meaning, kekekeke. Andy-sshi, don't need to be so modest about your English. You are loved for who you are.

And, this is one of Korea's hot single man singing that he only want a free love.