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
Answer / anish kumar
11. d. Measure set
12. c. Set Group span to Col B
13. c. No of Columns to be selected in a query
14. b. All the options
15. d. Choose the suppression as TOTAL is not NULL
16. a. Decision Stream
17. b.Aggregation type
18. No Option Is Given)
| Is This Answer Correct ? | 3 Yes | 1 No |
I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?
what is slowly growing dimension??
----------------Describe DWH Architecture?
what is stitched query???
what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running
What are the types of folder present in cognos?
What are the components of the report studio?
In which types of reports does the page breaks applicable in Cognos...?
How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?
Please explain the different stages in creating a report in cognos report net?
---------------Describe OLAP Reporting and RDBMS Reporting?
What is called Cognos powerplay?