KnightDNA’s Blog 2.0

Halo semuanya,

Kali ini saya akan menulis petunjuk instalasi dan konfigurasi Oracle BI Publisher Enterprise Edition. Berikut ini lingkungan (environment) tempat saya melakukan instalasi. Mohon Anda perhatikan dulu,

LINGKUNGAN INSTALASI

• Sistem operasi: Micro$*ft Wi*dows XP SP3
• Spesifikasi hardware: Intel Core2Duo T8100 @2.10GHz, RAM 2,00GB
• Server: Apache Tomcat 6.0.13
• Versi JDK: 1.6.0 Update 6
• Versi Oracle BI Publisher: 10.1.3.3.2

Berikut adalah langkah-langkahnya,

DEPLOYMENT ORACLE BI PUBLISHER SERVER

1. Periksa folder installer BI publisher
   Pastikan terdapat 4 folder utama: doc/, install/, manual/, stage/, dan Translations/
2. Silakan masuk ke Tomcat Web Application Manager
3. Pilih bagian deploy (WAR file to deploy)
4. Sebarkan (deploy) file bernama xmlpserver.war yang berada di folder manual/generic
5. Apabila proses deployment berhasil maka path /xmlpserver akan muncul di bagian Applications dari Tomcat Web Application Manager

KONFIGURASI REPOSITORI DAN FONT ORACLE BI PUBLISHER SERVER
Setelah aplikasi berhasil di-deploy, silakan ikuti langkah-langkah di bawah ini,

1. Salin (copy) folder XMLP/ dari manual/ ke server; tempatnya terserah Anda, asalkan masih berada di folder Apache Tomcat Misal: <direktori_apache_tomcat>/webapps/xmlpserver (tempat deployment aplikasi .war tadi), atau di tempat lain
   Catatan: <direktori_apache_tomcat> tempat saya ada di D:\apps\Tomcat6\, silakan sesuaikan dengan tempat Anda melakukan instalasi Apache Tomcat.
2. Silakan modifikasi file xmlp-server-config.xml yang berada di <direktori_apache_tomcat>/WEB-INF/
   Akan muncul skema XML sebagai berikut

   
   <?xml version="1.0" encoding="UTF-8"?>
   <xmlpConfig xmlns="http://xmlns.oracle.com/oxp/xmlp">
   <resource>
   <file path="${oracle.home}/xdo/repository"/>
   </resource>
   </xmlpConfig>
   

3. Gantilah atribut path pada tag file dengan path tempat Anda menyalin folder XMLP/ pada nomor 1
   Misal:

   
   <file path="D:\apps\Tomcat6\webapps\xmlpserver\XMLP" />
   

4. Salin (copy) font yang ada pada folder manual/fonts ke direktori font yang dipakai oleh Java Runtime Environment di tempat Anda masing-masing.
   Misal ke: D:\java\jre1.6.0_06\lib\fonts
5. Jalankan ulang (restart) server Anda
6. Sekarang silakan jalankan BI Publisher Server dengan membuka http://<hostname>:<port>/xmlpserver
7. Masuk log dengan akun “Administrator” dan sandi (password) “Administrator”
8. Selanjutnya, silakan lakukan konfigurasi minimal pada server (baca bagian selanjutnya).
   Catatan: demi keamanan, silakan modifikasi akun superuser Administrator tersebut.

Setelah Oracle BI Publisher server berhasil di-install, langkah selanjutnya adalah melakukan konfigurasi minimal, yaitu konfigurasi Scheduler dan Data Source. Konfigurasi hal lain tergantung dari kebebasan dan kreativitas Anda. Silakan baca Dokumentasi Oracle BI Publisher di folder doc/ pada tempat installer Oracle BI Publisher untuk tahu lebih lengkap. Hal tersebut akan terlalu banyak apabila diulas dalam satu tulisan ini.

Konfigurasi Oracle BI Publisher Scheduler

1. Silakan masuk ke bagian Admin > Scheduler Configuration
   Masukkan parameter yang diperlukan, antara lain:
   • Jenis DBMS (yang didukung untuk penjadwalan hanya Oracle/minimal 8i, IBM DB2/minimal versi 6, Micro$*ft SQL Server, MySQL, dan Sybase)
   • Koneksi (memanfaatkan fasilitas JDBC, pastikan Anda sudah memiliki kelas driver untuk masing-masing DBMS)
     Contoh: jdbc:oracle:thin@localhost:1521:orcl apabila menggunakan DBMS Oracle dengan instans (instance) orcl
   • Akun (username) dan sandi (password), pastikan akun ini memiliki kewenangan (privilege) yang cukup untuk melakukan penambahan skema serta transaksi INSERT, UPDATE, dan DELETE record.
   • Kelas driver basis data (misal: oracle.jdbc.driver.OracleDriver untuk DBMS Oracle)
