SQL Server 2005 : Create Database

  • Select Start > All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio
  • Connect to Server using Windows Authentication

  • Connect to Server using Windows Authentication

  • Right-click on Databases. Select New Database…

  • Type Database name. Click OK.
  • The database will be created successfully.


Logon to Essbase Using Essbase MaxL Shell

We can logon to Essbase using various ways. One of them is using Maxl script. This way used because we want to export linked reporting object data. To logon to essbase, follow these steps:

  • Open command prompt
  • Type essmsh and enter. We will jump into MaxL Shell.


  • Before we logon to essbase and we try to query export database, the error will prompt.


  • To fix it, logon to essbase using script :

MAXL > login <HSS user> <HSS Password> on <server name>;

For Example :

MAXL > login admin password on localhost;


  • We already logged in to Essbase.

Linked Reporting Objects

If you are upgrading from an earlier release and an application has more than 127 linked reporting objects, perform the following procedure to export linked reporting objects before you run the Staging Tool.

Tip:  To determine how many linked reporting objects an application has, use the MAXL command query database DBS-NAME list lro all;,

for example, MAXL> query database sample.basic list lro all;


Chapter One : Myself

Allysha gets down from her luxurious limousine in front of a Girl Dormitory. She opens her black lens glasses while she’s starring at the big building. Starting next week, she’ll stay here. This building has six floors. Four floors to stay, fifth floor to do laundry, and sixth floor for water saver that flows around the dorm. The garden in front of the building is so beautiful with cutted-grass on the left and right side the building. There’s also an extensive parking area. Allysha only standing on the park, she don’t enter the dorm.

“How’s it, Lady?” asked Mr. Yayat, an oldman with gray hair and mustache. He’s one of the the accomplice Allysha’s Family.

“Good,” answered Allysha without any expression. “The size of the room?”

“Four meter square, Lady.”

“Another facilities?”

“Bed and the wardrobe combine with the desk for studying.”

Allysha a little bit surprise when she listened to the room facility was out of her thought. “How about the bathroom?”

“The bathroom is outside the bedroom. There four sharing bathrooms behind the kitchen. Only a shower and toilet inside.”

“Hot water and bathtub?”

Mr. Yayat shook his head.

Allysha grumbled. “No way. I don’t want to stay in the place like this!!” she’s furied. “I need to talk to my brother. We go home NOW!”

Mr. Yayat and the other accomplices obey Allysha to take her home. Allysha is Salman Al-Farishi’s daughter, an entrepreneur and also an owner of the one of the biggest Petroleum Company in the world. He also one of the richest man in the world. From her name, we know that she was a descendant of an Arabian whose skin so brightly white, pointed nose , brown eyes, and using veil. Her parent died since she was a little. Her Dad died because of sickness two years after her mother’s death. Unfortunately, she never remember why did her mother died. Perhaps, because of that day, Allysha still very young.

Allysha live with her big brother, Muhammad Haekal Al-Farishi. Haekal inherits all og his father’s company. Like a King, he has a private accomplice who manage everything he needs include company. Haekal just monitor his company cash flow from home or come to the office occasionally. He trusted his accompliace badly. Also, he has to look after his lovely sister, Allysha.

Allysha arrived at her home. The house like a big castle in the middle town. The garden is so big and full of flower planted orderly by the gardeners. The house has two marble floors and the fishpond with the beautiful fountain in the middle of first floor. House furniture almost all imported from Europe. There’s a big luxury crystal lamp hang on the center of the house. Allysha’s arrival always welcomed by six maids who open the door.

“Where’s Bang Haekal?” asked Allysha. (‘Bang’ used to address big brother in Indonesian way)

“Still having lunch, our Lady.”

Allysha walk directly to the private dining room. Her house has two dining rooms, one for entertain the guests, one for private. The dining room for guest can entertain up to one hundred guests, however the private dining room only have four chair for their family. When their parent still alive, that four chairs full of family member. Now, only two left.

