Interested to Buy Any Domain ? << Click Here >> for more details...
Part 1 : Cognos
1.What are the technologies that are used in cognos?
2.What are complex reports?
3.What is page break?
4.What is layout component?
5.How do you use extract function?
6.What is the use of Crosstab space?
7.What is Rank()?
8.What is the use of Query calculation and layout
calculation?
9.What is Slicer and Dicer?
10.How can you create users in Cognos?
11.What is last child member?
12.What is the use of Conditional blocks?
13.What is Conditional Formatting?
14.What is group span?
15.In which types of reports does the page breaks
applicable? Is it applicable in excel reports?
16.I want to show a up arrow and down arrow image in cross
tab report, if the revenue is > 5000 (up arrow) and if
<5000 (down arrow)? How will you achieve this?
17.What are types of Filters in RS? What is Summary Filter
and Detail Filter?
18.What is Cast Function?
19.How will you create prompts for the example like this :
In a single report I want
a) List report (Need a prompt for this) b) Crosstab report
(Need a separate prompt for this) c) Chart ()(Need a
separate prompt for this)
Part II : Framework Manager (FM)
1. What is Determinant in FM?
2. What is Cardinality?
3. What are the types of filters used in FM?
4. Can we create cubes with Relational Data sources?
5. What is Aliasing and Shortcut?
6. What is Session Parameter & Parameter Maps?
7. How many types of securities that we have in FM?
8. What is Data Security in FM?
Part III : Data warehousing
1.What are various types of Schemas?
2.What is Star Schema and Snow Flow Schema? Difference
between both?
3.What is surrogate key?
Part IV : Databases
1.What are NVL Functions?
2.What is left outer join? Give an Example?
3.Can we straightaway use the tables that we have in the
database instead of creating the package’s FM and making
use of them, through Report Studio (RS)?
- 2 Answers
- 12755 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / pavan
you could use native sql in report studio to build your
report directly using the tables from databse. how ever it
will slows the report performance
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is difference between informatica power mart and power center?
What are all the types of indexes in Cognos?
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?
What is the difference between low affinity and high affinity connections?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
What is an olap designer?
------------------What is Inline Query?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
What actually a project contains?
how you provide security to reports? How you provide security to packages ?
----------------------What are the User Securities?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
What do you mean by drill across?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
How do you improve the performance of the Cognos Analytics report
