Tuesday, May 24, 2011

How to wireless problem on the Asus EEE PC 1000L with Ubuntu 11

It seems that with every new version of Ubuntu there is a problem with the wireless card and its drivers on the Asus EEE PC 1000L. The card in the Asus EEE PC 1000L is a Ralink RT2860.
(To check if this card is in your system type 'lspci')

After installing Ubuntu 11.04 Natty Narwhal it seems to work but after a reboot the connection cannot be made or the system tries to reconnect every minute or so.
Installing 'wifi radar' helps (Dont know why.) but the connection is not stable.

The solution is to add 2 lines to: /etc/modprobe.d/blacklist.conf

blacklist rt2800pci
blacklist rt2x00pci

Do a reboot and 11.04 is fine.

After upgrading to Ubuntu 11.10 the network is again gone.
The solution is to add the following line to: /etc/modules

rt2800pci

Do a reboot and 11.10 is fine again for about six months.

Friday, February 25, 2011

How to count only certain data in Cognos Report Studio?

Sometimes a count needs to be made on data that needs to meet certain requirements.
There are several ways to accomplish this. Here are two examples.


Example 1:

COUNT ( IF ( [FrameworkField] <= 2700 ) THEN (1) ELSE (0) )



Example 2:

CASE WHEN ( [FrameworkField] <= 2700 ) THEN (1) ELSE (0) END


Put either of these in a 'data-item'.
You can now use it in a list and do a Total on it.

Tuesday, February 15, 2011

How to strip the time from a date_time in Cognos Report Studio

Edit the definition of the date/time field in Framework Manager.

cast( [field in framework] as DATE )