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
- 12495 Views
- I also Faced
- E-Mail Answers
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
-----------------What is Direct and Conventional loading?
What are the two types of framework manager?
what are the dimensions that you have in your current project?list them?
What are the main services provided by application tier?
How create measures and demensions?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Define metrics studio?
faq's on cognos
2. What functional area you worked on.
where you can save the report net documentation in our local system?
What is the metric store database?
