[OBIEE] [QlikView] Tapping OBIEE Security for Qlikview use | Convert OBIEE Security to Qlikview understandable-format Security

OBIEE security mention here is referring to object based security (securing the OBIEE presentation column)
Qlikview security mention here is referring to section access.

Background:
OBIEE is a BI tool from Oracle.
Qlikview is also a BI tool, but from different company, named QlikTech.
The requirement to tap/convert OBIEE security to Qlikview security is not really a common one, but it does happen to me during my project.
The OBIEE is setup to secure the object (object based security), and all the settings is setup manually on the repository itself and not pointing/coming from any database

The method here is working and tested for:
OBIEE 11g

In summary, here's how to convert the security:
1. Extract security access based from OBIEE repository
2. Extract user and group list from WebLogic
3. Convert security access from OBIEE security to CSV format
4. Reverse the security access
5. Convert user and group list from WebLogic to CSV format

Details will be updated later.

[iOS] Turn off cellular data usage for certain apps

Using iOS 7, now you can configure which app you allow to use your cellular data usage.

If you are:

- having limited data plan each month

- afraid of your monthly cellular bill for data plan explode

- just don't want to use cellular for certain apps, such as App Store app to download new application

Here's what can be done:

1. On your iOS device, be it iphone or iPad, running iOS 7, look for Settings and open it.

2. Navigate to Cellular menu.

3. Scroll down until you find "Use Cellular data for:".

4. Choose your app and turn off for those you don't want them to access your cellular data.

5. Done. 

Now you can avoid any unwanted cellular data usage and save your bandwidth and monthly bill.

For me myself, I turn off cellular data for  following app:

- App Store 

- iTunes Store 

- passbook 

What happen then, if let say cellular data for App Store is turned off and somehow you need to browse/download from the app? Will it show any error or what? What if I forgot the list of app that I forbid from using cellular data?

Don't worry be happy. Apple does that for you.

The app will prompt you with warning and asking whether you want to go to setting to activate cellular data for the app. Click "Settings" if you want to reconfigure your cellular data setting or click "Ok" if you want to keep it from using your data.

[iOS] Delete iCloud Account without entering password | Turn off Find My Iphone without entering password

This post should be treat as educational purpose only.

If you are using iCloud and have the Find My Iphone turned on, you must already know that once you enable it, whenever you want to disable Find My Iphone for whatever reason, you must supply a password - your iCloud password or Apple ID password that is used for iCloud.

But according to Youtuber, Miguel Alvarado, there is actually a way to bypass entering the password when the Find My Iphone wants to be removed or iCloud account wants to be removed.

The method is simply, to disable Find My Iphone and click on Delete Account at the same time, causing the interface to -something like get confused- prompting both iCloud password and confirmation to delete the account.
When that happen - interface got confused- switch off the phone and switch it back on. Then go to iCloud settings again, to see that Find My Iphone is turned off already - YES without supplying a password - and click delete the account one more time to really delete the iCloud account.

For details, you can check his video here:
http://www.youtube.com/watch?v=Lvbter05UpA

Best Cheapest Prepaid Data Plan in Singapore

Planning to go to Singapore and looking for temporary data plan?

Or you stay in Singapore and want to have the most affordable data plan?

Here is the guide based on my personal experience:

First thing first, I would like to share my habit related to the data plan.

- I only use data at max 200Mb/week

- I rarely browse facebook 

- I sometimes browse forums

- I quite often browse news using FlipBoard and reddit

- I rarely download application using cellular network unless it's really urgent 

- I rarely watch YouTube using cellular network

So if you have almost the same criteria with me, this guide is for you.

From the 3 operators, so far Singtel offers is the best to suite my needs.

It has multiple data plans but the following data plan is the best to suite my needs:

1. 1GB for 1 week for $7

2. 10MB for 1 week for $1

So does that mean if I want to have a data plan for 1 month(assuming 1 month is 4 weeks), I need to pay $7 X 4 times?

The answer is: No.

Here is what makes it the cheapest:

Assuming today is Jan and Jan is having 4 weeks.

So what you need to do is:

Jan week-1: Subscribe the $7 data plan and you get 1GB for 7 days

Jan week-2: subscribe the $1 data plan and you get ADDITIONAL 10MB and ADDITIONAL 7 days which means, if let say on the first week you have finished 200MB, on the second week you will have 800MB (from first week) + 10MB (from second week). So in the second week you have 810MB

Jan week-3: subscribe another $1 data plan and you will get ADDITIONAL 10MB and ADDITIONAL 7 days. If let say in week 2 you have finished another 200MB (so in total you have spend 400MB), then on the third week you will have 610MB (remainder from the second week) + 10MB (from third week)

And the next following week and month you just continue to subscribe the $1 data plan until eventually you spend the whole data plan.

From the illustration above, for Jan I only spent $11 ($7 week 1, $1 for each week 2,3,4) and assuming on feb i didn't do much browsing, I can sown only $4 for my data plan ($1 for each week 1,2,3,4).

[JAVA] [CODE] How to Pass Parameter/Argument to JAR file

Here is what needs to be done if parameter/argument want to be passed to the JAR file:

public class Convert {
    public Convert() {
        super();
    }

    public static void main(String[] args) {
        try{
                String inputFile = args[0];
            }
            catch(Exception e) {
                e.printStackTrace();
            }
  }
}

[JAVA] How to Run JAR file

To run jar file:
java -jar <jar file name>

[Singapore] [lobang] LINE Popup Store give away

LINE Popup store is now opening it's so called pop up store in front of Wisma Atria building, Orchad.

They are giving away LINE Characters' balloon for FREE. Of course you have to queue to get one of them.

Characters available in balloons are brown, cony, Sally and moon.

Other than balloon, there are also other giveaways, such as plush doll, ear cap,and sticker voucher.

And if you would like to buy any of Line character, the popup store sells them as well.

They are there until 22 May 2014, so if you are one of the fans m, besure to visit them before the date above.

[singapore] [lobang] FREE NETS FlashPay EZ-Link card

Today 18th May 2014, NETS FlashPay give away a free NETS FlashPay EZ-LINK card. Grab it before it's gone. 

Oh yes, they are located at Cathay Cineleisure Orchad.