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
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
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?
Name the types of report?
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.
What do you understand by the cognos?
What is drill down and slicing and dicing whats the difference between them?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
Which studio is used to create reports?
How security is concerned with Reportnet? Explain its implementing steps.
Give me any example of semi and non additive measures?
Can you define bitmap index?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
how can you get the errors in job? when loops are araised we get error?
What are the types of hierarchies?
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?