GeekInterview.com
Series: Subject: Topic:
Question: 98 of 218

What different kinds of SQL you can write at the report level
What is tabular SQL,Tabular Modal and Tabular Set

Asked by: sindhu1103 | Member Since Oct-2007 | Asked on: Nov 7th, 2007

View all questions by sindhu1103

Showing Answers 1 - 2 of 2 Answers
Nageswara Rao Nandigam

Answered On : Nov 11th, 2007

  There are two types of sql in Cognos Reportnet .They are Cognos Sql and Native Sql

Native Sql used for single datasource to import the meta data

Cognos Sql used for multiple data source to import the meta data


Tablur model:  It is the basic list query.It contain the data items,filters and child tablur objects.

Tablur SQL: We can write and edit our own SQL.

Tablur ref:  It is a shortcut to use another tablur object somewhere on another querywithin the same report specification.

Tablur Set: Tablur set returns a singleresultset using union,intersect and minus operators.

  
Login to rate this answer.
ranganadh

Answered On : Nov 23rd, 2007

View all answers by ranganadh

1.Cognos SQL

By default, Framework Manager uses Cognos SQL to create and edit query subjects. Cognos SQL adheres to SQL99 rules and works with all relational and tabular data sources. Framework Manager generates the most optimized SQL possible. In this way, Cognos SQL is preferable. Because query subjects in Framework Manager are similar to views in databases, the SQL for each

query subject must conform to the SQL99 rules that apply to views.

2.Native SQL

Native SQL is the SQL the data source uses, such as Oracle SQL. You can not use native SQL in a query subject that references more than one data source in the project. SQL specified in Framework Manager and processed by the database, whether native or pass-through, must be completely self-contained. It must not reference anything outside that SQL, such as database prompts, variables, or native formatting that would normally be supplied by the calling application.

3.Pass-Through SQL

Pass-through SQL lets you use native SQL without any of the restrictions the data source imposes on subqueries. This is because pass-through SQL query subjects are not processed as subqueries. Instead, the SQL for each query subject is sent directly to the data source where the query results are generated.

I think some body wrote about sql is wrong.

tabular model

An object that you can use to select query items for a report. A tabular model defines a simple list query. In the XML code for report specifications, tabular model is represented by the tabularModel element.

tabular reference

An object that you use to reference the tabular object of another query within the same report. In report specifications, it is represented by the tabularReference element.

tabular set

An object that merges rows from two tabular objects, usually tabular models. A tabular set

produces a single result set using union, intersect or except (minus) set operators.

In report specifications, tabular set is represented by the tabularSet element.

tabular SQL

An object that you use to specify a SQL statement that returns a result set. The SQL statement may be expressed by using syntax recognized by the native database, or by using Cognos SQL syntax.

In report specifications, tabular SQL is represented by the tabularSQL element.

ranganadhn@yahoo.com

Yes  2 Users have rated as useful.
  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.