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 |
what is a query subjects item?
which type of project we r going to snowflake schema
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
what is sdibling function tell me the some functions
1. Can we import the cube into FWM? If yes how & what is the necessity to import it? 2. What is the use of TABULAR OBJECTS? Repeated Question
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
What is Bitmap Index?
10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list Rank Running-count
-------What are the Adv of Star Schema and Snow Flake Schema?
What are the methods by which it non-durable model could be changed into the durable model?
What is the difference between drill through, drill across?
What is cognos powerhouse?