1.
Which function would you use to extract the word "pants" from the product name "casual pants" of the Product Name field?
2.
Which two are calculation context types?
3.
Which Web Intelligence viewer panel should you use to create links to documents by browsing to the file without typing any syntax?
4.
You use the Last Refresh Date cell from the Templates in the Report Manager on your report page. You then reformat the cell as Tuesday, January 22, 2008. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?
5.
You have a regional sales report with State, City and Sales Revenue dimensions. You want to create a variable that excludes State from the output context. Which output statement should you use?
6.
Which combination of functions should you use to convert the string "13/11/46 12:00:00 AM" to "Wednesday 13 Nov 1946"?
7.
How much impact does data tracking have on the data size of a Web Intelligence document (WID) Compared to the same document without data tracking?
8.
Which panel should you use to create sub-queries?
9.
You use the Last Refresh Date cell from the Templates in the Report Manager on your report page. You then reformat the cell as Tuesday, January 22, 2008. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?
10.
Which operator should you use to control the output context of a calculation that is relevant to the different environment levels within your document?