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)?
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
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
What are the batches and it’s details?
What are cognos connection initial page components?
What is a Folder?
what do u mean by bridge group? where we r using this one?
What is the difference between static and dynamic conditions?
What is Additive function?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate 5. Which type of report you build more, list, crosstab or
chart and why?
Helow,
i have a problem with runing-total function when i use it
for a calculate row (for example : i need to diplay a
running-total of total units ?) How to test a cube? Hi All,
I have 1.6 years of experience in cognos in India. I always
wanted to do a MS program to earn some money in US. But I
think I am little late in taking the decision. As If I have
to write my GRE it will be August or September of 2012 and
will have to apply for fall 2013 as fall 2012 admissions are
almost done now.
So my concern is how will be my career do if my MS is at
this stage,. i,.e. 3 years experience in Cognos and 2 years
MS program in and again looking for job in U.S. Have I been
too late in taking the call? I heard that MIS (Managing
Information Systems) is having very good placements now.
So guys, please advice me in taking the decision to have a
good career and also in terms of earning money as I have few
financial problems to solve (which I am hoping to solve when
I get job in US after completion of my MS program).
Thanks a lot friends. I really appreciate and thank one and
all for their valuable comments in this site. What are the message flows? what is the role of cognos comsultant?what actually it
means?pls reply