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
- 11907 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 |
what r the filters in fwm and report studio
Can you define folder?
what is the use of layout calculation?
What is conditional styling? a.format applied based on filter b.format applied based on user c.format applied based on on condition d.all the above 2. For a company X, actual revenue and budgeted revenue are captured in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff levels of granularity (Fact_Act is month and budget @ quarter leve )and there is one common Time dimension, A report is created to show the actual and budgeted revenue 2gther but the data for budgeted is wrong. Which should be doing for rectifing the error? a. create determinants for month and quarter b. join the two table facts into a single fact c. Create 2 time dimensions @ FM d. Need to create 2 separate reports as the required info cant be shown using a single report. 3. Template in a Query Studio? a. sample Data set b. CSS c. A standard that applies for all reports d. None of the listed options 4.you are a report author @ the Company, which sells sporting equipment 5. Sales person in different regions each need a report showing sales target for each country. which of the following is the best way to distribut? a. Email b. Bursting c. storing in public folders d. All the above. 6. I)A query subject behave as a dimensional in one query and fact in other query. ii) Queries with more than one fact results in stitched query. iii) Cognos identifies a query subject as Fact based only on the measure a. ii only b. i only c. both i and ii d. iii only 7. what is meant by pivoting? a. making a stacked set b. swapping rows into columns c. making column as filter d. none of the above 8. A report cant be viewed in which? a. CSV b. XML c. ASCII d. Excel 9.A user wants to retriv all products which are not sold for last X days. Which prompt is used? a. Time b. Value c. Text d. Interval 10. Dispatcher? a.routes request to appropriate services and start services b. routes request to appropriate services c.starts all service d. none of the abv Frenz Please help me out !!! :) Thanks in Advance
what is fact less fact give me proper example?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
Can you define set to be cardinality?
------------------What is Focalpoint?
How to Reset Pagenumbers in one report.
How will you migrate your reports to QA environment?
hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........
how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?
Teradata 