The maid open the dining room door. Allysha seeing her brother still having lunch. Mr. Iqbal and Mr. Irham stay beside him. This two accomplice have the same position as Mr. Yayat.

“Bang,” called Allysha a little bit angry.

Haekal look up, “Already home? How’s the dorm?”

“The room only four meters square?”

“Then?” Haekal still continuing his lunch.

“Ouuh, come on. That room even smaller than my bathroom, Bang. I can’t sleep there!”

“Well, the most important is there’s a bed and wardrobe. So you still can sleep.”

“Why don’t you let me stay in the Hotel?”

“Your room here far better than in the Hotel.”

“But, if the room was so small?”

Haekal gulp the water in the beautiful shot glass. “Allysha, I let you to stay there not because you can play around. But, to look for friends.”

“There’s some friends in Hotel,”

“But there’s no friends at your age. In the dorm, you’ll have friends at the same academic field and faculty as yours.”

“I don’t even care,”

Haekal hit the table. “If you don’t wanna listen to me, then you don’t need to continue your study at the public university. You study at home as you always done. HOW?”

Allysha shocked, she shook her head quickly. Since in the elementary school until high school, she had home-schooling. Mr. Yayat, Mr. Irham, and Mr. Irham invited best teachers to teach Allysha. Allysha has the black side inside her body. Since her father died, there’s no people control Allysha tightly. Like former Al-Farishi descendants, Allysha has the ability to summon the ‘Guardian’ from the other dimension.

“I’m still worry about you. It’s impossible if I have to keep eye on you every moment of your life. You need to have some friends to protect you! At least, to control your emotion. Understand?!”

“Yes!” Still fury answered. Allysha directly go outside and enter her room. Sometimes, she resentful to see her brother always angry. She’s not a little girl anymore and she can protect herself. Why she always being looked after people?

“Your highness, is it OK to angry with Lady Allysha like before?” asked Mr. Irham as she pour the water into Haekal’s glass. He still so simple as always. His thought always step ahead. “It looks like Lady Allysha very angry.”

Haekal gulp the water, “It’s OK!”

Mr. Iqbal give handkerchief to Haekal. “I think, once a while she need to be assertively warned so she not always being spoiled. I agree with your action before, Your Highness.” He always so straight forward about everything.

Mr. Irham and Mr. Iqbal are twin brothers. They are Mr. Yayat’s brother. They are Al-Farishi’s loyal accomplice and also bodyguard. They trained Allysha and Haekal how to control the Guardian and teach martial arts. They followed Al-Farishi’s family since they were young ‘till their half century ages like now.

Mr. Yayat enter the dining room. “I’m sorry Your Highness, looks like I failed to convince Lady Allysha to move to the dorm.”

“It’s OK. I scolded her. Whatever it takes, she has to move to the dorm. That’s all we need, right?”

Compared to Mr. Iqbal and Mr. Irham, Mr. Yayat understand a lot about everything in Al-Farishi’s Family. Haekal make Mr. Yayat like father himself. He always discuss all the problems from small to big with Mr. Yayat. Mr. Yayat also the one who suggest Allysha to move to make she socialize.

“But Your Highness, are you sure Lady Allysha won’t make any problem?” asked Mr. Yayat. “Are you sure that Lady Allysha can control herself not to summon Guardian?”

“For that matter, honestly, I’m not sure. But, if we won’t try, we don’t know the result, right?” answered Haekal.

“How if one day Lady Allysha thinks to kill her friends?” asked Mr. Irham.

“I’ll prevent it,” answered Haekal as he gulp the water. “That’s why Daddy inherited his power to me.”


Allysha dash her body down on the luxurious fluffy bed. She’s looking around her room. Soon, she’ll leave this room. She’ll lost every luxurious facility in her room, dressing table, the big wardrobe that almost close all of her room’s wall, AC, Home Theatre, bathroom with bathtub and hot water, etc.

Allysha wake up. She’s whispering within her heart to summon the Guardian. During this time, Allysha’s friends only Guardians. That’s the thing makes Haekal worry most. She summoned Iee water guardian, Angén wind guardian, Apui fire guardian, Qylat thunder guardian, dan Bumõ earth guardian. They are five element guardian which often summoned by Allysha.