2. Untuk menguji apakah koneksi ke basis data berhasil, silakan uji dengan mengklik tombol “Test Connection”
3. Apabila sudah berhasil, silakan tambah skema untuk scheduler tadi dengan mengklik tombol “Install Schema”

Konfigurasi Oracle BI Publisher Data Source

1. Silakan masuk ke bagian Admin > Data Sources
   Catatan: Perhatikan bahwa ada pengaturan untuk koneksi JDBC, koneksi JNDI, dan File (XML). Umumnya yang dipakai adalah koneksi JDBC atau File.
2. Untuk file, yang didukung adalah file XML, dan untuk menambahkannya silakan klik “Add Data Source”.
3. Masukkan parameter yang dibutuhkan.
   Catatan: Perhatikan bahwa parameter Full Path of Top-Level Directory harus diisi dengan absolut path ke folder di mana Anda akan menaruh kumpulan file .XML di dalamnya.
   Misal: D:\data\xml
4. Untuk koneksi JDBC atau JNDI silakan lakukan langkah serupa dengan masukan file XML
   Catatan: Perhatikan bahwa untuk parameter yang diperlukan pada JDBC mirip dengan langkah konfigurasi Oracle BI Publisher Scheduler, yaitu: Koneksi JDBC, username dan password, serta kelas driver basis data. Jangan lupa untuk memastikan koneksi sudah berhasil dengan mengklik tombol “Test Connection” terlebih dulu. Setelah itu, silakan klik tombol “Apply”.

CATATAN
Segala perubahan yang terkait dengan konfigurasi server akan bisa berjalan setelah Anda menjalankan ulang server.

INSTALASI ORACLE BI PUBLISHER DESKTOP
Setelah instalasi dan konfigurasi minimal Oracle BI Publisher Server dijalankan, maka Anda sudah bisa membangkitkan laporan dengan sumber data yang ada dari data source atau file XML tersendiri. Selain itu ada plug-in integrasi Micro$*ft Office dengan Oracle BI Publisher yang bisa Anda manfaatkan, yaitu Word Template Builder (untuk membuat template menggunakan MS Word) dan Excel Analyzer (untuk OLAP). Untuk memanfaatkannya, silakan install Oracle BI Publisher Desktop dan ExcelAnalyzer yang terdapat di folder instalasi, subfolder manual/XMLP/Tools.

Instalasi bersifat GUI-based sehingga akan memudahkan Anda untuk memasukkan parameter yang diperlukan pada saat instalasi. Silakan ikuti langkah-langkah langsung pada saat instalasi setelah mengklik masing-masing installer tadi.

CATATAN

1. Cara menggunakan Word Template Builder akan menjadi pembahasan tersendiri dan tidak di tulisan ini
2. Oracle BI Publisher Desktop dan ExcelAnalyzer memerlukan platform .NET 2.0 untuk berjalan. Pastikan Anda sudah meng-install .NET 2.0 sebelumnya.

Demikian catatan instalasi Oracle BI Publisher dari saya. Semoga bisa membantu Anda yang memerlukan panduan tersebut. Pesan saya, tetap gunakan aplikasi legal dan jangan terjebak pada fanatisme penggunaan teknologi atau kakas tertentu. Mohon koreksi bila Anda menemui kesalahan pada tulisan di atas, atau ada bagian yang kurang lengkap. Silakan isi bagian komentar apabila Anda ingin berdiskusi dengan saya. Terima kasih dan semoga hari Anda menyenangkan selalu!
-KnightDNA-

Halo semuanya,

Di awal Juli ini saya akan menulis artikel tentang Oracle BI Publisher. Mohon maaf, janji saya pada post sebelumnya tentang data warehouse belum bisa saya penuhi sekarang karena tulisan tentang data warehouse sifatnya sangat konseptual dan rupanya cukup njelimet (rumit) dan malas juga untuk menyusun tulisan tentang data warehouse agar mudah dibaca dan dipahami oleh pembaca, . Baik, kali ini saya akan langsung membahas tentang salah satu bagian dari pembangunan data warehouse, yaitu reporting system, utamanya tentang kakas (tool) yang saya gunakan pada saat kerja praktek ini yaitu Oracle BI Publisher.

