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 |
Is cognos models are version compatible?
what do u mean by bridge group? where we r using this one?
Can you please tell me the limitation of Excel file when exporting from report to Excel? I can export to HTML and PDF but I can't export to Excel. The report is more than 13000 rows. When exporting to Excel, system can view it. After that, I save the report to an Excel file. The size of Excel file is more than 11 MB. But I can't view this file by Excel. Please help me to solve this problem. Thanks!
How is possible this scenario using in type-in prompt.?
Can i apply drill through on master detail relationship report?
what is the difference between list report and crosstab report?
Where do you edit cognos sql in report studio?
how to improve performance in report studio level
A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt
What is the size of the cube?
10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?
7. What is performance tuning?