Cognos Report Studio: How to replace '1' and '0' with 'Yes' and 'No'

If you need to replace the values '1' and '0' with 'Yes' and 'No' in Cognos Report Studio you will need to add a new Data Item with an Expression Definition.

- Open the report in Cognos Report Studio and open the query in the query explorer.

- Add a new Data Item and use as Expression Definition:
if([Databasefield] <> '1')
then ('No')
else
('Yes')

- Now open the page explorer and add the Data Item as a column. You will now see a list containing Yes and No values.

Googles way of saying "Hey you talk funny but we will translate anything."

Midnight commander on Ubuntu server 8.04 LTE

Midnight Commander is not present after the initial install of Ubuntu server 8.04 LTE. Also installing with sudo apt-get install mc does not work.

To install MC you will need to install a key and add a repository.

To install the key type in terminal:
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys F82FBD49

To add the extra repository edit /etc/apt/sources.list and add the following two lines:
deb http://ppa.launchpad.net/zyv/ppa/ubuntu YOUR_DISTRO main
deb-src http://ppa.launchpad.net/zyv/ppa/ubuntu YOUR_DISTRO main
(As editor nano could be used.)

Now update with:
sudo apt-get update

Midnight Commander can now be installed with:
sudo apt-get install mc

Huawei E180 HSPA dongle on Ubuntu 9.10 Netbook Remix

There are many ways to do it wrong and this is the correct procedure to get a working Huawei E180 HSPA dongle with your Ubuntu 9.10 Netbook Remix netbook.

- Insert the dongle, then turn on the computer.
- Right-click the network icon and go to Edit Connections.


- Select Mobile Broadband Connection and click Add to set up a new Mobile Broadband Connection.


- The dongle is recognised as HUAWEI Technology HUAWEI Mobile, just press Forward.
- A country list appears, choose Netherlands and press Forward.
- A provider list appears, I tested with KPN Mobile and press Forward.
- A billing plan has to be chosen but there is only the Default choice, just press Forward.
- A resume of the settings appear, just press Apply.


- A settings screen appears, don't change anything just press Apply.


Now everything is set up.

- Click the network icon and click the Mobile Broadband called KPN Mobile Default 1

- A PIN is needed. (Only once during install) Give the correct PIN and press enter. (The PIN is saved.)

Wait a few seconds and you have internet.

No extra drivers or software need to be installed and everything works out of the box.