I have just installed compiz through the YaST2 software manager. It all downloaded and installed OK as I can see it in the Kickoff Application Launcher. But although I have set the configuration for cube rotate, when I point and click to different desktops on the task bar, the switch is without rotation.
xorg-x11-driver-video is the rpm that contains the Intel and many other graphic drivers. Its not the actual driver. Do you know if it is using the VESA or the Intel graphic driver in use ?
If you have the Intel driver in use, then assuming everything is configured correctly (which it is by default) there is not much you can do, other than perhaps try a custom xorg.conf file or try a cutting edge mesa and cutting edge xorg-x11-driver-video. If you have the vesa driver in use, then you could switch to using the Intel driver.
Do you have an /etc/X11/xorg.conf file ? openSUSE-11.2 does not need that file for many hardware devices but it has been known to fail to configure the hardware device properly in some cases.
If you look in the /var/log/Xorg.0.log file, you should be able to tell if your PC is using the Vesa or Intel driver by entries such as (==) Intel () Intel or (==) Vesa () Vesa