Sebaiknya, Anda mengetahui dulu keterkaitan antara data warehouse dan reporting system. Kalau Anda sudah tahu, silakan lewatkan (skip) paragraf ini untuk beralih ke paragraf berikutnya . Data warehouse (bagian yang lebih detail dan teknis ada di post yang lain ) dibuat dengan tujuan untuk melakukan analisis terhadap data historis yang dimiliki oleh suatu organisasi (umumnya korporat), dan analisis ini digunakan sebagai penunjang keputusan atau kebijakan yang akan diambil oleh perusahaan. Nah, hasil akhir dari analisis data historis tadi bisa berupa berbagai laporan yang ditujukan untuk kalangan eksekutif perusahaan (umunya top level management). Contoh: Laporan hasil penjualan produk XXX (jangan ngeres dulu ya… ) di seluruh Indonesia yang akan ditujukan untuk manajer pemasaran PT XYZ. Laporan ini nantinya bisa dilihat lebih detail per provinsi (misalnya), atau per kabupaten, sehingga sang manajer pemasaran bisa tahu tren pasar secara hierarkis (dari nasional ke aras/level di bawahnya) dari laporan tersebut. Dari situ akhirnya sang manajer bisa memutuskan langkah perusahaan ke depan terkait dengan strategi pemasaran produk tersebut. Got the point?

Salah satu kakas (tool) yang cukup andal dalam masalah enterprise reporting system ini adalah Oracle BI Publisher (dulu bernama XML Publisher, karena data mentah keluarannya berformat XML, bahkan hingga saat ini). Ada beberapa kelebihan tentang kakas ini, yaitu:

1. Terintegrasi dengan Micro$*ft Word, jadi, pengguna enterprise reporting system bisa melakukan pembangunan template laporan menggunakan kakas dokumen produksi Micro$*ft yang mudah dipakai dan mahal ini. Yang perlu Anda catat, Word Template Builder ini perlu platform .NET 2.0 agar bisa digunakan.
2. Mampu mendukung pengiriman lebih dari satu channel (web, FTP, e-mail, faks, printer).
3. Mampu mendukung format keluaran yang bermacam-macam (XML/mentah, HTML, MHTML, PDF, CSV, PPT).
4. Menyediakan fasilitas penjadwalan untuk pengiriman laporan (sepertinya ini merupakan standar dari suatu enterprise reporting system).
5. Menyediakan layanan web service, sehingga fasilitas pembangkitan laporan bisa dipanggil melalui aplikasi lain.
6. Mampu mendukung template animasi Flash, jadi laporan yang dibuat bisa menjadi laporan yang menarik dan interaktif.
7. Mampu mendukung berbagai sistem manajemen basis data (RDBMS); tidak terbatas keluarga Oracle saja. Anda juga bisa mengambil data yang berada pada RDBMS MySQL, dan RDBMS lain asalkan didukung oleh Java Database Connectivity (JDBC) . Satu lagi, Anda bisa langsung menjadikan file XML sebagai sumber data, asalkan skemanya sesuai. Pembahasan tentang skema XML ini masuk ke bagian teknis, dan tidak akan dibahas di sini.

Baru 7 hal tersebut kelebihan Oracle BI Publisher yang saya ketahui sejauh ini. Saya belum pernah membandingkan aplikasi enterprise reporting system yang lain, jadi pendapat di atas masih kurang objektif. Harap maklum saja, sebelumnya saya hanya mendapatkan teori dan konsep saja pada saat kuliah .

Sementara itu, beberapa hal yang menurut saya “kurang” dari kakas ini adalah tentu saja dari segi harga . Yup, Oracle BI Publisher memang termasuk golongan aplikasi proprietary yang biasa dipakai kalangan korporat. Tapi tentu saja kocek dan kemampuan menurut saya sudah cukup sebanding. Hehe, beruntung juga saya bisa mencoba satu contoh kakas mahal secara legal.

Apabila Anda tertarik untuk melihat aplikasi Oracle BI Publisher, silakan kunjungi halaman resminya, dan apabila Anda ingin tahu lebih banyak tentang cara penggunaannya, silakan kunjungi blog Oracle BI Publisher.

