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
- 1 Answers
- 5846 Views
- I also Faced
- E-Mail Answers
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 |
My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.
My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 2 3 11 22 33 111 222 333
10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list Rank Running-count
After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate<fromdate its an error. How can we generate the user defined error message for this type of error
Can you define confirmed dimension?
What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.
Hi Friends,what are The Advantages In Cognos 10 Compared To Cognos 8.4?Enhancements in Cognos 10? Please Ans Me Pls
when can i use the STAR Schema and SNOWFLAKE Scgena
How security is concerned with Reportnet? Explain its implementing steps.
write a query to display to 10 max record from the employee table?
What is the difference between List and Cross tab? Could some on explain with an example..
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
Teradata 
