Question { Wipro, 22830 }

3. Differences between Cognos Sql & Native Sql? What are
their Advantages and Disadvantages?

Answer

Cognos SQl:It improves the query subject performance .This
SQL works on any supported database.

Native SQL:It optimized the performacne and this SQL is
used for soecific database

Question { Satyam, 5830 }

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

Answer

We can report by adding SQL from an external source without
using Query items from Framework.
Steps:--
-->Create a new report with blank page
-->Pause the pointer over the query explorer button and
clink Queries.
-->In intersect objects pane,to build the SQL query drag
SQL to the query.
-->In properties pane double click the datasource property
and click data source
-->Double click SQl or MDx and type SQL
-->validate the SQL.
-->If SQL is valid,then Query items defined in SQl appear
in the data item pane.
-->From insertable pane click list or crosstab or chart or
repeater in working area.
-->Drag query items in to working area from data items tab.
-->save the report.

Question { TCS, 6934 }

how u publish the packages in framework manager

Answer

Package is nothing but subset of model information we can
publish ot by right clicking the package and click publish
package .Then package would be publiched to IBM cognos
connections.

Question { Bodhtree, 15251 }

what is the difference between a data item and a query item?

Answer

Query item is nothing but the coulmn of table or Query
subject.Where data item is report column which we use to
design report and retrive the data of user reqirement.