“I’ll move from this house next week,” said Allysha.

Iee’s appearance like a small little girl with two wings on its back. Its body’s color is blue. Its power related to water, ice, and snow.

Angén’s appearance like a rabbit doll and its deer face. Its body’s color is green. Its power related to wind.

Apui’s body color is red. Its appearance like a lionet and it has burning eyes. It power related to fire.

Qylat’s appearance like an armored man. The body’s color is black and it can summon thunder.

Bumõ’s appearance like an oldman whose beard’s long touch the ground. It can create an earthquake.

All of guardians summoned by Allysha only in a small shape. They transform into the monstrous thing if there’s a battle. Until now, there’s nothing happen to make them transform to the real shape. The world still so calm.

“Maybe I defend myself not to summon you all, except I was surged. So, I beg you all not to come into the real world carelessly when I stay in the new place. You can’t play around as free as here when I move. In my new house, there’s so many strangers that you all never meet before. You need to standby.”

All of the guardians nodded. Then they’re disappeared. Allysha lay down again on her bed. Unintentionally, her eyes spot at a picture hang out below the clock. There’s Mom, Dad, Allysha, and Haekal with big smile on their face. That time, Haekal still in the third grade of elementary school, while Allysha first grade. The background of this picture was a lake. Allysha never knew when did the picture taken. But, they were so happy there.


Haekal enter his room with Mr. Yayat, Mr. Iqbal, and Mr. Irham. In this room, usually Haekal monitor his company grow. The semester holiday will be ended soon, he’ll going to the university. He has to do all his work and make sure it’s all done so he can concentrate to his study completely. He is typing and signing some documents right now.

“Mr. Iqbal, you can meet all of the foreign investor tomorrow! Tell them that I only invest to the company that gives revenue at least three times a year.” Haekal gave some documents to Mr. Iqbal.

“Ok, Your Highness!” Mr. Iqbal directly headed outside the room.

“Mr. Irham,” called Haekal. “Tomorrow you have to go to Japan. Please investigate the hospital in this document. If it’s good, buy their stock!”

“Ok, Your Highness!” Mr. Irham also directly headed outside the room.

Haekal sighed. Finally everythings done. All of the work he gave to Mr. Iqbal and Mr. Irham. Both of them are the Al-Farishi’s intelligent and very smart accomplice.

Mr. Yayat gave a hot sweet tea to Haekal. He sip it. The tea made by Mr. Yayat for him is the one best homemade tea ever. It can warm up our soul.

“Thank’s Mr. Yayat!” said Haekal.

“Is there anything disturb your mind, Your Highness?”

“Allysha…,” answered Haekal softly.  “She called five elements few moments ago.”

“It’s not a wrong thing. Just to say goodbye.”

“That’s not the matter.”


“Allysha still drown into the other dimension. Can she become the normal human like others? I worry about this.”

“It’s OK. Lady Allysha still very cool to others. But she never done anything wrong up ‘til now right?”

Haekal is starring on his father’s picture on the table. “If he still alive,” whispered him. “It’ll become a very easy thing for Daddy to handle.”

“But you are Salman Al-Farishi’s son. You’ll become as powerful and also strong as your father. Or, maybe more.”

“Who knows…”

end of chapter one

No water in The Office

Suddenly, in my office, there’s no water. That big-fabulous-cool-building, but no water. Because the AC effect, my body easy to get dry so i always drinking so much water and go to toilet. But because of no water, i have to drink as little as i can, or i have to go to the toilet in the nearest eye-hospital (actually beside my office). Maybe the security there surprised, why the hell that so many people from left building going to this hospital’s toilet??
Hopefully, tomorrow the well underground will be repaired, so the water pump will stay ON and i don’t have to go too far just looking for the toilet.

Rental House

