what is filter?give me one example that you created a report
in your project?
- 1 Answers
- 4831 Views
- HCL, IBM, I also Faced
- E-Mail Answers
Answer / palzkumar
Filter is a condition which restricts the amount
of data displayed in the report.
Eg: You have history data from year 2000 to 2008. But
your report is to display only the "monthly trend for year
2007", in such scenario you will have to put filter in year
= 2007.
-palz-
| Is This Answer Correct ? | 7 Yes | 0 No |
Why cognos scenario is used?
Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?
How to select multiple values from type-in prompt?
What is a Datastore in Cognos?
How to join multiple db in catalog?
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 are the different ways of adding data in Transformer?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?
How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?
I have a report with list and cross tab in same page,How do you restrict one user can see only the list and other user can see both?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
Teradata 
