Interested to Buy Any Domain ? << Click Here >> for more details...
can any body clesrly explain about types of query
subjects.that is data source query subject,model query
subject,stored procedure query subjects?
- 1 Answers
- 12508 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
how can we improve performance of the reports?
Are you aware of any limitations in Cognos?
we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer
-------------What is Coditional Prompting?
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
Explain what is the difference between native sql and cognos sql?
how u provide security to reports??how u provide security to packages ?
How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.
What is the use of Tree Prompt? Where it is used?Pls give me a real time example?
Hi, I am Searching on Cognos 10, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is asimcognos10@gmail.com. Hope you will help....
What is difference between drill through and drill down?
how many types of keys are there i.e primary key and foreign key etc..?
Teradata 
