11. Which is a collection of data defined in Analysis Studio
that can be saved and reused in the same analysis?

a. Custom set
b. Predefined set
c. Level based set
d. Measure set

12. In a list report in Report Studio there are
3 columns A,B,C and they are grouped by Col A. To show the
values of Col A for every value of Col B , which of
following steps should be taken?

a. Ungroup
b. Set Group span to Col A
c. Set Group span to Col B


13. Which of following cant be set as a Governer in FM?
a. no of tables to b selected in a query
b. Left outer joins
c. No of Columns to be selected in a query
d. Cross Product joins

14. Purpose of analysis studio?
a. To provide interactive reporting capability
b. All the options
c. To generate complex reports
d. To help in more trend analysis

15.How to suppress Nulls in Analysis Studio reports?
a. Choose the suppression as TOTAL > 0
b. Choose the suppression as TOTAL is NULL
c. Choose the suppression as TOTAL is ZERO
d. Choose the suppression as TOTAL is not NULL

16.Frame work Manager cant import Metadata from which of
folowing?
a. Decision Stream
b. XML datasource
c. Impromptu Catalogs
d. Excel Sheets


17. In a report, to perform aggregation using aggregator
expression, what should we use?

a.Aggregation LIst
b.Aggregation type
c.Aggregation mode
d. None

18. What is the role for gateways?


Thanks in Advance