1. What is stiched Query
2. What is loop in Fm
3. Best practices in modeling in FM
4. Three types of SQL
5. Difference between pass-thro and native sql?
6. will usage of pass thro sql will improve the performance?
7. Complex problems fced in your project
8. performance tuning in reports

1. What is stiched Query 2. What is loop in Fm 3. Best practices in modeling in FM 4. Three types..

Answer / bob

1. What is stiched Query

Stitch query is a way in cognos to avoid full outer joins.
If you are trying to model a full outer join involving two
fact tables related through a common dimension table, note
that Cognos 8 will handle such situations using a stitch
query, which does not require that you model any of the
relationships as an outer join.

If you have a forecast for a new backpack called the Day
Hiker 3, you may not have any sales yet for that product.
You might have some sales for an older backpack, say the
Day Hiker 1, though you might not have forecast any sales
for it because it is no longer being promoted. The Day
Hiker 2 backpack might have both sales and forecast
information. If you create a report for products, sales,
and forecast, and if you have properly modeled the
situation, the report will produce a stitch query. That
stitch query will first retrieve the sales data for the Day
Hiker 1 and the Day Hiker 2 backpacks, as well as the
forecast information for the Day Hiker 2 and Day Hiker 3
backpacks. Stitching those two results sets together,
Cognos 8 will display that you have only sales for the Day
Hiker 1, sales and forecast for the Day Hiker 2, and only
forecast for the Day Hiker 3. This is effectively a full
outer join without having to model explicit outer joins in
the relationships among these tables. You will notice a
coalesce statement if you look at the generated SQL in a
report that uses a stitch query. (Unserstand the example)

2. What is loop in FM?

A Loop is a closed path (relation) that exists among 3 (or)
more tables. For example, if we have '3' tables P1, P2, P3
then, a loop exists among these tables only when we create
joins in the following fashion:
Loop: P1 -> P2 -> P3 ---> P1 (hence, forming a loop)
To resolve the above problem, we have to create a shortcut
(or) Alias to the Table P1.
No Loop: P1 -> P2 -> P3 -> Alias (or) Shortcut of P1
(Remember. Interviewer will ask you abt how to create short
cuts or alias and hw many of them are there; Prepare for
that also:))

3. Best practices in modeling in FM?

There are many best practices that you can use when
modelling your data. And, you have to go through some of
the web sites to get this info. I have collated a few of
them and they are project specific:

•Login as Read Only user and check out the model as local
copy, once the Model is ready and developed use the
licensed user to merge your changes
•Once the Model is updated please validate your Model by
generating report
•Add Description for the new version which is created by
you. Helps in tracking the changes.
•Re-Check the default value of a column once the Model is
•Provide Latin as character set if Unicode is not
•Provide the Owner Name for all objects, example EDW_DATA
(not development Owner Name: FIN3_ETL_TARGET)
•Specify the relationship among the objects, try not to
hang any objects.

Tell gthe interview that this were the giude lines in youer

4. Three types of SQL

There are there types of SQL in Cognos especially working
with FM. They are:

a) Native SQL: Native SQL is something that is generated as
per the terms of the SQL language. Here, all the iformation
are retrieved when going for select statement and hence
somtimes works as similar to Select * statement.

b) Cognos SQL: This SQL is generated by Cognos with some
modifications and have improved performance over Native SQl
since, it ensures that it is only going to retrieve trhe
values that are requested by you and not all.

c) Pass Through SQL: This tyoe of SQL is not at all
modified and sent to your DB for querying and hence, should
not be used as this degrades the performance when compared
to the Cognos SQL.

8. Performance tuning in reports:

1. Don’t use the Not in function in the query.
2. Check the Governor Settings.
3. Check the table qualifying and weighting.
4. Check the client/server balancing.
5. Avoid using complex calculations avoid complex
reportcheck filter condition, use less filter, avoid
unwanted calculation

Is This Answer Correct ?    12 Yes 1 No

Post New Answer

More Cognos Interview Questions

How to schedule the report twice in a day?

2 Answers   Cognizant,

What are the different types of important services used in cognos?

0 Answers  

For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?

5 Answers   TCS,

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..

0 Answers  

How applying "Level Span" in Cognos 8.3?

1 Answers  

While running the reports how can we hide totals if the users doesnot requie it?

3 Answers   Satyam,

what is loop in frameworkmanager ?

4 Answers   Texas,

These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com

4 Answers   IBM,

How do you Parametermap variables in Quiries?

0 Answers   TCS,

What do you understand by ‘ibm predictive maintenance and quality’?

0 Answers  

what is an outer join? difference between left outer join right outer join with an example?

1 Answers   HCL,

Can anyone tell me the step by step process how to connect cognos to oracle?

3 Answers