Interested to Buy Any Domain ? << Click Here >> for more details...
what is filter?give me one example that you created a report
in your project?
- 3 Answers
- 6763 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / arun kiran
We use filter to view limited data. For eg:
a list report with two columns country and revenue
eg: china 1235939
india 40393493
japan 938743739
US 32478327
UK 9420834028
if you drag a filter in query explorer and in expression box
you typed country = 'japan'.. if you run the report you will
be able to view only japan 938743739. you limited data to
japan. if you want to see for two or three or more use IN
function
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / piggynet
Filters are used to secure,limit or restrict the data. for
examples
if we only want to see product name and revenue by product
you can use the filter. (filtering data)
if we want to show regional manager sales data only for
his region we can user filter on region column (restricting
data)
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / naresh
filter is a condition to restrict the data as per the user
requirement.
we have 2 filters 1. detailed filter-it reflects
individual data items
2. summary filter-it reflects aggregated
data
ref: www.mycognos.webs.com for any other issues.
| Is This Answer Correct ? | 3 Yes | 0 No |
I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?
How do we implement Check Box Prompt in COgnos Report Studio?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What is set to be Cognos configuration?
Is it possible to join multiple Databases in a Catalog?
-----------With out using DrillThrough how to do Reports?
What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?
please please give me some banking calculations in framework manager.
how to improve performance in report studio level
What is the model filter?
What are the steps to import the two data sources in framework manager?
Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith
Teradata 