Sampai di sini dulu tulisan pengantar dari saya tentang Oracle BI Publisher. Sampai jumpa di tulisan selanjutnya tentang langkah instalasi dan konfigurasi Oracle BI Publisher. Saya berencana untuk mempublikasikan banyak artikel seputar kerja saya di sini, termasuk tentang Oracle BI Publisher . Terakhir, mohon koreksi apabila Anda menemui kesalahan.

-KnightDNA-

Hi all,

Today is actually like a free day for me. No tasks are needed to be done in this day, because all of the task in this week were all accomplished yesterday (actually they were being done perfectly today at the dawn… ).

Just like my previous post, which said that I often played with SQL aggregation queries as my job was developing Enterprise Reporting System of PLN Disjaya, and due to my idle job for today, I will post some query example on each week (Note: all the queries shown below are not used on the real application as they have been refactored and all of the fields, schemas and the table names will be camouflaged, except for the Oracle OLAP).

Sequel 1:

This is on the first week, when my jobs were actually just exploring the company’s framework and installing the tools needed for the project, therefore the queries are not so complicated. Oh, yes, I remember that I was also involved in KPU (Indonesian General Election Committee) Logistics Information System project and my job at that time was generating all of Distribution Cost Reports. So, here is one of the former query example

SELECT
SUBSTRING(a.fromcode, 1, 2) AS prov,
SUBSTRING(a.fromcode, 1,5) AS kab,
b.nama AS area,
COUNT(id) AS countarea,
FORMAT(AVG(biaya), 0) AS avgbiaya,
FORMAT(SUM(biaya), 0) AS sumbiaya
FROM xxx AS a
FULL OUTER JOIN(yyy AS b) ON (SUBSTRING(a.fromcode,1,5) = b.code)
WHERE substring(fromcode,1,2) = :prov
AND type=34 GROUP BY kab ORDER BY b.nama ASC

Not too complicated, right?

Sequel 2:

The query written below is on the second week, when I was exploring the Oracle BI Publisher. I just use the example schema on Oracle OLAP Cube, and make sure that the Oracle BI Publisher can execute any of OLAP query (e.g.: ROLLUP, CUBE, etc.). What are the usage of each OLAP query? I will explain it on the other post.

SELECT
CUST_GENDER,
CUST_FIRST_NAME||CUST_LAST_NAME,
PROD_PACK_SIZE,
PROD_NAME,
FISCAL_YEAR,
FISCAL_MONTH_DESC,
DAY_NAME,
SUM(QUANTITY_SOLD) AS QUANTITY,
SUM(AMOUNT_SOLD) AS SALES
FROM SH.SALES a, SH.CUSTOMERS b, SH.PRODUCTS c, SH.TIMES d
WHERE
a.CUST_ID = b.CUST_ID
AND a.PROD_ID = c.PROD_ID
AND a.TIME_ID = d.TIME_ID
GROUP BY
ROLLUP(CUST_GENDER, CUST_FIRST_NAME||CUST_LAST_NAME),
ROLLUP(PROD_PACK_SIZE, PROD_NAME),
ROLLUP(FISCAL_YEAR, FISCAL_MONTH_DESC, DAY_NAME)

Sequel 3:

This is the query on the third week, when I make one of the reports. I use the query below to define the dataset for the report that being mapped from Excel Spreadsheet report. In the third week, Danang and I create four different reports and for each reports there are two different templates that can be generated into different output formats (e.g.: XML, HTML, PDF, or Flash Animation (.SWF)).

