Veolia Cognos Interview
Questions
1. What is a Parameter map and what is the use
2.
3.
4.
5.
Best practice of FM
Did you seen in current FM, and what is the difference in OLD FM and New FM
what is the difference between Query Studio and Report Studio
I want the report like when i click in Dept. 10 , i can see in Dept. 10 details in
below of the report
Self Drill through
6. What is the use of Conditional formatting
7. Conditional blocks
8. What are the securities in FM and explain about those
9. How to do the Language translation in FM
10.
In Report studio ,how to get the top 20 employees in using list
report
Row number if only list
Rank
Running-count
11.
How to display, Report Type, Revenue current year, Revenue
Previous Year in a report. Available items from FM are Report id, Report
type, Year, Revenue in FM.
Create 2 dataitems
DI 1 if (Year = extract(year, current_date))
DI 2 - if (Year = extract(year, current_date)-1)
12.
How to display, product line, product type, and % quantity by
product line.
Quantity
Total(qty for product line)
% = Quantity/ Total(qty for product line)
13.
More complex scenario based questions on report studio. More
questions on how to add display complex columns, and complex data.
14.
SQL queries
15.
Steps to build complex reports and active reports from scratch.
16.
How to improve the performance of the report at report studio
17.
How to improve the performance of the report at FM
18.
Explain one scenario how to use conditional formatting
[Link] you explain @ your Previous Project
[Link] between Union and Join
21.
Steps to Create a new report using Technical Spec Doc
22.
How to improve the performance of the report at report level
23.
What are the best practices in FM
[Link] to calculate the Percentage of Quantity columns
Refer Q 12
[Link] size in your Ex Company Project
Friday, March 20, 2015
L&T Infotech Proprietary
Page 1 of 7
[Link] roles and responsibility in your ex project
[Link] is the feedback on Finance session given by Rapheal
[Link] you think do you need some more sessions on different domain to understand
the VWT business?
[Link] to hide the column in the report output if the field doesnt have any
data.
Last name First Name (Count(first name) > 0)
[Link] to show the column in the report output if the field doesnt have any
data.
[Link] knowledge on previous projects
[Link] Project knowledge on FM1 and FM2
[Link] in current Veolia project
[Link] required in TDD of Veolia FM migration Project
35.
Performance tuning in report studio and FM
[Link] a HR domain which model is best suited
[Link] on Active reports
[Link] features on cognos
39.
Given a table T1 with product values p1, p2, p3, p4 and another
table T2 with Product values p1,p2,p3 and Revenue data 100,200,300.
How can we generate all rows of product i.e p1,p2,p3,p4 in report
studio.
Option 1: Left Outer Join
Option 2: Union
Query 1:
Product
Revenue DI with 0
Query 2:
Product
Revenue
[Link] of joins used in framework manager
[Link] are differences between query studio and report studio.
[Link] we have prompts created in query studio
[Link] current Veolia FM suitable for adhoc reporting purpose in query studio
44.
Given Product line, Product type and Sales amount. How to fetch
%sales for product type in report studio.
45.
Given Product line, Product type and Sales amount. How to fetch
first top 5 product types in report studio.
46.
How to populate top 5 clients for a company.
[Link] steps for report bursting using report studio.
[Link] a user wants to save report in cognos connection, how its can be achieved.
[Link] of security in FM and explain in detail.
[Link] is mater detail relationship
[Link] between Aggregate function in the Tool bar and the one in the
Properties of the given query item
[Link] to display the flop three records in the list
[Link] about yourself?
Friday, March 20, 2015
L&T Infotech Proprietary
Page 2 of 7
[Link] concepts
[Link] tuning in report studio and FM
[Link] in current project?
[Link] Validation standards?
[Link] between Full Latis and Refubished Latis Models
[Link] knowledge on previous projects
[Link] to view two different reports for two different users
[Link] Project knowledge on FM1 and FM2
[Link] in current Veolia project
[Link] tuning in report studio and FM
[Link] of joins used in framework manager
[Link] are differences between query studio and report studio.
[Link] we have prompts created in query studio
[Link] current Veolia FM suitable for adhoc reporting purpose in query studio
[Link] Product line, Product type and Sales amount. How to fetch %sales for
product type in report studio.
[Link] Product line, Product type and Sales amount. How to fetch first 5 product
types in report studio.
[Link] a user wants to save report in cognos connection, how its can be achieved.
[Link] of security in FM and explain in detail.
[Link] is mater detail relationship
[Link] choices
[Link] variable
[Link] Bursting, Camid
[Link] Query item, Percentage Calculation
[Link] reporting tool among Cognos and SSRS
[Link] between Full Latis and Refurbished Latis Models
[Link] practice to create FM model
[Link] in Migration project
[Link] to create a report by using VWT Technical Specification Document
[Link] issues of FM and Report studio
[Link] of Raffel's session
[Link] practice to develop Report
[Link] practices for Framework Manager development
[Link] to handle complex report.
[Link] knowledge on previous projects
[Link] tuning in report studio and FM
89.
How will your approach be to design or architect new complex
reports for a new system, like CRM or HR.
[Link] of joins used in framework manager
[Link] current Veolia FM suitable for adhoc reporting purpose in query studio
[Link] Product line, Product type and Sales amount. How to fetch %sales for
product type in report studio.
[Link] Product line, Product type and Sales amount. How to fetch first 5 product
types in report studio.
[Link] steps for report bursting using reportstudio.
[Link] is mater detail relationship
Friday, March 20, 2015
L&T Infotech Proprietary
Page 3 of 7
[Link] other bi tools comparison
[Link] is conditional formatting
[Link] to implement securities in FM and Reports
[Link] to handle language options in FM
100.
How to handle language options only in Report studio, and not in FM.
101.
what is camid? Bursting Possibilities.
102.
framework manager performance improvement
103.
Report Validation standards?
104.
Report preparation procedures?
105.
Comparison Of Report Studio and Query Studio
106.
Cognos10 Vs Cognos 8
107.
Master detail Vs Drill through comparison, advantages
108.
domain Knowledge of Services and manufacturing industry?
109.
Active reports knowledge
110.
Framework Security and Cognos portal Securtiy
111.
Drill through, Bookmark Drillthrough and Masterdetail
Relationship
112.
Performance Management
113.
Life Cycle Manager
114.
Usage of outer joins - scenarios where outer joins would be the reply
expected.
115.
About VWT Technical Specificaton Document
116.
Steps to create a report by using VWT Technical Specification Document
117.
Scenario on static voices (How to add ' ALL' to the prompt)
118.
how to know the name of the user who is running the report
Friday, March 20, 2015
L&T Infotech Proprietary
Page 4 of 7
Thanis Interview
1 Tell about yourself?
2 Explain any one report which you work from scratch? Elaborate both
functionally and technically?
3 How to display, Report Type, Revenue current year, Revenue Previous Year
in a report. Available items from FM are Report id, Report type, Year,
Revenue in FM.
4 How to display, product line, product type, and % quantity by product line.
5 Difference between Master Detail Relationship & Drill through?
6 Scenario:
I have a list with 2 column company, revenue as its column, need to
use prompt to filter my list by company. Please let me which
methodology should you use to ensure high performance?
7 Difference between Join & Union?
8 How to add ALL to prompt button? What filter condition you use to ensure
the usability of ALL filter in main query?
9 Performance tuning in report studio?
10 What is bursting? What is CAMID? How do you burst report using
directories entries?
Javids Interview
1.
2.
3.
4.
5.
6.
7.
8.
9.
Introduce Yourself
Specify your roles and responsibilities
Could you tell about the old report you designed
Could you pick from the old report designs, the complex report you
designed
If there is a performance issue in my report, what will be ur approach?
Explain about your FM experience
Aggregation functions Where will you use?
Query Studio and Report Studio 3 Differences/limitations. Which feature
in specific is not available in QS when compared to RS etc
I would like to create a report with 3 Pages in PDF format.
Page 1: PT, PL, Revenue
Page 2: Revenue by Country
Page 3: Production of each Country
Which tool will you use and why?
10.
I would like to produce a report in PDF. I have Country prompt, 1
Crosstab and 1 Chart, In my crosstab, I am displaying the below columns.
Friday, March 20, 2015
L&T Infotech Proprietary
Page 5 of 7
Which tool will you use? If answer is Report Studio, next question is Why
Not Query Studio?
PT, PL, Qty, Rev, %of each PT.
11.
One Left Outer Join Scenario
12.
Tell me scenarios where you display conditional formatting within
Report Studio
13.
How to use variable in RS? When you will use it?
14.
What about Conditional block?
15.
Burst Management Explain. When will you use?
Lakshmi Reddy Interview
1.
2.
3.
4.
5.
Introduce urself
Explain about ur current project and roles and responsibilities
Tell me one complex scenario which u did in current project
Can you talk about Conditional features?
What kind of active report u did in current project (If you have hands on
experience)
6. I have crosstab, in rows I have product types (p1, p2, p3) and columns I
have countries like India, US, France and revenue as measure. I want to
design my report like I want to show product types like p3, p2 and p1. How
you can approach to implement this in Cognos (They are expecting sorting
on product type, but it is based on condition)
7. I want to generate chart which will show revenue by product by country.
Which chart u can use to achieve this?
8. Given a table T1 with product values p1, p2, p3, p4 and another table T2
with Product values p1, p2, p3 and Revenue data 100,200,300. How can
we generate all rows of product i.e. p1, p2, p3, p4 in report studio.
9. Scenario on static voices (How to add ' ALL' to the prompt)
10.
How we can create prompts in Cognos and types of prompts in
Cognos
11.
I have a prompt which is showing all products in prompt. If I select
few products in prompt I want to show only those products in report. If I
didn't select any products in prompt, I want to show all products in report.
How you can achieve this in Cognos report studio
12.
In package I have product type in product dimension and I have year
in year dimension and I have revenue in sales dimension. I want design
report like product type, Revenue for current year, Revenue for Previous
Year in a report. How u can approach to design this report
13.
What are the types of variables available in Cognos and explain
about conditional variables in Cognos (Better to explain all like Render
variable, Style Variable, Conditional styles and Text Source Variable and
Block Variable)
Friday, March 20, 2015
L&T Infotech Proprietary
Page 6 of 7
14.
I have a prompt, which is showing all country names. How u can
design the prompt to improve the performance. How u can approach on
this?
15. Scenarios on conditional block, Render variables and conditional
formatting
Friday, March 20, 2015
L&T Infotech Proprietary
Page 7 of 7
