can any body clesrly explain about types of query
subjects.that is data source query subject,model query
subject,stored procedure query subjects?

Answer Posted / sunitha

Three types of query subjects are there:
1.default datasource querysubject
2.model querysubjects
3.stored procedure querysubjects.

1.Datasource querysubject:-Datasoure query subjects contain
sql statements that directly reference data in a single
datasource.Framework manager automatically creates a
datasource querysubject for each table and view that you
import into model.

2.Model querysubjects:-Querysubjects which created from
model (querysubjects & queryitems)sources are called model
querysubjects.

3.Stored procedures:-Querysubjects which created from Stored
procedures are called Stored procedure querysubjects.

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com

3687


Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4421


Name the types of report?

726


What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

2329


What do you understand by the cognos?

715


What is drill down and slicing and dicing whats the difference between them?

752


how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?

2043


Which studio is used to create reports?

830


How security is concerned with Reportnet? Explain its implementing steps.

1805


Give me any example of semi and non additive measures?

725


Can you define bitmap index?

796


what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2074


how can you get the errors in job? when loops are araised we get error?

1871


What are the types of hierarchies?

768


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

746