SELECT
CASE WHEN LENGTH(D.TIMEDETAIL) = 5
THEN SUBSTR(D.TIMEDETAIL, 1, 1)
ELSE SUBSTR(D.TIMEDETAIL, 1, 2)
END AS MONTH,
CASE WHEN LENGTH(D.TIMEDETAIL) = 5
THEN SUBSTR(D.TIMEDETAIL, 2, 5)
ELSE SUBSTR(D.TIMEDETAIL, 3, 6)
END AS YEAR,
DL.UNITUPNAME AS NAME,
SUBSTR(D.TARIFFTYPE, 1, 1) AS TYPE,
D.TARIFFTYPE AS TARIFFTYPE,
D.SUBTARIFFTYPE AS SUBTARIFFTYPE,
SUM(D.TOTALCUST) AS CUST,
SUM(D.TOTALERG) AS ENERGY,
SUM(D.KWHLWBP) AS LWBP,
SUM(D.KWHWBP) AS WBP,
SUM(D.KWHKVARH) AS KVARH,
SUM(D.KWHLWBP) + SUM(D.KWHWBP) AS TOTALKWH,
SUM(D.IDRCHARGE) AS IDRCHARGE,
SUM(D.IDRUSE) AS IDRUSE,
SUM(D.IDRKVARH) AS IDRKVARH,
SUM(D.IDRCHARGE) + SUM(D.IDRUSE) + SUM(D.IDRKVARH) AS TOTALCOST,
CASE WHEN SUM(D.TOTALCUST) = 0
THEN SUM(D.IDRKVARH)
ELSE SUM(D.IDRKVARH) / SUM(D.TOTALCUST)
END AS IDRPERC
FROM SSS.AAA D, SSS.BBB DL
WHERE D.TIMEDETAIL = :month||:year
AND D.UNITUP = DL.UNITUPCODE
AND DL.UNITUPNAME = nvl(:unitup, DL.UNITUPNAME)
GROUP BY D.TARIFFTYPE, D.SUBTARIFFTYPE, D.TIMEDETAIL, DL.UNITUPNAME
ORDER BY D.TARIFFTYPE ASC, D.SUBTARIFFTYPE ASC

Sequel 4:
There are not too many differences with the third sequel, but in this week I often use them as the VIEW for the report generation. Now I know what the real function of VIEW creation for the programmer/application developer: it will be easy to code the application when there are substantial schema changes on the relation. Therefore, the programmer will just have to refactor the VIEW, not the application code. Totally, I create about 10 views for the report on this week. (Sorry, I cannot explain the code right here )

Actually, there are one general aggregation report, but it must be able to be drilled down in order to be viewed detail (e.g.: the finance manager can view the financial report of the company on the province level and also the financial report on each branch on regencies/cities in the province by detail). I will discuss the topic about OLAP and Data Warehouse which are related with this thing on the other post. So, where are the DIMENSION, MATERIALIZED VIEW, and another OLAP related objects? Maybe, I will really meet those “demons” at the beginning of the forthcoming week. Sniff, sniff… I guess this is the effect of underestimating the Database System lecture at the Sixth Term. Arrrgh! I beg your mercy SBD (Indonesian version of DBS lecture’s abbreviation). I am currently being cursed by that lecture… . Fortunately, there is another interesting goody namely Flex in my project , therefore I have not to feel frustrated by those sequels of SQL. I will also post it on the next chance. See you and have a good day on your weekend!
-KnightDNA-

Hi all,

After hibernating on keep my blog up to date, I will write a post again. Umm, I guess it has been more than a month since I wrote the last post in this blog. Okay, now what is currently the hottest topic in my mind which is seemed interesting to be written in this blog? Of course my - and also the Informatics ITB 2005 university students’ - obligatory activity on the holiday between sixth term and seventh term. It is Industrial Practice. Gosh, I suddenly remember that I have spent 3 years on studying in this lovely campus…
So, back to the topic: Industrial Practice. Where do I work on my industrial practice activity? I and my companion, Danang Arief Setyawan, will spent our industrial practice activity with working on PT Akhdani Reka Solusi (ARS), a software house located on Cikutra Baru, eastern part of Bandung City. Please do not ask me why I choose to spend my industrial practice here, because I and Danang just think simply: no more effort and expenditure on looking for boarding house, and other daily needs when we work here, and also no needs to go for work on 5.00 a.m. and leave for home on 9.00 p.m. (no offense to the citizens of Jakarta). The main point of the industrial practice is that I can get the real situation of the work within the Informatics environment, so no matter where do I work, as long as I can get that main point, it will be okay. My boss also tell me about that. Finally, I have to say that I really love living here, in Bandung City.
The working hour in ARS is not strict. As long as your jobs have been done well with their deliveries, it is okay and you are marked as doing the jobs well by your boss. No needs to come to the office on time at 8.00 a.m., leave for home exactly at 5.00 p.m., and work constantly during that time. Informatics jobs or IT related jobs are project-based jobs, therefore no strict working hour, moreover inspiration could come anytime, anywhere, even outside of your working hour, and your working hour is not always be your best time to finish your jobs. My boss also said about that in the beginning period of my work. For your information, my boss is the former president of Informatics Student Body (HMIF). He led the student body five years ago. Guess who is his name?
This is my main topic of my industrial practice: Enterprise Reporting System Development in PT PLN Jakarta Raya and Tangerang Region (PLN Disjaya). Why do I say “main topic”? Because actually there is another project of my company during my industrial practice period. It is Logistics Information System Development of National Election Committee for 2009 General Election (SI Log KPU). Huff, okay… just like the Javanese proverb “Rawe-rawe rantas, malang-malang putung” (dismiss any obstacle in front of us, CMIIW), I will do exactly the same as it be.