I was looking for a house to rent in Kuningan, south Jakarta. But this isn’t for me, for my cousins. My auntie asked me to help because i live nearby. You know, because south jakarta is a business district, the cost of a house to rent is so expensive, between Rp. 30 million to unlimited. I walked down the road, turn left and right, but i didn’t find the house which the price is relevant to me. Even i asked the price of one small-bad-house was 1.6 billion rupiahs. HAH!!!
Now, almost everythings expensive. God, heeelp!!

The Training

I met new people in the office. They’re so nice. And I’m grateful that I have young partners. You know, in my imagination, office is always like my father’s n the place where I had my internship. So many people, hundred or thousand people in one office. But here, we’re only 28. IT Consultant office is always fun, young, energic, and fabulous. We can go to the client site and not always staying in the office. We can travel to the other island or country just to fulfil the client’s need.

I am a Hyperion Consultant in one of the best Hyperion company. Now, I’m still in training to become a very competent consultant so I could solve every client needs about Oracle and Hyperion. You know that Oracle has acquired Hyperion, a leading provider of performance management software. The transaction extends Oracle’s business intelligence capabilities to offer the most comprehensive system for enterprise performance management. I learned so many things like I continue my study to get the master degree. It become very interesting day by day when I have to deal with somekind of software I never learnt even heard before. We’re not only study in college, but everywhere.

This Handsome

It seems like the characteristic and the behavior of the rich handsome man like Jun Pyo is appear in this world. He:

1. ran a company,

2. an inheritance from his parents,

3. well known in the world,

4. got so many award,

5. the business cost thousand dollars,

6. the most handsome man

7. the attitude is so like a Go Jun Pyo.

However, I never thought to become like Gem Jan Di. I scare if in the reality, it’ll become upside down. Let it flow…


In case, I talked to my friend when I was in the train trip to Jakarta. We talked about something about ‘human’s feeling’.  I spoke to him about so many women nowadays very care about others feeling but not me. Why? I’m also woman. But, why I don’t care about others?

Actually, this is a misunderstanding. Some people might looks well outside, but fragile inside. People can show so much care to everyone, but some people not (include me). I’ve felt broken heart, sad, happy, angry like others but not to show it directly. Just in my opinion :

1. Cool people : They’ll listen. Sometimes hard for those people to give feedback or to comment what you’re talking about. But they do remember a lot. They never miss a thing you told them.

2. Care people : This people is very good to talk. They are good listeners. But sometimes they give a lot of opinion that upside down from the reality.

3. Smart people : They’ll give so many logic in the feedback. You know that feeling is something beyond logical thought.

4. Happy people : They always cheering people when they down and also when they happy.

So, who are you guys?

Broken Heart

Friends, this post can be related to you, me, or to the people in the world. I want to post this story not because I’m in the broken heart mode : ON. It’s just because this story reminds me about so many things.

When you have a boy/girlfriend in your side, maybe you’ll feel everything belong to you two. You’ll spend everything together day and night. But, have you ever think if someday you’ll have the broken heart thing?

Once, I asked my friend where she wanna go because I saw her well dressed. Usually she have dinner with her bf. But, when I heard that she broke up with her bf , I was shocked. They were in a relationship for 4 years maybe. And now end up like nothing in 4 years happen. Oh my God!

You know, when I broke up with my bf, the lovely one, it seems that the world became so much boring. formerly, when I got money, I’ll call him to eat somewhere. When I didn’t understand the lesson in the class, I’ll call him to teach me. When I heard the news or gossip, I reach my phone again just to let him know (however it’s not an important thing). When I can’t sleep well in the night, I call him just to accompany me by listening his voice. When I was sad, he’ll listen to my story. And so many beautiful stories that I can’t tell you one by one. It really hurt when everything over. It’s just like my hand unconsciously reach the phone to tell him everything but when I realize, I just can shed my tears. We discussed about our dream in the past, but we can’t make it true together like we promise.

You know, friend and time can heal the wound. I spend almost my time by chatting and hangout with my friend and try not to remember about the past. However when I saw him in the school with the other girl, the world seems like a nightmare.

You can tell about your broken heart story here! I’ll listen to it.