In cognos reportnet
Native SQL is used for the single datasource to import the meta data
Cognos SQL used for multiple datasources to import the metadat.
What are the advantages of query studio compared to report studio?
The query studio is used to create adhoc reports, it is easy to understand the bussiness user.The report studio is mainly used to create proffessional and corporate reports, it is not like query studio it is having mainly 3 explorers those are page explorer,conditional explorer and variable explorer by using these it is working.
How do we provide security in frame work manager for a query subject?
procedure for providing security for query subject in frame work manager is:
select querysubject -> in properties pane select ->security filters(click on edit)a specify data security wizard appears->click on add groups -> cognosnamesspace(select users and groups wizard opens)
What is the use of tabular model,tabular SQL,tabular reference in real time application?
Tabular model: It is the basic list query. It contain the data items, filters and child tabular objects.
Tabular SQL: We can write and edit our own SQL
Tabular ref: It is a shortcut to another tabular object somewhere in another query within the same report specification.
Tabular set: Tabular set object returns a single result set using union, intersect or minus operator.