How can you improve performance in report studio level?
What is the difference between Cognos sql and Native sql?
How can you create cubes in framework manager?

Answers were Sorted based on User's Feedback



How can you improve performance in report studio level? What is the difference between Cognos sql a..

Answer / neelima

by using simple case statements and minimising the complex
calculations and applying the frequently used filter
conditions at the framework level instead of applying them
in the report level we can improve the performance.By
implementing distributed configuration we can improve the
performance.

we can create IQD's in the framework level and use these
IQD's to create cubes in powerplay.

Is This Answer Correct ?    12 Yes 3 No

How can you improve performance in report studio level? What is the difference between Cognos sql a..

Answer / ushasree

report studio performance depends on net work spead,
complex calculations,using not in operator,outterjoin.
Cognos SQL and Native SQL are two different types of SQL
generated by cognos tool. Native SQL is sub set or same as
Cognos SQL.
Native SQL contains only the functionality that got
executed at database end, apart from this Cognos SQL will
have the Locally processed logic as well.
we can create package using cube.Cube is a data source here.

Is This Answer Correct ?    15 Yes 10 No

How can you improve performance in report studio level? What is the difference between Cognos sql a..

Answer / durga

The performance of a report depends on the network speed
and as a developer the following things should be taken
care. Use less number of complex calculations in the
report. Avoid using of conditional blocks and also avoid
unions in the reports.

To create a cube we need to create an iqd. and use this
iqd to create a cube.

Is This Answer Correct ?    5 Yes 3 No

How can you improve performance in report studio level? What is the difference between Cognos sql a..

Answer / s ali

DMR is similar to cube. Has all member functions and drill down and roll up features. 

Is This Answer Correct ?    0 Yes 1 No

How can you improve performance in report studio level? What is the difference between Cognos sql a..

Answer / sergio

I don't know exactly why but it seems that parameters in the
filters badly affect performances. Does anybody know why?

Is This Answer Correct ?    4 Yes 7 No

How can you improve performance in report studio level? What is the difference between Cognos sql a..

Answer / madhoo

By using less number of filters, avoiding complex
calculations , and distributing configuration we can improve
performance in report studio ..........

cognos sql statement is created irrespective to database
but native sql statement is created respective to database
which is using .......

we can't create cubes in frame work manager ......there is
no other scope to create cube other than Power play
transformer....

If i am wrong ,point out me please...

It's madhoo

Is This Answer Correct ?    7 Yes 11 No

How can you improve performance in report studio level? What is the difference between Cognos sql a..

Answer / abc

u can create cube in FM using externalise property.

Is This Answer Correct ?    2 Yes 11 No

Post New Answer

More Cognos Interview Questions

Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com

16 Answers  


How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.

2 Answers   Satyam,


What are different events in Report studio?

0 Answers   Wipro,


I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?

5 Answers   SAIC,


What is main advantage datawarehousing over oracle?

0 Answers  






Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

0 Answers   IBM,


can any one say the which is the best performance in framework manager

1 Answers  


What do you understand by the term 'model durability'?

0 Answers  


actually we are migrating one project to ACTUATE business intelligence solution to COGNOS REPORTNEt? why the client want to migrate from ACTUATE to COGNOS REPORTNEt? what are the special features in COGNOS REPORTNEt?

1 Answers  


hi,dis is kumari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance

26 Answers   IBM,


What is difference between primary key and unique key constraints?

0 Answers  


What do you mean by Drill down and Drill Up?

0 Answers  


Categories