Share My Moodlody

Notice an mp3 player I've put on top of this blog post? I'm trying to share you my current mood melody, moodlody for short ^_^. This can be the current song I've put on nonstop playing or an enjoyable song I've found while surfing or just a top 10 song on Korean music industry. Other way all I hope is I could give you some options on how this blog should be read melodically. Enjoy.

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.

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;
}

Pasang FastNet

Pagi ini baru telepon first media, minta dipasang fastnet. Karena lagi promo dapet diskon macem-macem, yang dibilang mbaknya tadi ada 5. Yang saya ingat, modem diskon 50% jadi 250 ribu, bulan-1 gratis, biaya pasang gratis. Selanjutnya saya main ke om gugel, liat-liat percakapan maya tentang si fastnet ini. Banyak. Yang paling saya perhatikan saat ini adalah koneksi ke modemnya cuma bisa dari 1 komputer karena server ISP ngecek MAC Address dari komputer yang terhubung. Saya berniat menggunakan laptop kantor untuk dihubungkan ke modemnya. Tapi saya juga perlu laptop rumah bisa terhubung, secara laptop kantor cuma ada di rumah weekend saja. Dan mulailah saya mencari software yang istilahnya bisa "meng-cloning MAC Address". Laptop rumah akan saya instal itu, kemudia saya samakan MAC Address-nya dengan laptop kantor. Dapat installer yang ini. Hope it works. Itu PR pertama. PR kedua, kalo kedua laptop ada di rumah, saya mau dua2-nya bisa terhubung ke internet. Beli router nanti dulu. Saya berniat melakukan ini tanpa modal :p Ingat kejadian dulu pas class room sekamar sama Chie dan Reni di Simprug. Kabel LAN cuma satu, tapi laptop ada 3, dan Chie mengeluarkan jurus dari buku 'Wireless Kungfu'. Berhasil. Kita bertiga bisa terhubung ke internet. Jadi kayanya harus pinjam buku itu. Secara saya adalah perempuan ndak mudeng network, ini adalah pekerjaan susah. Dulu kuliah sistem operasi, komunikasi data, praktikum, sampai nginep ngerjain instalasi server linux untuk tugas akhir praktikum segala, tetap ga mudeng. Wish me luck! :D

Update: barusan diajarin caranya supaya bisa sharing koneksi internet dengan maksimal 3 laptop terhubung. Ternyata di Vista cukup bikin Adhoc network, trus Allow sharing internet connection. Ah.. can't wait..

Hard Working Inspiration

Ladies... meet my favorite dancing performer... Lee Min Woo. Just call him M. Lee Min Woo-sshi is a member of Shinhwa group. But I like his solo performance better. His Cool Life, awesome. M is considered short with 175 cm height. His dancers - even the girls - as tall as tiang listrik. But i think that makes him can boost his cuteness. Blessing in disguise. Minbong, that's what friends call him, is also counted as multi-talented and perfectionist. He writes, composes, produces, sings, dances, runs a company and has his own clothing line. The super cute sweatshirt he wore when performing IMU at M!Countdown was awsome. These days, I think he is rushing to accomplish a lot of goals before serving in Korean army on 2009. Wish him a healthy life always.

Hmmm (2)

now that i think about it, we made each other real...
really, because of you guys, i'm real...
take your time, because i'm okay...

Shinhwa - Run

*pingsan karena kata perpisahan yang terlalu keren* :D

Blog Efa

Dede tersayang punya blog. Seperti semua hal penting yang pernah dia lakukan sebelumnya, dia ga tanya-tanya sama saya. Padahal cuma dia, saya dan Allah yang tahu, well sekarang semua yang baca blog ini tau, bahwa si pejuang skripsi nan galak ini gaptek abeess. Selamat datang Dek. Have a nice blogging.

Tali Henpon Baru

Dikasi Pak Ari, hehehe. Ada logo P besar membentuk panah dan nama perusahaan. Warnanya hitam, cool. Yang penting, gratis, hehehe. Bisa digantungin henpon, name tag, kunci kamar kalo mau, hahahhaha. Oh, ya sud dulu, LPG material report belom di koding dengan sukses.