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.
The new features in Cognos Analytics are on trend with what organizations want from enterprise BI software. Some of this is aimed at competing products, such as Qlik and Tableau, which have a strong visual appeal and an emphasis on user self-service.