In a triangle, we use terms like adjacent and opposite. These refer to sides in relation to angles. In our musical triangle, the drummer is at one angle in the back. This side, where the audience is, is called the opposite side.
Trunc is database function, try using round for numeric values, or change the Processing of Query to database.
We are using the Impromptu 7.4. And I found i can only connect the one oracle instance,even it switch the cognos.ini in c:\windows directory. Could you some body give me some suggestion. Or how to set up the cognos.ini. I attach the Sample (Maybe the format is wrong)