So, what were my activities in the first week of industrial pratice? Here is the answer. In the first week, Danang and I did the exploration of my company’s web application framework, namely Leaf (Leaf: Leaf Application Framework) written in PHP and using MySQL as the DBMS. Both of us were assigned to make new application using that framework and it had to be presented to the board director of the company at the weekend period together with the weekly review with the supervisor. I made the web based log activity (e-Log), while Danang made the web based address book. Beside exploring the Leaf, we had to install, configure, and sightseeing the tools needed for the forthcoming week activities: Oracle DB 10g Relese 2 Enterprise Edition, Oracle BI Publisher, Adobe Flex Builder 3.0. Do not worry, all of those tools are being used legally as PLN Disjaya pays the license for those all. Finally, I can feel using Oracle and Adobe’s products legally
There was another activity at the weekend. Precisely, it was done on Sunday, June 9th 2008 started on about 12.00 p.m. My supervisor asked me to join the overtime work of SI Log KPU at that day. Oh, God! That day was Sunday! Okay… I had to obey that assignment… So, after picking my special friend up at the Bandung Train Station after returning from her holiday at the morning, I went to USDI ITB located on Annex Building directly.

I did the Distribution Module of SI Log KPU from the total of 4 modules (Planning, Distribution, Inventory, and Monitoring). My job was creating three reports: Distribution Report at National Level, Province Level, and Regency Level, - which templates existed in the Excel spreadsheet file given to me at that time - therefore I had to play with SQL aggregation queries at the application. Due to my over-focused on doing Computer Graphics on sixth term - so, I rarely played with SQL Aggregation Query and also another advance SQL query - I felt rather confused and being unaccustomed. As the result, the jobs that actually could be done in about 2 or 3 hours, had to be finished successfully and completely at about 8.00 p.m. . Later, one day after the job, I still had to refine my job as my another supervisor reviewed my job and gave some suggestion for the refinement, especially on the weak performance of the report generation time. He then criticized me of my DML at the application. “What did you get from your Database lecture?”, he asked to me at that time. Finally, the page generation time was much more faster. Anyway, thank you very much, Sir, for your criticism. I have learned so much tips and tricks from you and now I am getting more familiar with those things…
That is all of my stories in my first week of industrial week. I will continue my post on the story of industrial practice in the second week.

Good day to you all…
-KnightDNA-

Hi all,

Finally I can update my blog again after hibernating for a long time . Yeah, this term (for me it is currently sixth term) is the busiest period for Informatics’ students in ITB as you may see in my previous posts, and it has made me deeply involved in doing every tasks which are seemed to come continuously without break. I am keen admire on my friends who are still able to do some great things in this period, e.g. following Imagine Cup or the other national competition. I just wonder how they manage their time and energy. What a great effort! I wish I were an amoeba who can separate my own body to do all the things I have to do .

Now, finally, next week, this all crazy things of this term will be over, but this sixth term will be my unforgettable and also tremendous experience. There are a lot of things that I can get and learn. I can learn the way to manage all of my resources to finish all of my tasks, as I also have another responsibilities outside of my academic life in Informatics ITB. This is like a warming up and preparation for the real thing outside (it is seemed). Well, I would like to say thank you very much for all of my companion in Chocobeans: Ume (all hail project managers!), Iqbal (all hail coders!… ), Made, and PAW (all hail analysts!… ). Umm, Metta? (all hail too… :P). Yup, for all of combatants in sixth term… Do not let our experience be lost. For my friends in Informatics 2006, which will follow the new curriculum, good luck to you all in the forthcoming academic terms. Maybe, in the sixth term, you will not be as busy as us (by seeing the subjects of the curriculum, especially when one of the “main subject” in the sixth term is not being an obligatory subject again ).

In the next posts, I would like to share all of my experience in this sixth term: exploration, and the other interesting things. And last, just wish my luck in my final test and also my industrial practice starting on June 2nd!

-KnightDNA-